[MDEV-8380] Subquery parse error Created: 2015-06-25  Updated: 2015-10-06  Resolved: 2015-10-06

Status: Closed
Project: MariaDB Server
Component/s: Parser
Affects Version/s: 5.5, 10.0, 10.1
Fix Version/s: 10.1.8

Type: Bug Priority: Major
Reporter: Sergey Vojtovich Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-8909 union parser cleanup Closed
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

 Comments   
Comment by Oleksandr Byelkin [ 2015-08-18 ]

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)

—

Comment by Oleksandr Byelkin [ 2015-08-31 ]

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

—

Comment by Oleksandr Byelkin [ 2015-09-14 ]

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

—

Comment by Oleksandr Byelkin [ 2015-09-14 ]

pushed as mdev-8380

Comment by Sergei Golubchik [ 2015-10-06 ]

ok to push

Generated at Thu Feb 08 07:26:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.