Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/t/recovery.test

raw
1 --echo #
2 --echo # Test of recovery. We load some rewrite rule and restart the server.
3 --echo # The rewrite rule should now be loaded.
4 --echo #
5 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
6 --source suite/query_rewrite_plugins/include/install_rewriter.inc
7
8 --echo # checks that the plugin is well installed
9 SELECT plugin_name, plugin_type
10 FROM information_schema.plugins
11 WHERE plugin_name = 'Rewriter';
12
13 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
14 VALUES ( 'SELECT "Rewrite"', 'SELECT "Rewritten"' );
15
16 CALL query_rewrite.flush_rewrite_rules();
17 SELECT * FROM query_rewrite.rewrite_rules;
18
19 SELECT 'Rewrite';
20
21 --echo #
22 --echo # Restart the server
23 --echo #
24
25 --exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
26 --shutdown_server
27 --source include/wait_until_disconnected.inc
28
29 --exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
30 --enable_reconnect
31 --source include/wait_until_connected_again.inc
32
33 SELECT 'Rewrite';
34
35 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc