2
3
# This test is executed twice for each test case if mysql-test-run is passed
3
# the flag --check-testcase.
4
# Before every testcase it's run with mysqltest in record mode and will
5
# thus produce an output file
6
# that can be compared to output from after the tescase.
7
# In that way it's possible to check that a testcase does not have
4
# the flag --check-testcase. Before every testcase it is run with mysqltest
5
# in record mode and will thus produce an output file that can be compared
6
# to output from after the tescase.
7
# In that way its possible to check that a testcase does not have
8
8
# any unwanted side affects.
12
# Dump all global variables
14
SHOW GLOBAL VARIABLES WHERE variable_name != 'timestamp';
22
# Dump the "test" database, all it's tables and their data
24
--exec $MYSQL_DUMP --skip-comments --skip-lock-tables test
27
# Dump the "mysql" database and it's tables
28
# Select data separately to add "order by"
30
--exec $MYSQL_DUMP --skip-comments --skip-lock-tables --no-data mysql
32
SELECT * FROM columns_priv;
33
SELECT * FROM db ORDER BY host, db, user;
35
SELECT * FROM help_category;
36
SELECT * FROM help_keyword;
37
SELECT * FROM help_relation;
38
SELECT * FROM help_relation;
41
SELECT * FROM procs_priv;
42
SELECT * FROM tables_priv;
43
SELECT * FROM time_zone;
44
SELECT * FROM time_zone_leap_second;
45
SELECT * FROM time_zone_name;
46
SELECT * FROM time_zone_transition;
47
SELECT * FROM time_zone_transition_type;
11
call mtr.check_testcase();