[
https://issues.apache.org/jira/browse/EMPIREDB-212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14151483#comment-14151483
]
Ivan Arrizabalaga Getino commented on EMPIREDB-212:
---------------------------------------------------
Hi Francis,
the attachment is just a 'not-so-ugly' patch but I guess that the changes
should be applied to the original class
(http://svn.apache.org/viewvc/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java).
Hope it helps!
Ivan.
> MySQL Nested Union bad syntax
> -----------------------------
>
> Key: EMPIREDB-212
> URL: https://issues.apache.org/jira/browse/EMPIREDB-212
> Project: Empire-DB
> Issue Type: Bug
> Components: CodeGenerator
> Affects Versions: empire-db-2.4.2
> Reporter: Ivan Arrizabalaga Getino
> Labels: mysql, nested, union
> Attachments: DBDatabaseDriverMySQL.groovy
>
>
> If you try to create a union with several tables:
> {quote}
> select 1 UNION select 2 UNION select 3
> {quote}
> the DBDatabaseDriverMySQL driver generates:
> {quote}
> ( (select 1) UNION (select 2)) UNION (select 3)
> {quote}
> and MySQL does NOT support nested UNIONs.
> If could solved by changing the anonymous class in
> *DBDatabaseDriverMySQL.createCombinedCommand* but it should be done by
> default.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
