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

["Kasper Sørensen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/METAMODEL-116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14358275#comment-14358275 ] 

Kasper Sørensen commented on METAMODEL-116:
-------------------------------------------

Hi Bobby,

Thanks for reporting this. To make your request clearer, could it maybe be an option that you make unittests methods in SqliteTest that demonstrate the issues?

Kasper

> 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)