[
https://issues.apache.org/jira/browse/EMPIREDB-212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14151179#comment-14151179
]
Francis De Brabandere commented on EMPIREDB-212:
------------------------------------------------
Hi Ivan, would you mind sharing the code that fixes the issues?
> 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
>
> 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)
