summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorunknown <vva@eagle.mysql.r18.ru>2003-06-25 21:11:23 -0400
committerunknown <vva@eagle.mysql.r18.ru>2003-06-25 21:11:23 -0400
commit50159020c8f0f5b1f37ca29ccd81f086b7d32982 (patch)
treedab8dd1853160ee678d033eef263e388b1d34282 /mysql-test/r
parent2090bc6e4347fe69189302a5b520ae3051785746 (diff)
downloadmariadb-git-50159020c8f0f5b1f37ca29ccd81f086b7d32982.tar.gz
fixed bug with type of user variables (bug #551)
mysql-test/r/user_var.result: added tests for user variables comparing (bug #551) mysql-test/t/user_var.test: added tests for user variables comparing (bug #551) BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
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