summaryrefslogtreecommitdiff
path: root/mysql-test/t/lowercase_table.test
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2004-08-28 00:49:54 +0300
committerunknown <monty@mysql.com>2004-08-28 00:49:54 +0300
commitdb15b91915bb57914e11f226c0130467dd4dcfdd (patch)
treed8470cb550581be2d6ffbc160a5a1b2b1b17a399 /mysql-test/t/lowercase_table.test
parent434d385ac17f2bfb553c112b5e19491d0bb0f876 (diff)
downloadmariadb-git-db15b91915bb57914e11f226c0130467dd4dcfdd.tar.gz
Code style fixes.
Initialize LOG_error_log before get_options to not use an uninitalized mutex in case of an error from handle_options() mysql-test/r/lowercase_table.result: Changed foo database -> mysqltest More test cases mysql-test/t/lowercase_table.test: Changed foo database -> mysqltest More test cases mysys/my_getopt.c: Fix new code to use MySQL indentation style sql/log.cc: Change to use MySQL indentation style and naming conventions Remove usage of strlen() and strcat() sql/mysqld.cc: Initialize LOG_error_log before get_options to not use an uninitalized mutex in case of an error from handle_options() sql/sql_base.cc: Added comment sql/table.cc: Added #if MYSQL_VERSION_ID < 40100 to ensure code is merged correctly
Diffstat (limited to 'mysql-test/t/lowercase_table.test')
-rw-r--r--mysql-test/t/lowercase_table.test17
1 files changed, 12 insertions, 5 deletions
diff --git a/mysql-test/t/lowercase_table.test b/mysql-test/t/lowercase_table.test
index d52c60baea7..1b431a9d920 100644
--- a/mysql-test/t/lowercase_table.test
+++ b/mysql-test/t/lowercase_table.test
@@ -3,6 +3,7 @@
#
drop table if exists t1,t2,t3,t4,T1;
+drop database if exists mysqltest;
create table T1 (id int primary key, Word varchar(40) not null, Index(Word));
create table t4 (id int primary key, Word varchar(40) not null);
INSERT INTO T1 VALUES (1, 'a'), (2, 'b'), (3, 'c');
@@ -34,10 +35,16 @@ drop table t1;
#
# Test all caps database name
#
-create database foo;
-use foo;
+create database mysqltest;
+use MYSQLTEST;
create table t1 (a int);
-select FOO.t1.* from FOO.t1;
+select T1.a from MYSQLTEST.T1;
+--error 1109
+select t1.a from MYSQLTEST.T1;
+select mysqltest.t1.* from MYSQLTEST.t1;
+select MYSQLTEST.t1.* from MYSQLTEST.t1;
+select MYSQLTEST.T1.* from MYSQLTEST.T1;
+select MYSQLTEST.T1.* from T1;
alter table t1 rename to T1;
-select FOO.t1.* from FOO.t1;
-drop database FOO;
+select MYSQLTEST.t1.* from MYSQLTEST.t1;
+drop database mysqltest;