Debian Codegraph @

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

raw
1 --echo #
2 --echo # Tests that the optional column columns work both of they are present
3 --echo # and absent. PATTERN_DIGEST and NORMALIZED_PATTERN are optional write-
4 --echo # only columns that are not present by default. The MESSAGE column is
5 --echo # optional, but included in the install script by default.
6 --echo #
7
8 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
9 --source suite/query_rewrite_plugins/include/install_rewriter_with_optional_columns.inc
10
11 --echo #
12 --echo # Testing with PATTERN_DIGEST and NORMALIZED_PATTERN columns.
13 --echo #
14 --source suite/query_rewrite_plugins/include/basic.inc
15 DELETE FROM query_rewrite.rewrite_rules;
16
17 --echo #
18 --echo # Testing with a NORMALIZED_PATTERN column.
19 --echo #
20 ALTER TABLE query_rewrite.rewrite_rules DROP COLUMN pattern_digest;
21 --source suite/query_rewrite_plugins/include/basic.inc
22 DELETE FROM query_rewrite.rewrite_rules;
23
24 --echo #
25 --echo # Testing with a NORMALIZED_PATTERN column but no MESSAGE column.
26 --echo #
27 ALTER TABLE query_rewrite.rewrite_rules DROP COLUMN message;
28 --source suite/query_rewrite_plugins/include/basic.inc
29 DELETE FROM query_rewrite.rewrite_rules;
30
31 --echo #
32 --echo # Testing with no optional columns.
33 --echo #
34 ALTER TABLE query_rewrite.rewrite_rules DROP COLUMN normalized_pattern;
35 --source suite/query_rewrite_plugins/include/basic.inc
36 DELETE FROM query_rewrite.rewrite_rules;
37
38 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc