[jira] [Resolved] (EMPIREDB-212) MySQL Nested Union bad syntax

["Rainer Döbele (JIRA)" <em...@incubator.apache.org>]

     [ https://issues.apache.org/jira/browse/EMPIREDB-212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rainer Döbele resolved EMPIREDB-212.
------------------------------------
       Resolution: Fixed
    Fix Version/s: empire-db-2.4.4
         Assignee: Rainer Döbele

I have applied the change according to the solution provided by Ivan.
Thanks 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
>            Assignee: Rainer Döbele
>              Labels: mysql, nested, union
>             Fix For: empire-db-2.4.4
>
>         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)