Bug in subselect and * with MySQL-4.1

Hi,

How-to-repeat :

mysql> SELECT (SELECT * FROM (SELECT 'test' a,'test' b) a);
+------------------------------------------+
| (SELECT * FROM (SELECT 'test' a,'test' b) a) |
+------------------------------------------+
| 0 |
+------------------------------------------+
1 row in set (0.00 sec)

=> this should display a cardinality error ?

mysql> SELECT (SELECT a,b FROM (SELECT 'test' a,'test' b) a);
ERROR 1239: Cardinality error (more/less than 1 columns)

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-thread13418@lists.mysql.com
To unsubscribe, e-mail

Re: Bug in subselect and * with MySQL-4.1

Hi!

On Wed, Jan 08, 2003 at 02:36:51AM -0000, Jocelyn Fournier wrote:
> Hi,
>
> How-to-repeat :
>
> mysql> SELECT (SELECT * FROM (SELECT 'test' a,'test' b) a);
> +------------------------------------------+
> | (SELECT * FROM (SELECT 'test' a,'test' b) a) |
> +------------------------------------------+
> | 0 |
> +------------------------------------------+
> 1 row in set (0.00 sec)
>
> => this should display a cardinality error ?
>
> mysql> SELECT (SELECT a,b FROM (SELECT 'test' a,'test' b) a);
> ERROR 1239: Cardinality error (more/less than 1 columns)

Thank you for bugreport. I fixed it now (committed).

--
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-thread13541@lists.mysql.com
To unsubscribe, e-mail