summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r')
-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 e06a113bd29..8abdb40399a 100644
--- a/mysql-test/r/user_var.result
+++ b/mysql-test/r/user_var.result
@@ -14,3 +14,11 @@ 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
+@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