diff options
author | unknown <monty@donna.mysql.fi> | 2001-03-15 11:55:44 +0200 |
---|---|---|
committer | unknown <monty@donna.mysql.fi> | 2001-03-15 11:55:44 +0200 |
commit | c669254da76877d1ca9fc78c1065604a797935ef (patch) | |
tree | 4cbc0ef76ce9d184843d9c7b9ab153d5f4d8e35b /mysql-test | |
parent | 41ed01413fdfcfa8bec77c8ebd1a6850feb04463 (diff) | |
download | mariadb-git-c669254da76877d1ca9fc78c1065604a797935ef.tar.gz |
Added tests if a user variable is changed in the same query.
Docs/manual.texi:
Updated info about some common problems.
mysql-test/r/user_var.result:
Added tests of using user variables.
mysql-test/t/user_var.test:
Added tests of using user variables.
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/user_var.result | 8 | ||||
-rw-r--r-- | mysql-test/t/user_var.test | 4 |
2 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/user_var.result b/mysql-test/r/user_var.result index 1be79d90cd6..e06a113bd29 100644 --- a/mysql-test/r/user_var.result +++ b/mysql-test/r/user_var.result @@ -6,3 +6,11 @@ i i @vv1:=if(sv1.i,1,0) @vv2:=if(sv2.i,1,0) @vv3:=if(sv3.i,1,0) @vv1+@vv2+@vv3 1 1 0 1 2 2 1 0 0 1 +table type possible_keys key key_len ref rows Extra +t1 ref i i 4 const 1 where used +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 3 where used +table type possible_keys key key_len ref rows Extra +t1 index NULL i 4 NULL 3 where used; Using index +table type possible_keys key key_len ref rows Extra +t1 ref i i 4 const 1 where used diff --git a/mysql-test/t/user_var.test b/mysql-test/t/user_var.test index 4cef5ea6ce9..70283446fb3 100644 --- a/mysql-test/t/user_var.test +++ b/mysql-test/t/user_var.test @@ -12,4 +12,8 @@ create table t2 (i int not null, unique (i)); insert into t2 select distinct i from t1; select * from t2; select distinct t2.i,@vv1:=if(sv1.i,1,0),@vv2:=if(sv2.i,1,0),@vv3:=if(sv3.i,1,0), @vv1+@vv2+@vv3 from t2 left join t1 as sv1 on sv1.i=t2.i and sv1.v=1 left join t1 as sv2 on sv2.i=t2.i and sv2.v=2 left join t1 as sv3 on sv3.i=t2.i and sv3.v=3; +explain select * from t1 where i=@vv1; +explain select * from t1 where @vv1:=@vv1+1 and i=@vv1; +explain select @vv1:=i from t1 where i=@vv1; +explain select * from t1 where i=@vv1; drop table t1,t2; |