ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Konstantinov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-4163) Wrong SQL generated by org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect#loadCacheSelectRangeQuery
Date Fri, 11 Nov 2016 10:47:58 GMT

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

Pavel Konstantinov commented on IGNITE-4163:
--------------------------------------------

I've faced with the following issue while I'm tried to test with MS SQL Server
{code}
Caused by: java.lang.IllegalStateException: Failed to find column index for database field:
id1
        at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.columnIndex(CacheAbstractJdbcStore.java:796)
        at org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStore.buildBinaryObject(CacheJdbcPojoStore.java:250)
        at org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStore.buildObject(CacheJdbcPojoStore.java:136)
        at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:2047)
        at org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore$LoadCacheCustomQueryWorker.call(CacheAbstractJdbcStore.java:2003)
{code}

> Wrong SQL generated by org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect#loadCacheSelectRangeQuery
> ------------------------------------------------------------------------------------------------------------
>
>                 Key: IGNITE-4163
>                 URL: https://issues.apache.org/jira/browse/IGNITE-4163
>             Project: Ignite
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.7
>            Reporter: Anghel Botos
>            Assignee: Pavel Konstantinov
>         Attachments: IGNITE_4163_Fixed_load_range_queries_Review.patch, IGNITE_4163_Fixed_load_range_queries_for_MS_SQL_Server_.patch,
IGNITE_4163_Fixed_load_range_queries_for_different_databases.patch, IGNITE_4163_Oracle_specific_for_load_range_query_.patch
>
>
> The SQL statement generated by org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect#loadCacheSelectRangeQuery
looks like this:
> {{SELECT KEY_COLUMN_1,KEY_COLUMN_2 FROM (SELECT KEY_COLUMN_1,KEY_COLUMN_2, ROWNUM() AS
rn FROM SOME_TABLE ORDER BY KEY_COLUMN_1,KEY_COLUMN_2) WHERE mod(rn, ?) = 0}}
> For Oracle this is incorrect, as Oracle does not have a {{ROWNUM()}} function. For the
above query the following error is thrown: {{ORA-00923: FROM keyword not found where expected}}
> Regarding row numbering Oracle has:
> * a {{ROWNUM}} pseudocolumn, in which case the query should have {{ROWNUM AS rn}}
> * a {{ROW_NUMBER()}} function, in which case the query would become more complicated.
See https://docs.oracle.com/database/121/SQLRF/functions170.htm#SQLRF06100 for more details
about {{ROW_NUMBER()}}
> Please make the neccessary adjustments to either {{BasicJdbcDialect}} or {{OracleDialect}}
so that a correct query is produced.



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

Mime
View raw message