[jira] [Created] (METAMODEL-116) Improve sqlite support

["Bobby (JIRA)" <ji...@apache.org>]

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)