Re: UNION in derived table not supported ?

Hi!

On Fri, Nov 29, 2002 at 11:20:01PM -0000, Jocelyn Fournier wrote:
> Hi,
>
> I'm wondering if it's a known limitation or a bug :
>
> How-to-repeat :
>
> mysql> SELECT 1 FROM (SELECT 1 UNION SELECT 1);
> ERROR 1064: You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'UNION SELECT 1)' at line 1

It is limitation.

> As well :
>
> mysql> SELECT (SELECT 1 UNION SELECT 1);
> +---------------------------+
> | (SELECT 1 UNION SELECT 1) |
> +---------------------------+
> | 1 |
> +---------------------------+
> 1 row in set (0.00 sec)
>
> is supported but
>
> mysql> SELECT ((SELECT 1) UNION (SELECT 1));
> ERROR 1064: You have an error in your SQL syntax. Check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'UNION (SELECT 1))' at line 1
>
> is not.

It is bug already reported by you. We are not forgot about it.

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13152@lists.mysql.com
To unsubscribe, e-mail

UNION in derived table not supported ?

Hi,

I'm wondering if it's a known limitation or a bug :

How-to-repeat :

mysql> SELECT 1 FROM (SELECT 1 UNION SELECT 1);
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'UNION SELECT 1)' at line 1

As well :

mysql> SELECT (SELECT 1 UNION SELECT 1);
+---------------------------+
| (SELECT 1 UNION SELECT 1) |
+---------------------------+
| 1 |
+---------------------------+
1 row in set (0.00 sec)

is supported but

mysql> SELECT ((SELECT 1) UNION (SELECT 1));
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'UNION (SELECT 1))' at line 1

is not.

Regards,
Jocelyn


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13149@lists.mysql.com
To unsubscribe, e-mail