Debian Codegraph @

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

raw
1 --echo #
2 --echo # Test of a rules table with columns in different order.
3 --echo #
4
5 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
6
7 --echo # Here we create a rules table with columns in different order.
8 CREATE DATABASE query_rewrite;
9 CREATE TABLE IF NOT EXISTS query_rewrite.rewrite_rules (
10 pattern_database VARCHAR(20),
11 enabled ENUM('YES', 'NO') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
12 DEFAULT 'YES',
13 replacement VARCHAR(1000),
14 message VARCHAR(100),
15 pattern VARCHAR(1000)
16 );
17
18 --source suite/query_rewrite_plugins/include/install_rewriter.inc
19
20 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
21 VALUES ( 'SELECT "rewrite me"', 'SELECT "rewritten"' );
22
23 CALL query_rewrite.flush_rewrite_rules();
24
25 SELECT pattern, pattern_database, replacement, message
26 FROM query_rewrite.rewrite_rules;
27
28 SELECT "rewrite me";
29
30 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc