diff options
author | unknown <kostja@bodhi.local> | 2006-07-15 01:04:51 +0400 |
---|---|---|
committer | unknown <kostja@bodhi.local> | 2006-07-15 01:04:51 +0400 |
commit | 5677612aea6098001846c128dcefc357a013c171 (patch) | |
tree | 06e46da942509b2dbfc21491adfe0fd8a3ec7db0 /mysql-test/r/sp-vars.result | |
parent | 906cd90d936e384af54c1f4e75ebb56bd2f6b148 (diff) | |
parent | 4c2db1bef100a1159f65d3fad0ec764727198e58 (diff) | |
download | mariadb-git-5677612aea6098001846c128dcefc357a013c171.tar.gz |
Merge bodhi.local:/opt/local/work/tmp_merge
into bodhi.local:/opt/local/work/mysql-5.1-runtime-merge-5.0
mysql-test/r/func_sapdb.result:
Auto merged
mysql-test/r/func_time.result:
Auto merged
mysql-test/r/sp-vars.result:
Auto merged
mysql-test/t/func_sapdb.test:
Auto merged
mysql-test/t/func_time.test:
Auto merged
sql/field_conv.cc:
Auto merged
sql/item.h:
Auto merged
sql/item_timefunc.cc:
Auto merged
sql/sp_head.cc:
Auto merged
sql/sql_lex.cc:
Auto merged
sql/sql_parse.cc:
Auto merged
sql/sql_show.cc:
Auto merged
mysql-test/r/information_schema.result:
Use local
mysql-test/t/information_schema.test:
Manual merge.
sql/sql_lex.h:
Manual merge.
Diffstat (limited to 'mysql-test/r/sp-vars.result')
-rw-r--r-- | mysql-test/r/sp-vars.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/sp-vars.result b/mysql-test/r/sp-vars.result index f620cd657f0..6335870caa9 100644 --- a/mysql-test/r/sp-vars.result +++ b/mysql-test/r/sp-vars.result @@ -1075,3 +1075,18 @@ SELECT f1(); f1() abc DROP FUNCTION f1; +DROP PROCEDURE IF EXISTS p1; +CREATE PROCEDURE p1() +BEGIN +DECLARE v_char VARCHAR(255); +DECLARE v_text TEXT DEFAULT ''; +SET v_char = 'abc'; +SET v_text = v_char; +SET v_char = 'def'; +SET v_text = concat(v_text, '|', v_char); +SELECT v_text; +END| +CALL p1(); +v_text +abc|def +DROP PROCEDURE p1; |