summaryrefslogtreecommitdiff
path: root/mysql-test/r/user_var.result
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2003-07-01 15:02:16 +0300
committermonty@mashka.mysql.fi <>2003-07-01 15:02:16 +0300
commitca2913a07e3695dcf133ed6b48d221688181e604 (patch)
tree1dd88e8c946c87dfaa131fd495d71766127a0e94 /mysql-test/r/user_var.result
parent9fb7e863ad7d5f701a7b27f75a8b279e19232ef2 (diff)
parent2b0543148db749ffb4064a4fff7ce44323ec2751 (diff)
downloadmariadb-git-ca2913a07e3695dcf133ed6b48d221688181e604.tar.gz
Merge with 3.23 tree to get latest bug fixes
Diffstat (limited to 'mysql-test/r/user_var.result')
-rw-r--r--mysql-test/r/user_var.result8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/user_var.result b/mysql-test/r/user_var.result
index 5e9f3a720c2..0d4f7b401e6 100644
--- a/mysql-test/r/user_var.result
+++ b/mysql-test/r/user_var.result
@@ -30,3 +30,11 @@ explain select * from t1 where i=@vv1;
table type possible_keys key key_len ref rows Extra
t1 ref i i 4 const 1 Using where
drop table t1,t2;
+@a:=10 @b:=1 @a > @b @a < @b
+10 1 1 0
+@a:="10" @b:="1" @a > @b @a < @b
+10 1 1 0
+@a:=10 @b:=2 @a > @b @a < @b
+10 2 1 0
+@a:="10" @b:="2" @a > @b @a < @b
+10 2 0 1