ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Konstantinov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-3708) MySQLDialect.loadCacheSelectRangeQuery return statement that actually not supported by MySQL
Date Fri, 19 Aug 2016 11:02:20 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-3708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Pavel Konstantinov updated IGNITE-3708:
---------------------------------------
    Assignee: Alexey Kuznetsov  (was: Pavel Konstantinov)

> 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: Alexey Kuznetsov
>            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)

Mime
View raw message