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

Subquery parse error

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • 10.1.8
    • Parser
    • None
    • 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

          relates to

          Task - A task that needs to be done. MDEV-8909 union parser cleanup

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            svoj Sergey Vojtovich created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Fix Version/s 10.1 [ 16100 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ]
            sanja Oleksandr Byelkin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin added a comment -

            revision-id: d07b780db239a909e667edf5657e3633e80d1451 (mariadb-10.1.6-23-gd07b780)
            parent(s): 5fe8b747e9e3440f2f746accca0eb11e287a6713
            committer: Oleksandr Byelkin
            timestamp: 2015-08-18 13:28:17 +0200
            message:

            MDEV-8380: Subquery parse error

            Part1: port of first mysql patch (0034963fbf199696792491bcb79d5f0731c98804)

            —

            sanja Oleksandr Byelkin added a comment - revision-id: d07b780db239a909e667edf5657e3633e80d1451 (mariadb-10.1.6-23-gd07b780) parent(s): 5fe8b747e9e3440f2f746accca0eb11e287a6713 committer: Oleksandr Byelkin timestamp: 2015-08-18 13:28:17 +0200 message: MDEV-8380 : Subquery parse error Part1: port of first mysql patch (0034963fbf199696792491bcb79d5f0731c98804) —
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.7-2 [ 12 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            sanja Oleksandr Byelkin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin added a comment -

            revision-id: 93a7c11c51e2f5c0ca98600924172e452b6188b6 (mariadb-10.1.6-24-g93a7c11)
            parent(s): d07b780db239a909e667edf5657e3633e80d1451
            committer: Oleksandr Byelkin
            timestamp: 2015-08-31 13:10:01 +0200
            message:

            MDEV-8380: Subquery parse error

            backport mysql parser fixes
            0034963fbf199696792491bcb79d5f0731c98804
            5948561812bc691bd0c13cf518a3fe77d9daf920

            —

            sanja Oleksandr Byelkin added a comment - revision-id: 93a7c11c51e2f5c0ca98600924172e452b6188b6 (mariadb-10.1.6-24-g93a7c11) parent(s): d07b780db239a909e667edf5657e3633e80d1451 committer: Oleksandr Byelkin timestamp: 2015-08-31 13:10:01 +0200 message: MDEV-8380 : Subquery parse error backport mysql parser fixes 0034963fbf199696792491bcb79d5f0731c98804 5948561812bc691bd0c13cf518a3fe77d9daf920 —
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Sergei Golubchik [ serg ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.7-2 [ 12 ] 10.1.7-2, 10.1.8-1 [ 12, 13 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Oleksandr Byelkin [ sanja ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin added a comment -

            revision-id: 4430d555a34b8471fde9615dc2f8c301f319f65e (mariadb-10.1.6-23-g4430d55)
            parent(s): 5fe8b747e9e3440f2f746accca0eb11e287a6713
            committer: Oleksandr Byelkin
            timestamp: 2015-09-14 16:20:14 +0200
            message:

            MDEV-8380: Subquery parse error

            backport mysql parser fixes
            0034963fbf199696792491bcb79d5f0731c98804
            5948561812bc691bd0c13cf518a3fe77d9daf920

            —

            sanja Oleksandr Byelkin added a comment - revision-id: 4430d555a34b8471fde9615dc2f8c301f319f65e (mariadb-10.1.6-23-g4430d55) parent(s): 5fe8b747e9e3440f2f746accca0eb11e287a6713 committer: Oleksandr Byelkin timestamp: 2015-09-14 16:20:14 +0200 message: MDEV-8380 : Subquery parse error backport mysql parser fixes 0034963fbf199696792491bcb79d5f0731c98804 5948561812bc691bd0c13cf518a3fe77d9daf920 —
            sanja Oleksandr Byelkin added a comment -

            pushed as mdev-8380

            sanja Oleksandr Byelkin added a comment - pushed as mdev-8380
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Sprint 10.1.7-2, 10.1.8-1 [ 12, 13 ] 10.1.7-2, 10.1.8-1, 10.1.8-2 [ 12, 13, 14 ]
            serg Sergei Golubchik made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.7-2, 10.1.8-1, 10.1.8-2 [ 12, 13, 14 ] 10.1.7-2, 10.1.8-1, 10.1.8-3 [ 12, 13, 15 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.1.7-2, 10.1.8-1, 10.1.8-3 [ 12, 13, 15 ] 10.1.7-2, 10.1.8-1, 10.1.8-3, 10.1.8-4 [ 12, 13, 15, 16 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            serg Sergei Golubchik made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Oleksandr Byelkin [ sanja ]
            serg Sergei Golubchik added a comment -

            ok to push

            serg Sergei Golubchik added a comment - ok to push
            serg Sergei Golubchik made changes -
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin made changes -
            Component/s Parser [ 10201 ]
            Fix Version/s 10.1.8 [ 19605 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 70331 ] MariaDB v4 [ 149306 ]

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.