Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0, 10.1, 10.2
-
Fix Version/s: 10.2.1
-
Component/s: Parser
-
Labels:None
-
Sprint:10.2.1-2, 10.2.1-3
Description
This script:
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a INT); |
INSERT INTO t1 VALUES (1),(2),(3); |
SELECT * FROM (SELECT * FROM t1 LIMIT 1 LIMIT 2) t1; |
returns
+------+
|
| a |
|
+------+
|
| 1 |
|
| 2 |
|
+------+
|
Notice, there are two LIMIT clauses, and the first LIMIT clause is obviously ignored.
It should return a syntax error.
Attachments
Issue Links
- blocks
-
MDEV-8909 union parser cleanup
-
- Closed
-