diff options
| author | unknown <sergefp@mysql.com> | 2004-08-29 19:44:28 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2004-08-29 19:44:28 +0400 |
| commit | 44b9a3b27f26e572abeae7ba25d2517685b63ccd (patch) | |
| tree | e1775a2e1fbf4deebe6559971306e225ae08f419 /mysql-test/t/ps.test | |
| parent | 7ae755104f132a609b5d6b4d6fc3b31056ec3e32 (diff) | |
| download | mariadb-git-44b9a3b27f26e572abeae7ba25d2517685b63ccd.tar.gz | |
Fix for BUG#5242: Made SQL Syntax Prepared Statement names case-insensitive.
mysql-test/r/ps.result:
Testcase for BUG#5242
mysql-test/t/ps.test:
Testcase for BUG#5242
Diffstat (limited to 'mysql-test/t/ps.test')
| -rw-r--r-- | mysql-test/t/ps.test | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test index 8b9704f2a06..e54bf8076e0 100644 --- a/mysql-test/t/ps.test +++ b/mysql-test/t/ps.test @@ -240,3 +240,24 @@ prepare stmt1 from "select * from t1 into outfile 'f1.txt'"; execute stmt1; deallocate prepare stmt1; drop table t1; + +# +# BUG#5242 "Prepared statement names are case sensitive" +# +prepare stmt1 from 'select 1'; +prepare STMT1 from 'select 2'; +execute sTmT1; +deallocate prepare StMt1; + +--error 1243 +deallocate prepare Stmt1; + +# also check that statement names are in right charset. +set names utf8; +prepare `ü` from 'select 1234'; +execute `ü` ; +set names latin1; +execute `ü`; +set names default; + + |