Uploaded image for project: 'Empire-DB'
  1. Empire-DB
  2. EMPIREDB-212

MySQL Nested Union bad syntax

    XMLWordPrintableJSON

    Details

      Description

      If you try to create a union with several tables:

      select 1 UNION select 2 UNION select 3

      the DBDatabaseDriverMySQL driver generates:

      ( (select 1) UNION (select 2)) UNION (select 3)

      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.

        Attachments

        1. DBDatabaseDriverMySQL.groovy
          3 kB
          Ivan Arrizabalaga Getino

          Activity

            People

            • Assignee:
              doebele Rainer Döbele
              Reporter:
              ivan.arrizabalaga Ivan Arrizabalaga Getino
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: