diff options
| author | unknown <vva@eagle.mysql.r18.ru> | 2003-06-25 21:11:23 -0400 |
|---|---|---|
| committer | unknown <vva@eagle.mysql.r18.ru> | 2003-06-25 21:11:23 -0400 |
| commit | 50159020c8f0f5b1f37ca29ccd81f086b7d32982 (patch) | |
| tree | dab8dd1853160ee678d033eef263e388b1d34282 /mysql-test/t/user_var.test | |
| parent | 2090bc6e4347fe69189302a5b520ae3051785746 (diff) | |
| download | mariadb-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/t/user_var.test')
| -rw-r--r-- | mysql-test/t/user_var.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/user_var.test b/mysql-test/t/user_var.test index 70283446fb3..3103de2dac5 100644 --- a/mysql-test/t/user_var.test +++ b/mysql-test/t/user_var.test @@ -17,3 +17,9 @@ 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; + +# Check types of variables +select @a:=10, @b:=1, @a > @b, @a < @b; +select @a:="10", @b:="1", @a > @b, @a < @b; +select @a:=10, @b:=2, @a > @b, @a < @b; +select @a:="10", @b:="2", @a > @b, @a < @b; |