diff options
| author | unknown <pem@mysql.comhem.se> | 2004-03-29 12:29:06 +0200 |
|---|---|---|
| committer | unknown <pem@mysql.comhem.se> | 2004-03-29 12:29:06 +0200 |
| commit | 5c7f368b78df504e4874cc2df1897efeb7b0bd48 (patch) | |
| tree | ea8b1736d87f67c0b1ce0193f6690d83fc4d1fd6 /mysql-test/t/sp-error.test | |
| parent | 7456a3e92f94552bf22210e81d03a0708b66f721 (diff) | |
| download | mariadb-git-5c7f368b78df504e4874cc2df1897efeb7b0bd48.tar.gz | |
Fixed BUG#3287: Stored Procedure Case Statement Not SQL:2003 Compliant.
include/mysqld_error.h:
New error code for missing ELSE in SP CASE statement.
include/sql_state.h:
New error code for missing ELSE in SP CASE statement.
mysql-test/r/sp-error.result:
Test case for missing ELSE in SP CASE statement.
mysql-test/t/sp-error.test:
Test case for missing ELSE in SP CASE statement.
sql/share/czech/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/danish/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/dutch/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/english/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/estonian/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/french/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/german/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/greek/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/hungarian/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/italian/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/japanese/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/korean/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/norwegian-ny/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/norwegian/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/polish/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/portuguese/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/romanian/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/russian/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/serbian/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/slovak/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/spanish/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/swedish/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/share/ukrainian/errmsg.txt:
New error message for missing ELSE in SP CASE statement.
sql/sql_yacc.yy:
Generate run-time error instruction when no ELSE in SP CASE statement.
Diffstat (limited to 'mysql-test/t/sp-error.test')
| -rw-r--r-- | mysql-test/t/sp-error.test | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test index cbff9b37a11..ad96d0b403b 100644 --- a/mysql-test/t/sp-error.test +++ b/mysql-test/t/sp-error.test @@ -473,6 +473,33 @@ call bug2329_2()| drop procedure bug2329_1| drop procedure bug2329_2| +# +# BUG#3287 +# +create function bug3287() returns int +begin + declare v int default null; + + case + when v is not null then return 1; + end case; + return 2; +end| +--error 1326 +select bug3287()| +drop function bug3287| + +create procedure bug3287(x int) +case x +when 0 then + insert into test.t1 values (x, 0.1); +when 1 then + insert into test.t1 values (x, 1.1); +end case| +--error 1326 +call bug3287(2)| +drop procedure bug3287| + drop table t1| delimiter ;| |