Bug #2435 union with braces do not supported

Description:
union with braces do not supported, like 
select * from ((select * from t1 limit 1) union (select * from t1 limit 1)) a; 
cause error: query 'select * from (select * from t1 limit 1) union (select * 
from t1 limit 1) a' failed: 1247: Every derived table must have it's own alias 

How to repeat:
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;

This is a known problem with current parser generator (bison).

There is already one record on the same issue in this database.

Please fix this bug.  It is hindering a mission-criticle function of my application.

Antony, could you check whether there's an easy way to fix the grammar ?

hello,

we have a similar problem, the following query works in oracle 9 but brings the same error as above in mysql-standard-4.1.7-sun-solaris2.8-sparc-64bit:

SELECT tag t, c, l
FROM accessrule
LEFT JOIN
        (SELECT tag as t, SUM(count) AS c, MAX(last) AS l
        FROM connection WHERE fw='fw7'
        GROUP BY tag
        )
ON tag=t
WHERE rulebase='fw7a'
ORDER BY l DESC

I take the review with permission by Sergei. However, a second reviewer is required.

Does the fix solve the additional problem mentioned by arnim.rupp@lhsystems.com?

See also BUG#7360

Reviewed by Ingo, he's ok with cset mentioned.

New changeset committed which will allow more parentheses in union components.

Patch applied to 4.1 repository, 
ChangeSet@1.2183, 2005-02-13 22:35:52+00:00

Permits subsequent union elements to be in multiple parentheses. Initial select statement can not be in parentheses.

Noted in 4.1.11 changelog.