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

MySQL Nested Union bad syntax

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          Activity

            People

            • Assignee:
              doebele Rainer Döbele
              Reporter:
              ivan.arrizabalaga Ivan Arrizabalaga Getino

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment