Debian Codegraph @

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

raw
1 #
2 # Test of the case when two rewrite rule pattern have the same digest.
3 #
4 SET sql_mode = concat ( @@sql_mode, ',PIPES_AS_CONCAT' );
5 CREATE TABLE t1 ( a VARCHAR(10) );
6 # Query rewrite plugin was installed.
7 # This will supposedly fill up the token buffer.
8 # We have to keep entries in the error log unique, we can't clear it.
9 SET @query_term = 'SELECT * FROM test.t1 WHERE a = "digest_collision.test"';
10 SET @a_union_branch = ' UNION ' || @query_term;
11 SET @tail1 = 'UNION SELECT 1';
12 SET @tail2 = 'UNION SELECT 2';
13 SELECT character_maximum_length INTO @max_pattern_length
14 FROM information_schema.columns
15 WHERE table_name = 'rewrite_rules'
16 AND column_name = 'pattern';
17 SET @no_unions_that_fit =
18 floor(
19 ( @max_pattern_length - char_length(@query_term) - char_length(@tail1) ) /
20 char_length(@a_union_branch));
21 SELECT @query_term, @a_union_branch, @max_pattern_length, @no_unions_that_fit;
22 @query_term @a_union_branch @max_pattern_length @no_unions_that_fit
23 SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" 5000 79
24 SET @pattern1 = @query_term || repeat( @a_union_branch, @no_unions_that_fit);
25 SET @pattern2 = concat ( @pattern1, @tail1 );
26 SET @nonmatching_query = concat ( @pattern1, @tail2 );
27 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
28 VALUES ( @pattern1, 'SELECT "Rewrite rule #1"' ),
29 ( @pattern2, 'SELECT "Rewrite rule #2"' );
30 CALL query_rewrite.flush_rewrite_rules();
31 SELECT group_concat(replacement) =
32 'SELECT "Rewrite rule #1",SELECT "Rewrite rule #2"'
33 AS digests_indeed_collide
34 FROM query_rewrite.rewrite_rules
35 GROUP BY pattern_digest;
36 digests_indeed_collide
37 1
38 SELECT char_length(pattern) FROM query_rewrite.rewrite_rules;
39 char_length(pattern)
40 4953
41 4967
42 PREPARE pattern1_stmt FROM @pattern1;
43 Warnings:
44 Note 1105 Query 'SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT *
45 EXECUTE pattern1_stmt;
46 Rewrite rule #1
47 Rewrite rule #1
48 PREPARE pattern2_stmt FROM @pattern2;
49 Warnings:
50 Note 1105 Query 'SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT *
51 EXECUTE pattern2_stmt;
52 Rewrite rule #2
53 Rewrite rule #2
54 SET @@global.rewriter_verbose = 2;
55 PREPARE nonmatching_stmt FROM @nonmatching_query;
56 EXECUTE nonmatching_stmt;
57 a
58 2
59 SET @@global.rewriter_verbose = DEFAULT;
60 CREATE TABLE IF NOT EXISTS error_log ( line TEXT );
61 DELETE FROM error_log;
62 LOAD DATA LOCAL INFILE 'ERROR_LOG'
63 INTO TABLE error_log FIELDS TERMINATED BY '\t';
64 UPDATE error_log SET line = replace ( line, '\r', '' );
65 SELECT search_error_log( '[Note]', '%Plugin Rewriter reported: ''Statement "SELECT * FROM test.t1 ' ||
66 'WHERE a = "digest_collision.test"%' );
67 search_error_log( '[Note]', '%Plugin Rewriter reported: ''Statement "SELECT * FROM test.t1 ' ||
68 'WHERE a = "digest_collision.test"%' )
69 [Note] [MY-011235] [Server] Plugin Rewriter reported: 'Statement "SELECT * FROM test.t1 WHERE a = "digest_collision.test" UNION SELECT * FROM test.t1 WHERE a = "diges..." with digest "3c579229047547d5b35dbb0f1f00f0d1ff521755e231f83952e6d51b2019818b" matched some rule but had different parse tree and/or literals.'
70 DROP TABLE t1;
71 Warnings:
72 Warning 1620 Plugin is busy and will be uninstalled on shutdown
73 # Query rewrite plugin was queued for uninstalling.
74 DROP TABLE error_log;
75 DROP FUNCTION search_error_log;
76 SET sql_mode = DEFAULT;