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