Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
-
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
-
MDEV-8909 union parser cleanup
-
- Closed
-
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 errorPart1: port of first mysql patch (0034963fbf199696792491bcb79d5f0731c98804)
—