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