[#MDEV-10051] Fix subselect to return a syntax error instead of "Incorrect usage of UNION and LIMIT"

[MDEV-10051] Fix subselect to return a syntax error instead of "Incorrect usage of UNION and LIMIT" Created: 2016-05-10 Updated: 2016-05-23 Resolved: 2016-05-23
Status:	Closed
Project:	MariaDB Server
Component/s:	Parser
Affects Version/s:	5.5, 10.0, 10.1, 10.2
Fix Version/s:	10.2.1

Type:

Bug

Priority:

Major

Reporter:

Alexander Barkov

Assignee:

Alexander Barkov

Resolution:

Fixed

Votes:

Labels:

None

Issue Links:

Blocks
blocks	~~MDEV-8909~~	union parser cleanup	Closed

Sprint:

10.2.1-1, 10.2.1-2

Description

Queries like this:

SELECT EXISTS (SELECT * FROM t1 LIMIT 1 UNION ALL SELECT * FROM t2);

return

ERROR 1221 (HY000): Incorrect usage of UNION and LIMIT

We'll fix the grammar in sql_yacc.yy to return a syntax error instead.

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