datadict_help_tables_dev.test

来自「视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.」· TEST 代码 · 共 28 行

###### suite/funcs_1/t/datadict_help_tables_dev.test #####
#
# Check the information about the help tables within
# INFORMATION_SCHEMA.TABLES/INFORMATION_SCHEMA.STATISTICS
#
# Variant for use during development (empty help tables)
#
# Creation:
# 2007-08-25 mleich Add this test as compensation for the
#                   checks removed within datadict_master.inc.
#

let $c_help_category= `SELECT COUNT(*) FROM mysql.help_category`;
let $c_help_keyword=  `SELECT COUNT(*) FROM mysql.help_keyword`;
let $c_help_relation= `SELECT COUNT(*) FROM mysql.help_relation`;
let $c_help_topic=    `SELECT COUNT(*) FROM mysql.help_topic`;
if (`SELECT $c_help_category + $c_help_keyword + $c_help_relation
            + $c_help_topic > 0`)
{
    --skip # Test requires empty help tables = Development test configuration
}

--replace_column  9 "#ARL#"  10 "#DL#"  11 "#MDL#"  12 "#IL#"  13 "#DF#"  15 "YYYY-MM-DD hh:mm:ss"  16 "YYYY-MM-DD hh:mm:ss" 17 "YYYY-MM-DD hh:mm:ss"
SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME LIKE 'help_%';
SELECT * FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME LIKE 'help_%';