Debian Codegraph @

mysql-test/suite/innodb/include/mixed_case.inc

raw
1
2 --echo #
3 --echo # Show how Mixed Case identifiers are handled for each OS type
4 --echo #
5
6 SHOW VARIABLES LIKE 'lower_case_table_names';
7
8 CREATE SCHEMA MixedCaseSchema;
9 CREATE TABLE MixedCaseSchema.MixedCaseTable (MixedCaseColumn INT);
10 INSERT INTO MixedCaseSchema.MixedCaseTable (MixedCaseColumn) VALUES (1), (2);
11 SELECT * FROM MixedCaseSchema.MixedCaseTable;
12
13 USE MixedCaseSchema;
14 SHOW TABLES;
15 USE test;
16
17 SHOW CREATE TABLE MixedCaseSchema.MixedCaseTable;
18
19 SELECT TABLE_NAME, TABLE_SCHEMA, TABLE_TYPE, ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%ixed%';
20 SELECT FILE_NAME, FILE_TYPE, TABLESPACE_NAME, TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_NAME LIKE '%ixed%';
21 SELECT NAME, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%ixed%';
22 SELECT NAME, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE '%ixed%';
23
24 --source include/restart_mysqld.inc
25
26 INSERT INTO MixedCaseSchema.MixedCaseTable (MixedCaseColumn) VALUES (3), (4);
27 SELECT * FROM MixedCaseSchema.MixedCaseTable;
28
29 USE MixedCaseSchema;
30 SHOW TABLES;
31 USE test;
32
33 SHOW CREATE TABLE MixedCaseSchema.MixedCaseTable;
34
35 SELECT TABLE_NAME, TABLE_SCHEMA, TABLE_TYPE, ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%ixed%';
36 SELECT FILE_NAME, FILE_TYPE, TABLESPACE_NAME, TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_NAME LIKE '%ixed%';
37 SELECT NAME, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%ixed%';
38 SELECT NAME, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE '%ixed%';
39
40 DROP TABLE MixedCaseSchema.MixedCaseTable;
41 DROP SCHEMA MixedCaseSchema;