Debian Codegraph @

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

raw
1 #
2 # Tests that check the normal form of pattern.
3 # Requires optional column NORMALIZED_PATTERN in rules table.
4 #
5
6 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
7 --source suite/query_rewrite_plugins/include/install_rewriter_with_optional_columns.inc
8
9 --echo #
10 --echo # Bug#21619780: TABLE HINTS ARE LOST IN NORMALIZED PRINT OF STATEMENTS
11 --echo # BEFORE RESOLVE
12 --echo #
13
14 CREATE TABLE t1 (a INTEGER);
15
16 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
17 VALUES ('SELECT /*+ NO_MRR(t1 idx1) */ * FROM test.t1',
18 'SELECT /*+ MRR(t1) */ * FROM test.t1');
19 CALL query_rewrite.flush_rewrite_rules();
20
21 SELECT normalized_pattern FROM query_rewrite.rewrite_rules;
22
23 DELETE FROM query_rewrite.rewrite_rules;
24
25 DROP TABLE t1;
26
27 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc
28
29