Some testcases not updated by TOKUDB_DEFAULT patch

[Laurynas Biveinis]

On PS 5.7 trunk:

query_rewrite_plugins.optional_columns w2 [ fail ]
        Test ended at 2016-09-27 12:21:34

CURRENT_TEST: query_rewrite_plugins.optional_columns
--- /mnt/workspace/percona-server-5.7-trunk/BUILD_TYPE/release/Host/ubuntu-precise-64bit/mysql-test/suite/query_rewrite_plugins/r/optional_columns.result 2016-09-27 18:25:09.337655000 +0300
+++ /mnt/workspace/percona-server-5.7-trunk/BUILD_TYPE/release/Host/ubuntu-precise-64bit/build/mysql-test/var/2/log/optional_columns.reject 2016-09-27 19:21:34.509655000 +0300
@@ -21,7 +21,7 @@
 CALL query_rewrite.flush_rewrite_rules();
 SELECT * FROM query_rewrite.rewrite_rules;
 id pattern pattern_database replacement enabled message pattern_digest normalized_pattern
-1 SELECT ? NULL SELECT "literal" YES NULL 977a8eee3bfad267d31a2a938edbac5f select ?
+1 SELECT ? NULL SELECT "literal" YES NULL 41357b29987e52bcec1540bf3e3ee2f7 select ?
 SELECT NULL;
 literal
 literal
@@ -76,11 +76,11 @@
 CALL query_rewrite.flush_rewrite_rules();
 SELECT * FROM query_rewrite.rewrite_rules;
 id pattern pattern_database replacement enabled message pattern_digest normalized_pattern
-2 SELECT * FROM test.t1 WHERE ( a = ? AND TRUE ) OR b = ? NULL SELECT a FROM test.t1 WHERE a = ? YES NULL 8aae9d3377bb11514402346d2277ba74 select `*` from `test`.`t1` where (((`a` = ?) and ?) or (`b` = ?))
-3 SELECT a FROM test.t1 NULL SELECT * FROM test.t1 WHERE a = 'abc' YES NULL 1f23f18fe10649486f93a15c727d3f3f select `a` from `test`.`t1`
-4 SELECT a FROM test.t1 WHERE b = ? NULL SELECT * FROM test.t1 WHERE b = ? YES NULL 164be3b866504309af4cb4fa962e4695 select `a` from `test`.`t1` where (`b` = ?)
-5 SELECT * FROM test.t2 NULL SELECT * FROM test.t1 JOIN test.t2 ON t1.a = t2.a YES NULL b97b72ebea695d03f3a1b566558ee042 select `*` from `test`.`t2`
-6 SELECT * FROM test.t1 WHERE a = ? OR b = ? NULL SELECT * FROM test.t1 WHERE b = ? OR a = ? YES NULL 4c63ec22bf957500d9bc843f2a6486e2 select `*` from `test`.`t1` where ((`a` = ?) or (`b` = ?))
+2 SELECT * FROM test.t1 WHERE ( a = ? AND TRUE ) OR b = ? NULL SELECT a FROM test.t1 WHERE a = ? YES NULL c19712ef1fef40911e221ae1041282dc select `*` from `test`.`t1` where (((`a` = ?) and ?) or (`b` = ?))
+3 SELECT a FROM test.t1 NULL SELECT * FROM test.t1 WHERE a = 'abc' YES NULL 3b7283f9abbdabea1c22bf80d3ea0d73 select `a` from `test`.`t1`
+4 SELECT a FROM test.t1 WHERE b = ? NULL SELECT * FROM test.t1 WHERE b = ? YES NULL 23d027a1bc7115485cd1717c6c2c60ab select `a` from `test`.`t1` where (`b` = ?)
+5 SELECT * FROM test.t2 NULL SELECT * FROM test.t1 JOIN test.t2 ON t1.a = t2.a YES NULL 436e51f2e25b58772278674ce165dc18 select `*` from `test`.`t2`
+6 SELECT * FROM test.t1 WHERE a = ? OR b = ? NULL SELECT * FROM test.t1 WHERE b = ? OR a = ? YES NULL 47b22544258afdcd5c84a56b8df8b34b select `*` from `test`.`t1` where ((`a` = ?) or (`b` = ?))
 # Check a query that doesn't have a rewrite rule doesn't get rewritten.
 SELECT b FROM test.t1;
 b
@@ -181,9 +181,9 @@
 CALL query_rewrite.flush_rewrite_rules();
 SELECT * FROM query_rewrite.rewrite_rules;
 id pattern pattern_database replacement enabled message pattern_digest normalized_pattern
-7 SELECT 1, ? NULL SELECT "rewritten w/rule 1" YES NULL 41357b29987e52bcec1540bf3e3ee2f7 select ?,?
-8 SELECT 2, ? NULL SELECT "rewritten w/rule 2" YES NULL 41357b29987e52bcec1540bf3e3ee2f7 select ?,?
-9 SELECT "The_original_query" NULL SELECT "The_rewritten_query" YES NULL 977a8eee3bfad267d31a2a938edbac5f select ?
+7 SELECT 1, ? NULL SELECT "rewritten w/rule 1" YES NULL a87326530dbae3aa26b826afa4f70ad2 select ?,?
+8 SELECT 2, ? NULL SELECT "rewritten w/rule 2" YES NULL a87326530dbae3aa26b826afa4f70ad2 select ?,?
+9 SELECT "The_original_query" NULL SELECT "The_rewritten_query" YES NULL 41357b29987e52bcec1540bf3e3ee2f7 select ?
 SELECT 1, 1;
 rewritten w/rule 1
 rewritten w/rule 1

