Bug #18242 | MySQL Server aborts when Having clause added to Select in SP | ||
---|---|---|---|
Submitted: | 15 Mar 2006 0:20 | Modified: | 15 Mar 2006 0:56 |
Reporter: | Gordon Bruce | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.1.7 | OS: | Linux (Linux) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[15 Mar 2006 0:20]
Gordon Bruce
[15 Mar 2006 0:22]
Gordon Bruce
Sucessful query results
Attachment: Successful_Query_Results.txt (text/plain), 2.64 KiB.
[15 Mar 2006 0:24]
Gordon Bruce
Table definitions and err file contents
Attachment: Tables_and_err_file.txt (text/plain), 5.91 KiB.
[15 Mar 2006 0:26]
Gordon Bruce
Linux zeus 2.6.15-gentoo-r1 #10 SMP PREEMPT Tue Mar 7 15:36:28 MST 2006 i686 Intel(R) Xeon(TM) CPU 3.80GHz GenuineIntel GNU/Linux
[15 Mar 2006 0:56]
MySQL Verification Team
Thank you for the bug report. I was unable for to get the crash testing against the current source server: <cut> -> LEFT JOIN pbx_user_route_number AS prn5 -> ON (purt.sbsc_Username = prn5.sbsc_Username -> AND purt.purt_Sequence = prn5.purt_Sequence -> AND prn5.purn_Seq = 4 -> ) -> WHERE purt.sbsc_Username = Username -> AND purt_Enabled = 'Yes' -> HAVING IF(purt_Command = 'dial', LENGTH(number) >0, LENGTH(number) = 0); -> END// Query OK, 0 rows affected (0.07 sec) mysql> delimiter ; mysql> select version(); +------------------+ | version() | +------------------+ | 5.1.8-beta-debug | +------------------+ 1 row in set (0.00 sec) mysql> call Get_User_Route('3254101',NULL)\G *************************** 1. row *************************** username: 3254101 sequence: 0 number: SIP/3254102,SIP/3254123,SIP/3254127 command: Dial host: NULL context: NULL timeout: NULL url: NULL *************************** 2. row *************************** username: 3254101 sequence: 1 number: SIP/3254103,SIP/3254122 command: Dial host: NULL context: NULL timeout: NULL url: NULL *************************** 3. row *************************** username: 3254101 sequence: 2 number: SIP/3254104 command: Dial host: NULL context: NULL timeout: NULL url: NULL 3 rows in set (0.06 sec) Query OK, 0 rows affected (0.07 sec) mysql> call Get_User_Route('3254101','')\G *************************** 1. row *************************** username: 3254101 sequence: 0 number: SIP/3254102,SIP/3254123,SIP/3254127 command: Dial host: NULL context: NULL timeout: NULL url: NULL *************************** 2. row *************************** username: 3254101 sequence: 1 number: SIP/3254103,SIP/3254122 command: Dial host: NULL context: NULL timeout: NULL url: NULL *************************** 3. row *************************** username: 3254101 sequence: 2 number: SIP/3254104 command: Dial host: NULL context: NULL timeout: NULL url: NULL 3 rows in set (0.02 sec) Query OK, 0 rows affected (0.02 sec) mysql> call Get_User_Route('3254101','555')\G *************************** 1. row *************************** username: 3254101 sequence: 0 number: SIP/3254102,SIP/3254123,SIP/3254127 command: Dial host: NULL context: NULL timeout: NULL url: NULL 1 row in set (0.02 sec) Query OK, 0 rows affected (0.02 sec) mysql> call Get_User_Route('3254101','5552')\G *************************** 1. row *************************** username: 3254101 sequence: 0 number: SIP/3254102,SIP/3254123,SIP/3254127 command: Dial host: NULL context: NULL timeout: NULL url: NULL 1 row in set (0.01 sec) Query OK, 0 rows affected (0.01 sec) mysql>