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/19 04:28:20 UTC

[jira] [Reopened] (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 reopened 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
>
>
> 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)