Details
-
Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
10.2.1-1, 10.2.1-3, 10.2.1-4, 10.2.1-5
Description
This is a spin-off from MDEV-8380. The corresponding parser changes are too big to go into 10.1
This task will remove a few "Incorrect usage of ... and ..." errors and will return "syntax error" instead.
Example#1:
SELECT * FROM t1 LIMIT 1 UNION SELECT * FROM t1 LIMIT 1; |
ERROR 1221 (HY000): Incorrect usage of UNION and LIMIT
|
Example#2:
SELECT * FROM (SELECT * FROM t1 PROCEDURE ANALYSE()); |
ERROR 1221 (HY000): Incorrect usage of PROCEDURE and subquery
|
Example#3:
SELECT * FROM t1 NATURAL JOIN (SELECT * FROM t2 PROCEDURE ANALYSE()); |
ERROR 1221 (HY000): Incorrect usage of PROCEDURE and subquery
|
Example#4
SELECT (SELECT 1 FROM t1 PROCEDURE ANALYSE()) FROM t2; |
ERROR 1221 (HY000): Incorrect usage of PROCEDURE and subquery
|
Attachments
Issue Links
- is blocked by
-
MDEV-10030 sql_yacc.yy: Split table_expression and remove PROCEDURE from create_select, select_paren_derived, select_derived2, query_specification
- Closed
-
MDEV-10036 sql_yacc.yy: Split select_part2 to disallow syntactically bad constructs with INTO, PROCEDURE, UNION
- Closed
-
MDEV-10037 UNION with LIMIT ROWS EXAMINED does not require parentheses
- Closed
-
MDEV-10051 Fix subselect to return a syntax error instead of "Incorrect usage of UNION and LIMIT"
- Closed
-
MDEV-10078 sql_yacc.yy: Remove non-parenthesized SELECT from table_factor
- Closed
-
MDEV-10079 sql_yacc.yy: Remove non-parenthesized SELECT from table_ref
- Closed
-
MDEV-10080 Derived tables allow double LIMIT clause
- Closed
-
MDEV-10095 Fix derived table to return a syntax error instead of "Illegal usage of UNION and LIMIT"
- Closed
-
MDEV-10101 Wrong error message of SELECT 1 UNION (SELECT 1 FROM t1 GROUP BY 1 WITH ROLLUP)
- Closed
-
MDEV-10102 Disallow CREATE VIEW .. PROCEDURE ANALYSE() syntactically
- Closed
-
MDEV-10103 Disallow syntactically UNION SELECT .. PROCEDURE ANALYSE()
- Closed
-
MDEV-10109 Disallow syntactically INSERT .. SELECT .. {ORDER BY ..| LIMIT ..} .. UNION ..
- Closed
-
MDEV-10124 Incorrect usage of CUBE/ROLLUP and ORDER BY with GROUP_CONCAT(a ORDER BY a)
- Closed
- relates to
-
MDEV-8380 Subquery parse error
- Closed
-
MDEV-10028 Syntax error on ((SELECT ...) UNION (SELECT ...))
- Closed
-
MDEV-10035 DBUG_ASSERT on CREATE VIEW v1 AS SELECT * FROM t1 FOR UPDATE
- Closed
-
MDEV-10096 Behaviour of SQL_NO_CACHE in derived tables is not consistent
- Open
-
MDEV-10120 Wrong result of UNION .. ORDER BY GROUP_CONCAT()
- Closed
-
MDEV-10122 MariaDB does not support group functions in some contexts where MySQL does
- Closed