# We test both lower and upper case table names. On systems with case # insesitive FS, warning and errors are converted to lower-case, wheras on # systems with case senstive FS they are not. We use --lowercase_result to # make sure results are the same in both cases. --echo # Try to create a table name that has the form of an FTS auxilliary table name. --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_being_deleted (id int); SHOW WARNINGS; --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_being_deleted_cache (id int); SHOW WARNINGS; --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_config (id int); SHOW WARNINGS; --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_deleted (id int); SHOW WARNINGS; --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_deleted_cache (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_BEING_DELETED (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_BEING_DELETED_CACHE (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_CONFIG (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_DELETED_CACHE (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_ADDED (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_STOPWORDS (id int); SHOW WARNINGS; --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_0000000000000584_index_1 (id int); SHOW WARNINGS; --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_0000000000000584_index_2 (id int); SHOW WARNINGS; --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_0000000000000584_index_3 (id int); SHOW WARNINGS; --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_0000000000000584_index_4 (id int); SHOW WARNINGS; --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_0000000000000584_index_5 (id int); SHOW WARNINGS; --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_0000000000000584_index_6 (id int); SHOW WARNINGS; --error ER_WRONG_TABLE_NAME CREATE TABLE fts_0000000000000424_0000000000000584_doc_id (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_1 (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_2 (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_3 (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_4 (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_5 (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_0000000000000584_INDEX_6 (id int); SHOW WARNINGS; --lowercase_result --error ER_WRONG_TABLE_NAME CREATE TABLE FTS_0000000000000424_0000000000000584_DOC_ID (id int); SHOW WARNINGS;