Debian Codegraph @

mysql-test/suite/innodb/r/mixed_case_0.result

raw
1 #
2 # Test Mixed Case Identifiers with --lower-case-table-name=0
3 #
4 #
5 # Show how Mixed Case identifiers are handled for each OS type
6 #
7 SHOW VARIABLES LIKE 'lower_case_table_names';
8 Variable_name Value
9 lower_case_table_names 0
10 CREATE SCHEMA MixedCaseSchema;
11 CREATE TABLE MixedCaseSchema.MixedCaseTable (MixedCaseColumn INT);
12 INSERT INTO MixedCaseSchema.MixedCaseTable (MixedCaseColumn) VALUES (1), (2);
13 SELECT * FROM MixedCaseSchema.MixedCaseTable;
14 MixedCaseColumn
15 1
16 2
17 USE MixedCaseSchema;
18 SHOW TABLES;
19 Tables_in_MixedCaseSchema
20 MixedCaseTable
21 USE test;
22 SHOW CREATE TABLE MixedCaseSchema.MixedCaseTable;
23 Table Create Table
24 MixedCaseTable CREATE TABLE `MixedCaseTable` (
25 `MixedCaseColumn` int DEFAULT NULL
26 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
27 SELECT TABLE_NAME, TABLE_SCHEMA, TABLE_TYPE, ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%ixed%';
28 TABLE_NAME TABLE_SCHEMA TABLE_TYPE ENGINE
29 MixedCaseTable MixedCaseSchema BASE TABLE InnoDB
30 SELECT FILE_NAME, FILE_TYPE, TABLESPACE_NAME, TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_NAME LIKE '%ixed%';
31 FILE_NAME FILE_TYPE TABLESPACE_NAME TABLE_SCHEMA TABLE_NAME
32 ./MixedCaseSchema/MixedCaseTable.ibd TABLESPACE MixedCaseSchema/MixedCaseTable NULL NULL
33 SELECT NAME, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%ixed%';
34 NAME SPACE_TYPE
35 MixedCaseSchema/MixedCaseTable Single
36 SELECT NAME, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE '%ixed%';
37 NAME SPACE_TYPE
38 MixedCaseSchema/MixedCaseTable Single
39 # restart
40 INSERT INTO MixedCaseSchema.MixedCaseTable (MixedCaseColumn) VALUES (3), (4);
41 SELECT * FROM MixedCaseSchema.MixedCaseTable;
42 MixedCaseColumn
43 1
44 2
45 3
46 4
47 USE MixedCaseSchema;
48 SHOW TABLES;
49 Tables_in_MixedCaseSchema
50 MixedCaseTable
51 USE test;
52 SHOW CREATE TABLE MixedCaseSchema.MixedCaseTable;
53 Table Create Table
54 MixedCaseTable CREATE TABLE `MixedCaseTable` (
55 `MixedCaseColumn` int DEFAULT NULL
56 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
57 SELECT TABLE_NAME, TABLE_SCHEMA, TABLE_TYPE, ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%ixed%';
58 TABLE_NAME TABLE_SCHEMA TABLE_TYPE ENGINE
59 MixedCaseTable MixedCaseSchema BASE TABLE InnoDB
60 SELECT FILE_NAME, FILE_TYPE, TABLESPACE_NAME, TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_NAME LIKE '%ixed%';
61 FILE_NAME FILE_TYPE TABLESPACE_NAME TABLE_SCHEMA TABLE_NAME
62 ./MixedCaseSchema/MixedCaseTable.ibd TABLESPACE MixedCaseSchema/MixedCaseTable NULL NULL
63 SELECT NAME, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME LIKE '%ixed%';
64 NAME SPACE_TYPE
65 MixedCaseSchema/MixedCaseTable Single
66 SELECT NAME, SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE '%ixed%';
67 NAME SPACE_TYPE
68 MixedCaseSchema/MixedCaseTable Single
69 DROP TABLE MixedCaseSchema.MixedCaseTable;
70 DROP SCHEMA MixedCaseSchema;