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

22 lines
829 B
Plaintext

# suite/xengine_ext/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 xengine_ext
# 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 COLLATE utf8_general_ci not like 'xengine_%'
AND table_name not like 'ndb%';
--source suite/xengine_ext/datadict/tables1.inc