"Leonardo Francalanci" <[EMAIL PROTECTED]> wrote:
>> > v4.1.2? Where can I get it?
>> >
>>
>> You can install it from development source tree:
>> http://dev.mysql.com/doc/mysql/en/Installing_source_tree.html
>>
>> or wait when binaries will be available.
>
> I'll wait for binaries...
>
> At the moment even a query like
>
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy) UNION
> (SELECT * FROM REGULAR_copy)
>
> where REGULAR_copy is an empty table crashes mysql.
>
I wasn't able to repeat in on v4.1.2:
mysql> CREATE TABLE REGULAR_copy (id int);
Query OK, 0 rows affected (0.12 sec)
mysql> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy) UNION
-> (SELECT * FROM REGULAR_copy);
Empty set (0.00 sec)
Test it on 4.1.2 and let me know if these queries will crash MySQL server.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
