Got error while trying compile with debug information (Select with Union)

soaron · Post by **soaron** » Mon 16 Jul 2007 08:53

Try this query:
http://dev.mysql.com/doc/refman/5.0/en/union.html

PROCEDURE test._union()
BEGIN
(SELECT REPEAT('a',1)) UNION (SELECT REPEAT('b',10));
END

Got this error message:

Duke · Post by **Duke** » Tue 17 Jul 2007 11:29

What is the MySQL server version?

soaron · Post by **soaron** » Tue 17 Jul 2007 11:56

5.0.41-community-nt

Duke · Post by **Duke** » Tue 04 Sep 2007 11:26

We've found the problem and we'll resolve it. As a workaround you can remove brackets around SELECT statements composing UNION.