| 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; |