UNION is not broken; the syntax in the given comment is incorrect. You can do SELECT * FROM table UNION SELECT * FROM table or (SELECT * FROM table) UNION (SELECT * FROM table) but not SELECT * FROM table UNION (SELECT * FROM table)
On 8/4/05, Mike Johnson <[EMAIL PROTECTED]> wrote: > > Hi all, > > Is there anyone using version 4.1 that can verify or refute the claim > posted at the bottom of the upgrade notes here? > > http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html > > The user claims that UNION statements with parentheses are broken in > 4.1. That is, 'SELECT * FROM table1 UNION (SELECT * FROM table2)' or > something similar. > > We're looking to upgrade but find te claim a bit dubious as there's no > follow-up, no other mention, and I can't recall seeing anything on the > list about it. Can anyone perform a quick test or verify one way or the > other? I'd be much obliged. > > Thanks! > > -- > Mike Johnson Smarter Living, Inc. > Web Developer www.smartertravel.com <http://www.smartertravel.com> > [EMAIL PROTECTED] (617) 886-5539 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
