metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bobby (JIRA)" <j...@apache.org>
Subject [jira] [Created] (METAMODEL-116) Improve sqlite support
Date Wed, 11 Mar 2015 15:50:38 GMT
Bobby created METAMODEL-116:
-------------------------------

             Summary: Improve sqlite support
                 Key: METAMODEL-116
                 URL: https://issues.apache.org/jira/browse/METAMODEL-116
             Project: Apache MetaModel
          Issue Type: Improvement
    Affects Versions: 4.3.0-incubating
            Reporter: Bobby


The following features are not correctly handled by default QueryRewriter for sqlite :
- Text and Blob SQL types are considered as VARCHAR
1. Create a table with Text and Blob columns
2. Get column list and check each column JDBC type: columns of type Text and Blob are recognized
as VARCHAR

- Query maxRows works, but returns (maxRows + 1) rows
1. Create a table with at least 3 rows
2. Query this table with maxRows set to 1 : 2 rows are returned
3. Query this table with maxRows set to 2 : 3 rows are returned

- Table names are not escaped properly when needed
1. Create a table with name "Test table"
2. Get table list: "Test table" is correctly returned
3. Query this table: SQL error [SQLITE_ERROR] SQL error or missing database (near "table":
syntax error)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message