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] [Commented] (EMPIREDB-212) MySQL Nested Union bad syntax
Date Mon, 29 Sep 2014 08:23:33 GMT

    [ https://issues.apache.org/jira/browse/EMPIREDB-212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14151483#comment-14151483
] 

Ivan Arrizabalaga Getino commented on EMPIREDB-212:
---------------------------------------------------

Hi Francis, 
the attachment is just a 'not-so-ugly' patch but I guess that the changes should be applied
to the original class (http://svn.apache.org/viewvc/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/mysql/DBDatabaseDriverMySQL.java).

Hope it helps!
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
>              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