ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexey Kuznetsov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-3708) MySQLDialect.loadCacheSelectRangeQuery return statement that actually not supported by MySQL
Date Thu, 18 Aug 2016 11:17:22 GMT
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)

Mime
View raw message