diff options
| author | unknown <bell@sanja.is.com.ua> | 2003-10-24 17:28:32 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2003-10-24 17:28:32 +0300 |
| commit | ce2c46ddd6676960e0c002aa83c7913e85ebdc47 (patch) | |
| tree | 63bd3fb6c3566519729c8f88b30bbb74d936361e /mysql-test/t/variables.test | |
| parent | 5ee2807c4907d14fd97278e665b69717d3920226 (diff) | |
| download | mariadb-git-ce2c46ddd6676960e0c002aa83c7913e85ebdc47.tar.gz | |
support 'parallel' updates and rallback of whole statement in case of error in evalueting value which should be assigned
(BUG#1484)
mysql-test/r/variables.result:
test of swaping variables
mysql-test/t/variables.test:
test of swaping variables
sql/item_func.cc:
new method of user variables to pre-fetch value
sql/item_func.h:
new method of user variables to pre-fetch value
sql/set_var.cc:
check() methods fetch & store value
sql/set_var.h:
check() methods fetch & store value
Diffstat (limited to 'mysql-test/t/variables.test')
| -rw-r--r-- | mysql-test/t/variables.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test index 396fb3ac722..c53559ed4cf 100644 --- a/mysql-test/t/variables.test +++ b/mysql-test/t/variables.test @@ -263,3 +263,20 @@ drop table t1,t2; --error 1193 select @@xxxxxxxxxx; select 1; + +# +# swap +# +select @@global.max_user_connections,@@local.max_join_size; +set @svc=@@global.max_user_connections, @svj=@@local.max_join_size; +select @@global.max_user_connections,@@local.max_join_size; +set @@global.max_user_connections=111,@@local.max_join_size=222; +select @@global.max_user_connections,@@local.max_join_size; +set @@global.max_user_connections=@@local.max_join_size,@@local.max_join_size=@@global.max_user_connections; +select @@global.max_user_connections,@@local.max_join_size; +set @@global.max_user_connections=@svc, @@local.max_join_size=@svj; +select @@global.max_user_connections,@@local.max_join_size; +set @a=1, @b=2; +set @a=@b, @b=@a; +select @a, @b; + |