[
https://issues.apache.org/jira/browse/IGNITE-3708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexey Kuznetsov reassigned IGNITE-3708:
----------------------------------------
Assignee: Pavel Konstantinov (was: Alexey Kuznetsov)
Pavel please test, that data will load correctly from MySQL and also do some
sort of load test, load for example 50_000_000 rows.
And check that most popular RDBMS (DB2, Oracle, Postgress, ...) also support
parallel load.
> 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)
