diff options
author | unknown <guilhem@mysql.com> | 2003-05-12 15:36:31 +0200 |
---|---|---|
committer | unknown <guilhem@mysql.com> | 2003-05-12 15:36:31 +0200 |
commit | ab7b332835e285bfbd3bc6637c8b388e29cae754 (patch) | |
tree | c69f779a1a28802423ce8ec77f54eccc243b1744 /mysql-test/t/variables.test | |
parent | fb5df27adf58998f5e2a4a66d1634003cd106af2 (diff) | |
download | mariadb-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.test | 16 |
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"; |