Debian Codegraph @

mysql-test/suite/innodb/t/create_table_similar_to_fts.test

raw
1 # We test both lower and upper case table names. On systems with case
2 # insesitive FS, warning and errors are converted to lower-case, wheras on
3 # systems with case senstive FS they are not. We use --lowercase_result to
4 # make sure results are the same in both cases.
5
6 --echo # Try to create a table name that has the form of an FTS auxilliary table name.
7
8 --error ER_WRONG_TABLE_NAME
9 CREATE TABLE fts_0000000000000424_being_deleted (id int);
10 SHOW WARNINGS;
11
12 --error ER_WRONG_TABLE_NAME
13 CREATE TABLE fts_0000000000000424_being_deleted_cache (id int);
14 SHOW WARNINGS;
15
16 --error ER_WRONG_TABLE_NAME
17 CREATE TABLE fts_0000000000000424_config (id int);
18 SHOW WARNINGS;
19
20 --error ER_WRONG_TABLE_NAME
21 CREATE TABLE fts_0000000000000424_deleted (id int);
22 SHOW WARNINGS;
23
24 --error ER_WRONG_TABLE_NAME
25 CREATE TABLE fts_0000000000000424_deleted_cache (id int);
26 SHOW WARNINGS;
27
28 --lowercase_result
29 --error ER_WRONG_TABLE_NAME
30 CREATE TABLE FTS_0000000000000424_BEING_DELETED (id int);
31 SHOW WARNINGS;
32
33 --lowercase_result
34 --error ER_WRONG_TABLE_NAME
35 CREATE TABLE FTS_0000000000000424_BEING_DELETED_CACHE (id int);
36 SHOW WARNINGS;
37
38 --lowercase_result
39 --error ER_WRONG_TABLE_NAME
40 CREATE TABLE FTS_0000000000000424_CONFIG (id int);
41 SHOW WARNINGS;
42
43 --lowercase_result
44 --error ER_WRONG_TABLE_NAME
45 CREATE TABLE FTS_0000000000000424_DELETED_CACHE (id int);
46 SHOW WARNINGS;
47
48 --lowercase_result
49 --error ER_WRONG_TABLE_NAME
50 CREATE TABLE FTS_0000000000000424_ADDED (id int);
51 SHOW WARNINGS;
52
53 --lowercase_result
54 --error ER_WRONG_TABLE_NAME
55 CREATE TABLE FTS_0000000000000424_STOPWORDS (id int);
56 SHOW WARNINGS;
57
58 --error ER_WRONG_TABLE_NAME
59 CREATE TABLE fts_0000000000000424_0000000000000584_index_1 (id int);
60 SHOW WARNINGS;
61
62 --error ER_WRONG_TABLE_NAME
63 CREATE TABLE fts_0000000000000424_0000000000000584_index_2 (id int);
64 SHOW WARNINGS;
65
66 --error ER_WRONG_TABLE_NAME
67 CREATE TABLE fts_0000000000000424_0000000000000584_index_3 (id int);
68 SHOW WARNINGS;
69
70 --error ER_WRONG_TABLE_NAME
71 CREATE TABLE fts_0000000000000424_0000000000000584_index_4 (id int);
72 SHOW WARNINGS;
73
74 --error ER_WRONG_TABLE_NAME
75 CREATE TABLE fts_0000000000000424_0000000000000584_index_5 (id int);
76 SHOW WARNINGS;
77
78 --error ER_WRONG_TABLE_NAME
79 CREATE TABLE fts_0000000000000424_0000000000000584_index_6 (id int);
80 SHOW WARNINGS;
81
82 --error ER_WRONG_TABLE_NAME
83 CREATE TABLE fts_0000000000000424_0000000000000584_doc_id (id int);
84 SHOW WARNINGS;
85
86 --lowercase_result
87 --error ER_WRONG_TABLE_NAME
88 CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_1 (id int);
89 SHOW WARNINGS;
90
91 --lowercase_result
92 --error ER_WRONG_TABLE_NAME
93 CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_2 (id int);
94 SHOW WARNINGS;
95
96 --lowercase_result
97 --error ER_WRONG_TABLE_NAME
98 CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_3 (id int);
99 SHOW WARNINGS;
100
101 --lowercase_result
102 --error ER_WRONG_TABLE_NAME
103 CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_4 (id int);
104 SHOW WARNINGS;
105
106 --lowercase_result
107 --error ER_WRONG_TABLE_NAME
108 CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_5 (id int);
109 SHOW WARNINGS;
110
111 --lowercase_result
112 --error ER_WRONG_TABLE_NAME
113 CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_6 (id int);
114 SHOW WARNINGS;
115
116 --lowercase_result
117 --error ER_WRONG_TABLE_NAME
118 CREATE TABLE FTS_0000000000000424_0000000000000584_DOC_ID (id int);
119 SHOW WARNINGS;