[
https://issues.apache.org/jira/browse/IGNITE-3708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15427995#comment-15427995
]
Pavel Konstantinov commented on IGNITE-3708:
--------------------------------------------
Created a test project and database with table with 21 million of rows.
Test grid with only one node with 9 GB of heap.
Cache has OFFHEAP mode.
I was able to load maximum 10 millions of row.
It seems that MySQL driver fetching all result set in heap.
Attaching the test project.
> 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)
