diff options
| author | unknown <jimw@mysql.com> | 2005-05-02 10:20:54 -0700 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-05-02 10:20:54 -0700 |
| commit | 2d998575d3ad173a01c6eac6f9471ae770380c97 (patch) | |
| tree | 8c4870c358e60bb28510225897d785ec4d2a986a | |
| parent | bd24e892dc23d775363819d3daeb97e87b5a8d37 (diff) | |
| parent | b318122ce6aa2408db89c6f7ee09addd389aa1ac (diff) | |
| download | mariadb-git-2d998575d3ad173a01c6eac6f9471ae770380c97.tar.gz | |
Merge mysql.com:/home/jimw/my/mysql-5.0-7293
into mysql.com:/home/jimw/my/mysql-5.0-clean
| -rw-r--r-- | mysql-test/r/sp.result | 16 | ||||
| -rw-r--r-- | mysql-test/t/sp.test | 17 |
2 files changed, 33 insertions, 0 deletions
diff --git a/mysql-test/r/sp.result b/mysql-test/r/sp.result index 9f28acbcb7d..a5cdee4b1bf 100644 --- a/mysql-test/r/sp.result +++ b/mysql-test/r/sp.result @@ -3041,4 +3041,20 @@ Warning 1265 Data truncated for column 'id' at row 2 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; diff --git a/mysql-test/t/sp.test b/mysql-test/t/sp.test index 7b3bff4eb55..2e45d1c6cd1 100644 --- a/mysql-test/t/sp.test +++ b/mysql-test/t/sp.test @@ -3723,6 +3723,23 @@ delete from t1| 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 |