Mailing-List: contact dev-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@ignite.apache.org
Date: Wed, 2 Nov 2016 09:46:58 +0000 (UTC)
From: "Anghel Botos (JIRA)" <jira@apache.org>
To: dev@ignite.apache.org
Message-ID: <JIRA.13017143.1478080012000.155806.1478080018483@Atlassian.JIRA>
In-Reply-To: <JIRA.13017143.1478080012000@Atlassian.JIRA>
References: <JIRA.13017143.1478080012000@Atlassian.JIRA> <JIRA.13017143.1478080012609@arcas>
Subject: [jira] [Created] (IGNITE-4163) Wrong SQL generated by
 org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect#loadCacheSelectRangeQuery
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Wed, 02 Nov 2016 09:47:00 -0000

Anghel Botos created IGNITE-4163:
------------------------------------

             Summary: 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


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)