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/r/variables.result | |
| 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/r/variables.result')
| -rw-r--r-- | mysql-test/r/variables.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result index d65b44e7846..52ea28e6076 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -365,3 +365,27 @@ ERROR HY000: Unknown system variable 'xxxxxxxxxx' select 1; 1 1 +select @@global.max_user_connections,@@local.max_join_size; +@@global.max_user_connections @@session.max_join_size +100 200 +set @svc=@@global.max_user_connections, @svj=@@local.max_join_size; +select @@global.max_user_connections,@@local.max_join_size; +@@global.max_user_connections @@session.max_join_size +100 200 +set @@global.max_user_connections=111,@@local.max_join_size=222; +select @@global.max_user_connections,@@local.max_join_size; +@@global.max_user_connections @@session.max_join_size +111 222 +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; +@@global.max_user_connections @@session.max_join_size +222 111 +set @@global.max_user_connections=@svc, @@local.max_join_size=@svj; +select @@global.max_user_connections,@@local.max_join_size; +@@global.max_user_connections @@session.max_join_size +100 200 +set @a=1, @b=2; +set @a=@b, @b=@a; +select @a, @b; +@a @b +2 1 |