Debian Codegraph @

mysql-test/suite/sys_vars/t/all_vars.test

raw
1 --source include/not_embedded.inc
2
3 #
4 # load everything we want to include in the testing
5 #
6 --disable_query_log
7 --disable_result_log
8 --disable_abort_on_error
9 eval INSTALL PLUGIN archive SONAME "$HA_ARCHIVE_SO";
10 eval INSTALL PLUGIN blackhole SONAME "$HA_BLACKHOLE_SO";
11 eval INSTALL PLUGIN federated SONAME "$HA_FEDERATEDX_SO";
12 eval INSTALL PLUGIN oqgraph SONAME "$HA_OQGRAPH_SO";
13 eval INSTALL PLUGIN sphinx SONAME "$HA_SPHINX_SO";
14 eval INSTALL PLUGIN innodb SONAME "$HA_INNODB_SO";
15 --enable_abort_on_error
16 --enable_result_log
17 --enable_query_log
18
19 #
20 # This test verifies that *all* system variables are tested
21 # by the sys_vars suite. For every system variable
22 # there must be a <variable_name>_basic.test file.
23 #
24
25 #
26 # we can diff in perl or in sql, as it's my_SQL_test suite, do it in sql
27 #
28
29 perl;
30 use File::Basename;
31 my $dirname=dirname($ENV{MYSQLTEST_FILE});
32 my @all_tests=<$dirname/*_basic{,_32,_64}.test>;
33 #*/
34 open(F, '>', "$ENV{MYSQLTEST_VARDIR}/tmp/sys_vars.all_vars.txt") or die;
35 binmode F;
36 print F join "\n", sort map { s/_basic(_32|_64)?\.test$//; basename $_ } @all_tests;
37 EOF
38
39 create table t1 (test_name text);
40 create table t2 (variable_name text);
41 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
42 eval load data infile "$MYSQLTEST_VARDIR/tmp/sys_vars.all_vars.txt" into table t1;
43
44 insert into t2 select variable_name from information_schema.global_variables;
45 insert into t2 select variable_name from information_schema.session_variables;
46
47 # Performance schema variables are too long for files named
48 # 'mysql-test/suite/sys_vars/t/' ...
49 # ... 'performance_schema_events_waits_history_long_size_basic-master.opt'
50 # to fit in the tar source distribution (limit in old tar)
51 # Renaming the tests to aliases below.
52
53 update t2 set variable_name= replace(variable_name, "PERFORMANCE_SCHEMA_", "PFS_");
54
55 --sorted_result
56 --lowercase_result
57 select distinct variable_name as `There should be *no* long test name listed below:` from t2
58 where length(variable_name) > 50;
59
60 --sorted_result
61 --lowercase_result
62 select distinct variable_name as `There should be *no* variables listed below:` from t2
63 left join t1 on variable_name=test_name where test_name is null;
64
65 drop table t1;
66 drop table t2;
67
68 --disable_query_log
69 --disable_result_log
70 --disable_abort_on_error
71 UNINSTALL PLUGIN archive;
72 UNINSTALL PLUGIN blackhole;
73 UNINSTALL PLUGIN federated;
74 UNINSTALL PLUGIN oqgraph;
75 UNINSTALL PLUGIN sphinx;
76 UNINSTALL PLUGIN innodb;
77 UNINSTALL PLUGIN rpl_semi_sync_master;
78 UNINSTALL PLUGIN rpl_semi_sync_slave;
79 --enable_abort_on_error
80 --enable_result_log
81 --enable_query_log
82