[jira] [Created] (IGNITE-3708) MySQLDialect.loadCacheSelectRangeQuery return statement that actually not supported by MySQL

["Alexey Kuznetsov (JIRA)" <ji...@apache.org>]

Alexey Kuznetsov created IGNITE-3708:
----------------------------------------

             Summary: 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: Andrey Novikov
            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)