bk commit into 5.0 tree (jimw:1.1913) BUG#7293

[Jim Winstead]

Below is the list of changes that have just been committed into a local
5.0 repository of jimw. When jimw does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet
  1.1913 05/04/28 14:46:54 jimw@stripped +2 -0
  Add regression test for calling SOUNDEX() within stored procedure.
  The bug appears to have already been fixed. (Bug #7293)

  mysql-test/t/sp.test
    1.115 05/04/28 14:46:51 jimw@stripped +17 -0
    Add regression test for bug 7293

  mysql-test/r/sp.result
    1.120 05/04/28 14:46:51 jimw@stripped +16 -0
    Add results for new test

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	jimw
# Host:	rama.(none)
# Root:	/home/jimw/my/mysql-5.0-7293

--- 1.119/mysql-test/r/sp.result	2005-04-22 03:53:42 -07:00
+++ 1.120/mysql-test/r/sp.result	2005-04-28 14:46:51 -07:00
@@ -3041,4 +3041,20 @@
 delete from t1|
 drop procedure bug9004_1|
 drop procedure bug9004_2|
+drop procedure if exists bug7293|
+insert into t1 values ('secret', 0)|
+create procedure bug7293(p1 varchar(100))
+begin
+if exists (select id from t1 where soundex(p1)=soundex(id)) then
+select 'yes';
+end if;
+end;|
+call bug7293('secret')|
+yes
+yes
+call bug7293 ('secrete')|
+yes
+yes
+drop procedure bug7293|
+delete from t1|
 drop table t1,t2;

--- 1.114/mysql-test/t/sp.test	2005-04-22 03:53:42 -07:00
+++ 1.115/mysql-test/t/sp.test	2005-04-28 14:46:51 -07:00
@@ -3723,6 +3723,23 @@
 drop procedure bug9004_1|
 drop procedure bug9004_2|
 
+#
+# BUG#7293: Stored procedure crash with soundex
+#
+--disable_warnings
+drop procedure if exists bug7293|
+--enable_warnings
+insert into t1 values ('secret', 0)| 
+create procedure bug7293(p1 varchar(100))
+begin
+  if exists (select id from t1 where soundex(p1)=soundex(id)) then
+    select 'yes';
+  end if;
+end;| 
+call bug7293('secret')| 
+call bug7293 ('secrete')| 
+drop procedure bug7293|
+delete from t1|
 
 #
 # BUG#NNNN: New bug synopsis