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)
