| 1 |
--echo # |
| 2 |
--echo # Test of the case when two rewrite rule pattern have the same digest. |
| 3 |
--echo # |
| 4 |
|
| 5 |
SET sql_mode = concat ( @@sql_mode, ',PIPES_AS_CONCAT' ); |
| 6 |
|
| 7 |
--source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc |
| 8 |
|
| 9 |
CREATE TABLE t1 ( a VARCHAR(10) ); |
| 10 |
|
| 11 |
--source suite/query_rewrite_plugins/include/install_rewriter_with_optional_columns.inc |
| 12 |
|
| 13 |
--echo # This will supposedly fill up the token buffer. |
| 14 |
--echo # We have to keep entries in the error log unique, we can't clear it. |
| 15 |
SET @query_term = 'SELECT * FROM test.t1 WHERE a = "digest_collision.test"'; |
| 16 |
SET @a_union_branch = ' UNION ' || @query_term; |
| 17 |
SET @tail1 = 'UNION SELECT 1'; |
| 18 |
SET @tail2 = 'UNION SELECT 2'; |
| 19 |
|
| 20 |
SELECT character_maximum_length INTO @max_pattern_length |
| 21 |
FROM information_schema.columns |
| 22 |
WHERE table_name = 'rewrite_rules' |
| 23 |
AND column_name = 'pattern'; |
| 24 |
|
| 25 |
SET @no_unions_that_fit = |
| 26 |
floor( |
| 27 |
( @max_pattern_length - char_length(@query_term) - char_length(@tail1) ) / |
| 28 |
char_length(@a_union_branch)); |
| 29 |
|
| 30 |
SELECT @query_term, @a_union_branch, @max_pattern_length, @no_unions_that_fit; |
| 31 |
|
| 32 |
SET @pattern1 = @query_term || repeat( @a_union_branch, @no_unions_that_fit); |
| 33 |
|
| 34 |
SET @pattern2 = concat ( @pattern1, @tail1 ); |
| 35 |
|
| 36 |
SET @nonmatching_query = concat ( @pattern1, @tail2 ); |
| 37 |
|
| 38 |
INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement ) |
| 39 |
VALUES ( @pattern1, 'SELECT "Rewrite rule #1"' ), |
| 40 |
( @pattern2, 'SELECT "Rewrite rule #2"' ); |
| 41 |
|
| 42 |
CALL query_rewrite.flush_rewrite_rules(); |
| 43 |
|
| 44 |
SELECT group_concat(replacement) = |
| 45 |
'SELECT "Rewrite rule #1",SELECT "Rewrite rule #2"' |
| 46 |
AS digests_indeed_collide |
| 47 |
FROM query_rewrite.rewrite_rules |
| 48 |
GROUP BY pattern_digest; |
| 49 |
|
| 50 |
SELECT char_length(pattern) FROM query_rewrite.rewrite_rules; |
| 51 |
|
| 52 |
PREPARE pattern1_stmt FROM @pattern1; |
| 53 |
EXECUTE pattern1_stmt; |
| 54 |
|
| 55 |
PREPARE pattern2_stmt FROM @pattern2; |
| 56 |
EXECUTE pattern2_stmt; |
| 57 |
|
| 58 |
SET @@global.rewriter_verbose = 2; |
| 59 |
|
| 60 |
PREPARE nonmatching_stmt FROM @nonmatching_query; |
| 61 |
EXECUTE nonmatching_stmt; |
| 62 |
|
| 63 |
SET @@global.rewriter_verbose = DEFAULT; |
| 64 |
|
| 65 |
--source suite/query_rewrite_plugins/include/load_error_log.inc |
| 66 |
|
| 67 |
SELECT search_error_log( '[Note]', '%Plugin Rewriter reported: ''Statement "SELECT * FROM test.t1 ' || |
| 68 |
'WHERE a = "digest_collision.test"%' ); |
| 69 |
|
| 70 |
DROP TABLE t1; |
| 71 |
|
| 72 |
--source suite/query_rewrite_plugins/include/uninstall_rewriter.inc |
| 73 |
--source suite/query_rewrite_plugins/include/drop_error_log.inc |
| 74 |
SET sql_mode = DEFAULT; |