Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/r/rules_table.result

raw
1 #
2 # Test of a rules table with columns in different order.
3 #
4 # Here we create a rules table with columns in different order.
5 CREATE DATABASE query_rewrite;
6 CREATE TABLE IF NOT EXISTS query_rewrite.rewrite_rules (
7 pattern_database VARCHAR(20),
8 enabled ENUM('YES', 'NO') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
9 DEFAULT 'YES',
10 replacement VARCHAR(1000),
11 message VARCHAR(100),
12 pattern VARCHAR(1000)
13 );
14 Warnings:
15 Note 1007 Can't create database 'query_rewrite'; database exists
16 Warnings:
17 Note 1050 Table 'rewrite_rules' already exists
18 # Query rewrite plugin was installed.
19 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
20 VALUES ( 'SELECT "rewrite me"', 'SELECT "rewritten"' );
21 CALL query_rewrite.flush_rewrite_rules();
22 SELECT pattern, pattern_database, replacement, message
23 FROM query_rewrite.rewrite_rules;
24 pattern pattern_database replacement message
25 SELECT "rewrite me" NULL SELECT "rewritten" NULL
26 SELECT "rewrite me";
27 rewritten
28 rewritten
29 Warnings:
30 Note 1105 Query 'SELECT "rewrite me"' rewritten to 'SELECT "rewritten"' by a query rewrite plugin
31 Warnings:
32 Warning 1620 Plugin is busy and will be uninstalled on shutdown
33 # Query rewrite plugin was queued for uninstalling.