From: Scott Noyes (snoyesgmail.com)
Date: Thu Aug 04 2005 - 12:24:25 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <mikesmarterliving.com> 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>
> mikesmarterliving.com (617) 886-5539
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=snoyesgmail.com
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]