[
https://issues.apache.org/jira/browse/EMPIREDB-212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ivan Arrizabalaga Getino updated EMPIREDB-212:
----------------------------------------------
Attachment: DBDatabaseDriverMySQL.groovy
Since I needed a quick fix I opted for extending DBDatabaseDriverMySQL
overriding 'createCombinedCommand'.
> 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)
