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: Jim Winstead (jimwmysql.com)
Date: Fri Jan 11 2008 - 14:54:47 CST

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.

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