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

Subquery parse error

        Details

        • Type: Bug
        • Status: In Progress
        • Priority: Major
        • Resolution: Unresolved
        • Affects Version/s: 10.1, 10.0, 5.5
        • Fix Version/s: 10.1
        • Component/s: None
        • 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

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                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)

                —

                Show
                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) —
                Hide
                Permalink
                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

                —

                Show
                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 —
                Hide
                Permalink
                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

                —

                Show
                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 —
                Hide
                Permalink
                sanja Oleksandr Byelkin added a comment -

                pushed as mdev-8380

                Show
                sanja Oleksandr Byelkin added a comment - pushed as mdev-8380

                  People

                  • Assignee:
                    serg Sergei Golubchik
                    Reporter:
                    svoj Sergey Vojtovich
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 1 hour, 30 minutes
                      1h 30m

                        Agile