OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: "union" operator problems in MySQL v3.23?

From: Glenn Gillis (glennelaw.org.test-google-a.com)
Date: Fri Jan 11 2008 - 18:38:00 CST

Jim Winstead wrote, On 1/11/2008 12:54 PM:
> On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote:
>> Notwithstanding end-of-life status, is there an issue in MySQL v3.23
>> r.e. the "union" operator?
>>
>> My installation returns a syntax error on any query containing the union
>> operator, even with the sample queries provided in the documentation:
>>
>> mysql> SELECT REPEAT('a',1) UNION SELECT REPEAT('b',10);
>> ERROR 1064: syntax error near 'UNION SELECT REPEAT('b',10)' at line 1
>
> Support for UNION was not added until 4.0.
>
> Jim Winstead
> MySQL Inc.

Thanks, Jim and David. I guess it's about time to upgrade!
--
Glenn

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql