Information_Schema

MySQL

どうもテーブル名とかが小文字で格納されている．

mysql> SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, SEQ_IN_INDEX 
    -> AS KEY_SEQ, 'PRIMARY' AS PK_NAME FROM INFORMATION_SCHEMA.STATISTICS
    -> WHERE TABLE_SCHEMA LIKE 'test' AND TABLE_NAME LIKE 'testDatabaseMetaDataUsingInfoSchema'
    -> AND INDEX_NAME='PRIMARY' ORDER BY TABLE_SCHEMA, TABLE_NAME, INDEX_NAME, SEQ_IN_INDEX;
+-----------+-------------+-------------------------------------+-------------+---------+---------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME                          | COLUMN_NAME | KEY_SEQ | PK_NAME |
+-----------+-------------+-------------------------------------+-------------+---------+---------+
| test      |        NULL | testdatabasemetadatausinginfoschema | c1          |       1 | PRIMARY |
+-----------+-------------+-------------------------------------+-------------+---------+---------+
1 row in set (0.00 sec)

なんでかなーと思って調べたら
http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html

Table names are stored in lowercase on disk and name comparisons are not case sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names as of MySQL 4.0.2, and to table aliases as of 4.1.1. This value is the default on Windows and Mac OS X systems.

Information Schemaの話というよりlower_case_table_namesについての話．

WinとMac上ではデフォルトでこれが適用されていたのか．てことはtestsuiteはどのOS上で実行されるかどうか分からないことを考えると大文字込みのテーブル名は使っちゃ駄目だな．orz