polardbxengine/mysql-test/suite/funcs_1/t/is_tables_is.test

21 lines
757 B
Plaintext

# suite/funcs_1/t/is_tables_is.test
#
# Check the content of information_schema.tables about tables within
# the database information_schema.
#
# Note: The INFORMATION_SCHEMA table PROFILING is optional (exists in MySQL
# Community version only) and therefore we exclude it from retrieval.
#
# Author:
# 2008-01-23 mleich WL#4203 Reorganize and fix the data dictionary tests of
# testsuite funcs_1
# Create this script based on older scripts and new code.
#
let $my_where = WHERE table_schema = 'information_schema'
AND table_name COLLATE utf8_general_ci <> 'profiling'
AND table_name COLLATE utf8_general_ci not like 'innodb_%'
AND table_name not like 'ndb%';
--source suite/funcs_1/datadict/tables1.inc