[MDEV-6719] UNION ORDER BY incorrect error Created: 2014-09-10  Updated: 2014-09-11  Resolved: 2014-09-11

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.39, 10.0.13, 10.1.0
Fix Version/s: 10.1.1

Type: Bug Priority: Critical
Reporter: Oleksandr Byelkin Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-334 [backport] Implement UNION ALL withou... Closed

 Description   

In union.test we have

--error 1054
select a from t1 union select a from t2 order by t2.a;

The error (ER_BAD_FIELD_ERROR) is incorrect, it should be ER_TABLENAME_NOT_ALLOWED_HERE.
It is happens because of reading incorrect SELECT option during ORDER BY processing.

 Comments   
Comment by Oleksandr Byelkin [ 2014-09-11 ]

Fixed as part of MDEV-334 patch. (the fix passed to Igor)

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