Debian Codegraph @

mysql-test/suite/test_services/t/test_services.test

raw
1 #--source include/have_daemon_example_plugin.inc
2
3 # Restart of server to get deterministic results.
4 --let server_log= $MYSQLTEST_VARDIR/log/test_services.err
5 --let $restart_parameters="restart: --log-error=$server_log"
6 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
7 --source include/restart_mysqld.inc
8
9 call mtr.add_suppression("This is a warning from test plugin");
10 call mtr.add_suppression("This is an error from test plugin");
11
12 SET @orig_log_error_verbosity= @@global.log_error_verbosity;
13 SET @@global.log_error_verbosity= 3;
14
15 --echo ------ Run plugin ------------------------------------------------
16 --replace_result $TESTSERVICES TESTSERVICES
17 eval INSTALL PLUGIN test_services SONAME '$TESTSERVICES';
18 --echo ------ Show variables of plugin to control test execution --------
19 SHOW VARIABLES LIKE 'test_service%';
20
21 --echo ------ Show status of plugin -------------------------------------
22 SHOW STATUS LIKE 'test_services_status';
23 let $test_status= `SELECT variable_value FROM performance_schema.global_status
24 WHERE variable_name LIKE 'test_services_status'`;
25 --echo test status: $test_status
26
27 let $run_log_message_test=`SELECT @@global.test_services_with_log_message= 1`;
28
29
30 --echo #
31 --echo # Bug #GR VARS ARE ABLE TO SET TO 'DEFAULT' INSTEAD OF ERROR ER3093
32 --echo # WHEN GR IS RUNNING
33 --echo #
34
35 --echo # Should not work
36 --error ER_WRONG_VALUE_FOR_VAR
37 SET @@global.test_services_non_default_variable= DEFAULT;
38
39
40 --echo ------ Stop plugin -----------------------------------------------
41 UNINSTALL PLUGIN test_services;
42
43 SET @@global.log_error_verbosity= @orig_log_error_verbosity;
44
45 --echo ------ Service: LogPluginErr ----------------------------
46 if ($run_log_message_test) {
47 CREATE TABLE t1 (c1 varchar(30), c2 TEXT, c3 TEXT, c4 TEXT);
48 --disable_warnings ER_WARN_TOO_MANY_RECORDS
49 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
50 eval LOAD DATA LOCAL INFILE '$server_log' INTO TABLE t1
51 FIELDS TERMINATED BY ' [';
52 --enable_warnings ER_WARN_TOO_MANY_RECORDS
53 SELECT replace(concat('[',c2,' [',c3,' [',c4),'\r','') AS msg FROM t1 WHERE c4 LIKE '%test_services %';
54 DROP TABLE IF EXISTS t1;
55 }
56
57 # Restore default settings
58 let $restart_parameters = restart:;
59 --source include/restart_mysqld.inc
60 --remove_file $server_log