1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
###### 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 build tests (non 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 non empty help tables = Build test configuration
}
# We reach this point when we run on a configuration with at least one
# non empty help table.
# 2007-08 MySQL 5.0 row count of the help tables
# help_category help_keyword help_relation help_topic
# 36 395 809 466
# Let's assume for all help tables that their content never dramatic
# shrinks and do some plausibility checks.
let $limit_help_category = 30;
let $limit_help_keyword = 320;
let $limit_help_relation = 640;
let $limit_help_topic = 380;
if (`SELECT $c_help_category < $limit_help_category
OR $c_help_keyword < $limit_help_keyword
OR $c_help_relation < $limit_help_relation
OR $c_help_topic < $limit_help_topic`)
{
--echo # The row count within the help tables is unexepected small.
SELECT COUNT(*), 'exepected: >= $limit_help_category' FROM mysql.help_category;
SELECT COUNT(*), 'exepected: >= $limit_help_keyword' FROM mysql.help_keyword;
SELECT COUNT(*), 'exepected: >= $limit_help_relation' FROM mysql.help_relation;
SELECT COUNT(*), 'exepected: >= $limit_help_topic' FROM mysql.help_topic;
--echo # Either the current help table content (build problem? or
--echo # the expected minimum row count within this script is wrong.
--echo # Abort
exit;
}
# Enforce a static number of rows within the help tables.
let $limit= `SELECT $c_help_category - $limit_help_category`;
--replace_result $limit <number>
eval DELETE FROM mysql.help_category LIMIT $limit;
#
let $limit= `SELECT $c_help_keyword - $limit_help_keyword`;
--replace_result $limit <number>
eval DELETE FROM mysql.help_keyword LIMIT $limit;
#
let $limit= `SELECT $c_help_relation - $limit_help_relation`;
--replace_result $limit <number>
eval DELETE FROM mysql.help_relation LIMIT $limit;
#
let $limit= `SELECT $c_help_topic - $limit_help_topic`;
--replace_result $limit <number>
eval DELETE FROM mysql.help_topic LIMIT $limit;
--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_%';
|
