Red Hat Bugzilla – Bug 163694
Parser issue with subqueries involving unions
Last modified: 2013-07-02 23:06:08 EDT
Description of problem:
There is a known issue with the supported version of mysql 4.1.10a. The parser
mis-reads a query that has a union inside a subquery. This has been fixed in
mysql 4.1.11. More information is contained on the official mysql site.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Feed the following query into mysql -
CREATE TABLE t1 (a int not null, b char (10) not null);
INSERT INTO t1 VALUES(1,'a'),(2,'b'),(3,'c'),(3,'c');
SELECT * FROM ((SELECT * FROM t1 LIMIT 1) UNION (SELECT * FROM t1 LIMIT 1)) a;
Error - #1248 - Every derived table must have its own alias
| a | b |
| 1 | a |
1 row in set (0.01 sec)
mysql 4.1.12 will be in RHEL4 U2.
An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on the solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.