Strange behaviour with PROCEDURE ANALYSE and subselect

Hi,

Ok, this case should never happen, but the result is rather strange :)

How-to-repeat :

mysql> SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE(1);
+------------+-----------+-----------+------------+--------- ---+------------
------+-------+-------------------------+--------+---------- ---------+
| Field_name | Min_value | Max_value | Min_length | Max_length |
Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std |
Optimal_fieldtype |
+------------+-----------+-----------+------------+--------- ---+------------
------+-------+-------------------------+--------+---------- ---------+
| 1 | 1 | 1 | 1 | 1 |
0 | 0 | 1.0000 | 0.0000 | NOT NULL |
+------------+-----------+-----------+------------+--------- ---+------------
------+-------+-------------------------+--------+---------- ---------+
1 row in set (0.00 sec)

=> this is ok

mysql> SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE((SELECT 1));
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

=> PROCEDURE ANALYSE is ignored ?

mysql> SELECT 1 FROM (SELECT 1) a PROCEDURE DONTCARE((SELECT 1));
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)

=> Well yes, it seems to be ignored :)

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

Re: Strange behaviour with PROCEDURE ANALYSE and subselect

Hi!

On Thu, Dec 05, 2002 at 11:46:24AM -0000, Jocelyn Fournier wrote:
[skip]
> mysql> SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE((SELECT 1));
> +---+
> | 1 |
> +---+
> | 1 |
> +---+
> 1 row in set (0.00 sec)

Thank you for bugreport. I fixed that bug (patch is committed & pushed).

[skip]

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