mysqltest: Result content mismatch

main.opt_hints_pfs w1 [ fail ]
        Test ended at 2016-09-27 13:07:48

CURRENT_TEST: main.opt_hints_pfs
--- /mnt/workspace/percona-server-5.7-trunk/BUILD_TYPE/release/Host/ubuntu-precise-64bit/mysql-test/r/opt_hints_pfs.result 2016-09-27 18:25:07.613655000 +0300
+++ /mnt/workspace/percona-server-5.7-trunk/BUILD_TYPE/release/Host/ubuntu-precise-64bit/build/mysql-test/var/1/log/opt_hints_pfs.reject 2016-09-27 20:07:47.925655000 +0300
@@ -8,8 +8,8 @@
 SELECT /*+ */ * FROM t1;
 SELECT digest, digest_text FROM performance_schema.events_statements_history ORDER BY timer_start DESC LIMIT 2;
 digest digest_text
-051ceaaa78a310e4bdaada9316058f0b SELECT * FROM `t1`
-051ceaaa78a310e4bdaada9316058f0b SELECT * FROM `t1`
+a87d8ea4816086228278b6c5aa926c53 SELECT * FROM `t1`
+a87d8ea4816086228278b6c5aa926c53 SELECT * FROM `t1`
 # Digests should be different:
 SELECT * FROM t1, t2;
 SELECT /*+
@@ -33,19 +33,19 @@
 */ * FROM t1, t2;
 SELECT digest, digest_text FROM performance_schema.events_statements_history ORDER BY timer_start DESC LIMIT 2;
 digest digest_text
-9400b1f93dd259af51b5651882bd5a89 SELECT /*+ BKA ( `t1`@`qb1` ) BNL ( @`qb1` `t1` ) DUPSWEEDOUT FIRSTMATCH INTOEXISTS LOOSESCAN MATERIALIZATION MRR ( `t1` ) NO_BKA ( `t2` ) NO_BNL ( `t2` ) NO_ICP ( `t2` ) NO_MRR ( `t2` ) NO_RANGE_OPTIMIZATION ( `t2` ) NO_SEMIJOIN ( `t2` ) QB_NAME ( `qb1` ) SEMIJOIN ( `t1` ) SUBQUERY ( `t1` ) */ * FROM `t1` , `t2`
-69bbc8391ad5ba2941c8bfc2afa72930 SELECT * FROM `t1` , `t2`
+c55fd8c397e6e66c40c7a1c408d8ed3b SELECT /*+ BKA ( `t1`@`qb1` ) BNL ( @`qb1` `t1` ) DUPSWEEDOUT FIRSTMATCH INTOEXISTS LOOSESCAN MATERIALIZATION MRR ( `t1` ) NO_BKA ( `t2` ) NO_BNL ( `t2` ) NO_ICP ( `t2` ) NO_MRR ( `t2` ) NO_RANGE_OPTIMIZATION ( `t2` ) NO_SEMIJOIN ( `t2` ) QB_NAME ( `qb1` ) SEMIJOIN ( `t1` ) SUBQUERY ( `t1` ) */ * FROM `t1` , `t2`
+2438c9b8cb9a871165fb570fabbe093f SELECT * FROM `t1` , `t2`
 SELECT * FROM t2, t1;
 SELECT /*+ MAX_EXECUTION_TIME(10) */ * FROM t2, t1;
 SELECT digest, digest_text FROM performance_schema.events_statements_history ORDER BY timer_start DESC LIMIT 2;
 digest digest_text
-2a645011564a7cfd60d28afa075b8c00 SELECT /*+ MAX_EXECUTION_TIME (?) */ * FROM `t2` , `t1`
-d19ac46585f6566552d05bdb796668d3 SELECT * FROM `t2` , `t1`
+cf60284f948ff2ff3c9ec4ee0d6f28b9 SELECT /*+ MAX_EXECUTION_TIME (?) */ * FROM `t2` , `t1`
+194bfbba404c969d94c8239cb06d99fc SELECT * FROM `t2` , `t1`
 SELECT 1;
 SELECT /*+ bad_hint_also_goes_to_digest */ 1;
 SELECT digest, digest_text FROM performance_schema.events_statements_history ORDER BY timer_start DESC LIMIT 2;
 digest digest_text
-1916c3738ab059ea0f42a3d4abcaa65e SELECT /*+ `bad_hint_also_goes_to_digest` */ ?
-977a8eee3bfad267d31a2a938edbac5f SELECT ?
+119ab72a54d5a010d553dea951992850 SELECT /*+ `bad_hint_also_goes_to_digest` */ ?
+41357b29987e52bcec1540bf3e3ee2f7 SELECT ?
 DROP TABLE t1, t2;
 #

mysqltest: Result content mismatch

[George Ormond Lorch III (gl-az)]

http://jenkins.percona.com/view/5.7/job/mysql-5.7-param/457/
https://github.com/percona/percona-server/pull/1089

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2207