RE: union operator problems in MySQL v3.23?

[Lopez David E]

glenn

Union is 4.0 feature.

david 

Notwithstanding end-of-life status, is there an issue in MySQL 
v3.23 r.e. the union operator?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

union operator problems in MySQL v3.23?

[Glenn Gillis]

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

--
Thanks,

Glenn Gillis
ELAW U.S. Information Technology Manager
Environmental Law Alliance Worldwide
http://www.elaw.org

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: union operator problems in MySQL v3.23?

[Jim Winstead]

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
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: union operator problems in MySQL v3.23?

[Glenn Gillis]

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
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]