empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ivan Arrizabalaga Getino (JIRA)" <empire-db-...@incubator.apache.org>
Subject [jira] [Updated] (EMPIREDB-212) MySQL Nested Union bad syntax
Date Mon, 29 Sep 2014 08:20:33 GMT

     [ 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)

Mime
View raw message