diff options
author | unknown <thek@adventure.(none)> | 2007-05-18 14:29:24 +0200 |
---|---|---|
committer | unknown <thek@adventure.(none)> | 2007-05-18 14:29:24 +0200 |
commit | ad4da53510fe17b7b20912753232719fd8d3e033 (patch) | |
tree | 4f8326572903715f38fff117eb849e5a7360745c /mysql-test/r/sp-vars.result | |
parent | bf1198a91354a659a812a7490ac180768b19fe05 (diff) | |
parent | 755ae21b826d6e644560b0ad397eb46cd7191369 (diff) | |
download | mariadb-git-ad4da53510fe17b7b20912753232719fd8d3e033.tar.gz |
Merge adventure.(none):/home/thek/Development/cpp/bug26277/my51-bug26277
into adventure.(none):/home/thek/Development/cpp/mysql-5.1-runtime
mysql-test/t/sp-vars.test:
Auto merged
sql/item_func.cc:
Auto merged
sql/item_func.h:
Auto merged
mysql-test/r/sp-vars.result:
manual merge
Diffstat (limited to 'mysql-test/r/sp-vars.result')
-rw-r--r-- | mysql-test/r/sp-vars.result | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/r/sp-vars.result b/mysql-test/r/sp-vars.result index 41cccccb001..f5420a62f63 100644 --- a/mysql-test/r/sp-vars.result +++ b/mysql-test/r/sp-vars.result @@ -1202,3 +1202,29 @@ after substr str_remainder after substr b,c DROP PROCEDURE bug27415_text_test| DROP PROCEDURE bug27415_text_test2| +drop function if exists f1; +drop table if exists t1; +create function f1() returns int +begin +if @a=1 then set @b='abc'; +else set @b=1; +end if; +set @a=1; +return 0; +end| +create table t1 (a int)| +insert into t1 (a) values (1), (2)| +set @b=1| +set @a=0| +select f1(), @b from t1| +f1() @b +0 1 +0 0 +set @b:='test'| +set @a=0| +select f1(), @b from t1| +f1() @b +0 1 +0 abc +drop function f1; +drop table t1; |