empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Francis De Brabandere (JIRA)" <empire-db-...@incubator.apache.org>
Subject [jira] [Commented] (EMPIREDB-212) MySQL Nested Union bad syntax
Date Sun, 28 Sep 2014 19:00:33 GMT

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

Mime
View raw message