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

Subquery parse error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5, 10.0, 10.1
    • Fix Version/s: 10.1.8
    • Component/s: Parser
    • Labels:
      None
    • Sprint:
      10.1.7-2, 10.1.8-1, 10.1.8-3, 10.1.8-4

      Description

      CREATE TABLE t1 (
      a INT
      );
      INSERT INTO t1 VALUES ( 2 );
      SELECT *
      FROM ( (SELECT a FROM t1 ORDER BY a) UNION (SELECT 1 as b ORDER BY b ) ) AS a1
      WHERE a1.a = 1 OR a1.a = 2;
      DROP TABLE t1;

      Fixed in MySQL, see revisions:
      0034963fbf199696792491bcb79d5f0731c98804
      5948561812bc691bd0c13cf518a3fe77d9daf920

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              svoj Sergey Vojtovich
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration