Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/include/install_rewriter_with_optional_columns.inc

raw
1 disable_query_log;
2
3 CREATE DATABASE IF NOT EXISTS query_rewrite;
4
5 CREATE TABLE IF NOT EXISTS query_rewrite.rewrite_rules (
6 id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
7 pattern VARCHAR(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
8 pattern_database VARCHAR(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
9 replacement VARCHAR(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
10 enabled ENUM('YES', 'NO') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL
11 DEFAULT 'YES',
12 message VARCHAR(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
13 pattern_digest VARCHAR(64),
14 normalized_pattern VARCHAR(5000)
15 ) DEFAULT CHARSET = utf8mb4 ENGINE = INNODB;
16
17 eval INSTALL PLUGIN rewriter SONAME '$REWRITER';
18 eval CREATE FUNCTION load_rewrite_rules RETURNS STRING SONAME '$REWRITER';
19
20 DELIMITER //;
21
22 CREATE PROCEDURE query_rewrite.flush_rewrite_rules()
23 BEGIN
24 DECLARE message_text VARCHAR(100);
25 COMMIT;
26 SELECT load_rewrite_rules() INTO message_text;
27 IF NOT message_text IS NULL THEN
28 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = message_text;
29 END IF;
30 END //
31
32 DELIMITER ;//
33
34 enable_query_log;
35 echo # Query rewrite plugin was installed.;