summaryrefslogtreecommitdiff
path: root/mysql-test/t/variables.test
diff options
context:
space:
mode:
authorunknown <guilhem@mysql.com>2003-05-12 15:36:31 +0200
committerunknown <guilhem@mysql.com>2003-05-12 15:36:31 +0200
commitab7b332835e285bfbd3bc6637c8b388e29cae754 (patch)
treec69f779a1a28802423ce8ec77f54eccc243b1744 /mysql-test/t/variables.test
parentfb5df27adf58998f5e2a4a66d1634003cd106af2 (diff)
downloadmariadb-git-ab7b332835e285bfbd3bc6637c8b388e29cae754.tar.gz
Task #627 : user variables' names are now case-insensitive :
@test=@"tEsT"=@`teST` etc. Tests updated. Note that the patch to sql_class.cc does not use HASH_CASE_INSENSITIVE as did the one which I sent for review. This is because meanwhile HASH_CASE_INSENSITIVE has disappeared (since cset 1.1504.1.6). mysql-test/r/variables.result: updated test mysql-test/t/variables.test: updated test sql/sql_class.cc: Task #627 : user variables' names are now case-insensitive : @test=@"tEsT"=@`teST` etc.
Diffstat (limited to 'mysql-test/t/variables.test')
-rw-r--r--mysql-test/t/variables.test16
1 files changed, 14 insertions, 2 deletions
diff --git a/mysql-test/t/variables.test b/mysql-test/t/variables.test
index d1c8df64be2..dbe12554130 100644
--- a/mysql-test/t/variables.test
+++ b/mysql-test/t/variables.test
@@ -5,8 +5,20 @@
drop table if exists t1,t2;
--enable_warnings
-set @`test`=1,@TEST=3,@select=2,@t5=1.23456;
-select @test,@`select`,@TEST,@not_used;
+# case insensitivity tests (new in 5.0)
+set @`test`=1;
+select @test, @`test`, @TEST, @`TEST`, @"teSt";
+set @TEST=2;
+select @test, @`test`, @TEST, @`TEST`, @"teSt";
+set @"tEST"=3;
+select @test, @`test`, @TEST, @`TEST`, @"teSt";
+set @`TeST`=4;
+select @test, @`test`, @TEST, @`TEST`, @"teSt";
+select @`teST`:=5;
+select @test, @`test`, @TEST, @`TEST`, @"teSt";
+
+set @select=2,@t5=1.23456;
+select @`select`,@not_used;
set @test_int=10,@test_double=1e-10,@test_string="abcdeghi",@test_string2="abcdefghij",@select=NULL;
select @test_int,@test_double,@test_string,@test_string2,@select;
set @test_int="hello",@test_double="hello",@test_string="hello",@test_string2="hello";