| Bug #7293 | Stored procedure crash with soundex | ||
|---|---|---|---|
| Submitted: | 14 Dec 2004 19:31 | Modified: | 2 May 2005 19:07 |
| Reporter: | Peter Gulutzan | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.3-alpha-debug | OS: | Linux (SUSE 9.2) |
| Assigned to: | Jim Winstead | CPU Architecture: | Any |
[14 Dec 2004 19:46]
MySQL Verification Team
Thank you for the bug report.
[25 Mar 2005 21:22]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/23382
[28 Apr 2005 21:03]
Michael Widenius
Ok to push after minor changes: - change test table name from t77 to t1 - change name of procedure to bug7293 - Drop procedure before and after test
[28 Apr 2005 21:46]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/24464
[2 May 2005 19:07]
Jim Winstead
Fixed in 5.0.6.
Description: I create a stored procedure which has an EXISTS subquery which refers to SOUNDEX. I call the procedure twice, and the server crashes. If I use UPPER instead of SOUNDEX, no crash. How to repeat: delimiter // create table t77 (s1 varchar(100))// insert into t77 values ('secret')// create procedure a77(p1 varchar(100)) begin if exists (select * from t77 where soundex(p1)=soundex(s1)) then select 'w'; end if; end;// call a77('secret')// call a77 ('secrete')//