Page 1 of 1

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

Posted: Mon 16 Jul 2007 08:53
by soaron
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:
Image

Posted: Tue 17 Jul 2007 11:29
by Duke
What is the MySQL server version?

Posted: Tue 17 Jul 2007 11:56
by soaron
5.0.41-community-nt

Posted: Tue 04 Sep 2007 11:26
by Duke
We've found the problem and we'll resolve it. As a workaround you can remove brackets around SELECT statements composing UNION.