Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6719

UNION ORDER BY incorrect error

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Critical
        • Resolution: Fixed
        • Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.39, 10.0.13, 10.1.0
        • Fix Version/s: 10.1.1
        • Component/s: None
        • Labels:
          None

          Description

          In union.test we have

          --error 1054
          select a from t1 union select a from t2 order by t2.a;

          The error (ER_BAD_FIELD_ERROR) is incorrect, it should be ER_TABLENAME_NOT_ALLOWED_HERE.
          It is happens because of reading incorrect SELECT option during ORDER BY processing.

            Gliffy Diagrams

              Attachments

                Issue Links

                is part of

                Task - A task that needs to be done. MDEV-334 [backport] Implement UNION ALL without usage of a temporary table (MWL#44)

                • Critical - Crashes, loss of data, severe memory leak.
                • Closed

                  Activity

                  Hide
                  Permalink
                  sanja Oleksandr Byelkin added a comment - - edited

                  Fixed as part of MDEV-334 patch. (the fix passed to Igor)

                  Show
                  sanja Oleksandr Byelkin added a comment - - edited Fixed as part of MDEV-334 patch. (the fix passed to Igor)

                    People

                    • Assignee:
                      sanja Oleksandr Byelkin
                      Reporter:
                      sanja Oleksandr Byelkin
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: