- Original Message -
From: "Kevin A. Burton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 15, 2004 7:23 PM
Subject: unions will full column names won't work in 4.1.7
> Not sure if this is a bug... probably should be.
>
> On
At 16:23 -0800 12/15/04, Kevin A. Burton wrote:
Not sure if this is a bug... probably should be.
On 4.1.18 I can run:
4.1.18?
I assume you mean 4.0.18. Anyway, what you describe is according to
the documentation:
http://dev.mysql.com/doc/mysql/en/UNION.html
(SELECT * FROM FOO WHERE ID = 1)
UNION
(
Not sure if this is a bug... probably should be.
On 4.1.18 I can run:
(SELECT * FROM FOO WHERE ID = 1)
UNION
(SELECT * FROM FOO WHERE ID = 2)
ORDER BY FOO.COL_A
Which will work just fine
However when I use this query on 4.1.7 I get
ERROR 1250 (42000): Table 'ARTICLE' from one of the SELECTs cannot
