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] [Created] (EMPIREDB-212) MySQL Nested Union bad syntax
Date Mon, 15 Sep 2014 09:29:35 GMT
Ivan Arrizabalaga Getino created EMPIREDB-212:
-------------------------------------------------

             Summary: 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


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