You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Konstantinov (JIRA)" <ji...@apache.org> on 2016/08/22 09:00:32 UTC
[jira] [Closed] (IGNITE-3708)
MySQLDialect.loadCacheSelectRangeQuery return statement that actually not
supported by MySQL
[ https://issues.apache.org/jira/browse/IGNITE-3708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Pavel Konstantinov closed IGNITE-3708.
--------------------------------------
> MySQLDialect.loadCacheSelectRangeQuery return statement that actually not supported by MySQL
> --------------------------------------------------------------------------------------------
>
> Key: IGNITE-3708
> URL: https://issues.apache.org/jira/browse/IGNITE-3708
> Project: Ignite
> Issue Type: Bug
> Components: cache
> Affects Versions: 1.6
> Reporter: Alexey Kuznetsov
> Assignee: Pavel Konstantinov
> Priority: Blocker
> Fix For: 1.8
>
> Attachments: mysql-project-test.zip
>
>
> As range query we return: "SELECT %s FROM (SELECT %s, ROWNUM() AS rn FROM %s ORDER BY %s) WHERE mod(rn, ?) = 0"
> But MySQL failed with "com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Every derived table must have its own alias" and plus ROWNUM() seems not supported by MySQL.
> Also in JdbcPojoStore we must not swallow dialect exceptions we should at least print warnings.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)