Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/include/install_rewriter.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 ) DEFAULT CHARSET = utf8mb4 ENGINE = INNODB;
14
15 eval INSTALL PLUGIN rewriter SONAME '$REWRITER';
16 eval CREATE FUNCTION load_rewrite_rules RETURNS STRING SONAME '$REWRITER';
17
18 DELIMITER //;
19
20 CREATE PROCEDURE query_rewrite.flush_rewrite_rules()
21 BEGIN
22 DECLARE message_text VARCHAR(100);
23 COMMIT;
24 SELECT load_rewrite_rules() INTO message_text;
25 IF NOT message_text IS NULL THEN
26 SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = message_text;
27 END IF;
28 END //
29
30 DELIMITER ;//
31
32 enable_query_log;
33 echo # Query rewrite plugin was installed.;