------------------------------------------------------------ revno: 8770 committer: Laurynas Biveinis branch nick: mysql-5.7-percona-patches timestamp: Thu 2014-10-09 18:13:28 +0300 message: Fix bug 68714 (Remove literal statement digest values from perfschema tests) by masking DIGEST column values in MTR output. diff: === modified file 'mysql-test/suite/perfschema/r/digest_table_full.result' --- mysql-test/suite/perfschema/r/digest_table_full.result 2014-08-29 11:13:33 +0000 +++ mysql-test/suite/perfschema/r/digest_table_full.result 2014-10-09 15:13:28 +0000 @@ -112,8 +112,8 @@ SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS, SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest; SCHEMA_NAME DIGEST DIGEST_TEXT COUNT_STAR SUM_ROWS_AFFECTED SUM_WARNINGS SUM_ERRORS -NULL NULL NULL 55 32 1 2 -statements_digest eed7e04cbba55015979c7e0144720d20 TRUNCATE TABLE performance_schema . events_statements_summary_by_digest 1 0 0 0 +NULL ? NULL 55 32 1 2 +statements_digest ? TRUNCATE TABLE performance_schema . events_statements_summary_by_digest 1 0 0 0 SHOW VARIABLES LIKE "performance_schema_digests_size"; Variable_name Value performance_schema_digests_size 2 === modified file 'mysql-test/suite/perfschema/r/rpl_gtid_func.result' --- mysql-test/suite/perfschema/r/rpl_gtid_func.result 2014-08-29 11:13:33 +0000 +++ mysql-test/suite/perfschema/r/rpl_gtid_func.result 2014-10-09 15:13:28 +0000 @@ -56,7 +56,7 @@ from performance_schema.events_statements_summary_by_digest where digest_text like "%in_%_digest%"; digest digest_text count_star -176a0bc2f94b08c6e4c8b696d63071fa SELECT ? AS in_master_digest 1 +? SELECT ? AS in_master_digest 1 insert into test.marker values (2); **** On Slave **** select * from test.marker; @@ -99,7 +99,7 @@ from performance_schema.events_statements_summary_by_digest where digest_text like "%in_%_digest%"; digest digest_text count_star -c9e17d52ab1d3a423ab1eec7a0a38927 SELECT ? AS in_slave_digest 1 +? SELECT ? AS in_slave_digest 1 **** On Master **** delete from performance_schema.setup_objects where object_schema='master'; === modified file 'mysql-test/suite/perfschema/r/statement_digest.result' --- mysql-test/suite/perfschema/r/statement_digest.result 2014-08-29 11:13:33 +0000 +++ mysql-test/suite/perfschema/r/statement_digest.result 2014-10-09 15:13:28 +0000 @@ -113,43 +113,43 @@ SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS, SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest; SCHEMA_NAME DIGEST DIGEST_TEXT COUNT_STAR SUM_ROWS_AFFECTED SUM_WARNINGS SUM_ERRORS -statements_digest eed7e04cbba55015979c7e0144720d20 TRUNCATE TABLE performance_schema . events_statements_summary_by_digest 1 0 0 0 -statements_digest e4f74e36242a1845b50a95947e2a2207 SELECT ? FROM t1 1 0 0 0 -statements_digest afc93a8bd3f2a1cbdc1d83ad2c5434ad SELECT ? FROM `t1` 1 0 0 0 -statements_digest ac3d6fe0aa8e03dc30461e6bc656fcde SELECT ?, ... FROM t1 2 0 0 0 -statements_digest 74f6362d05cb0488115d46bea22dca71 SELECT ? FROM t2 1 0 0 0 -statements_digest c711072022875a454f9d967d49e58b1a SELECT ?, ... FROM t2 2 0 0 0 -statements_digest 37baee255103083e5608dd893ebf1282 INSERT INTO t1 VALUES (?) 1 1 0 0 -statements_digest 5462af0df967aa92e6dab6a205eff514 INSERT INTO t2 VALUES (?) 1 1 0 0 -statements_digest 6a5180f92d808268fd52e292691756b4 INSERT INTO t3 VALUES (...) 4 4 0 0 -statements_digest 428417563393960bcea862bb0942a3c3 INSERT INTO t4 VALUES (...) 1 1 0 0 -statements_digest 1406833de8b0bd971b4ed4a8a812c2a6 INSERT INTO t5 VALUES (...) 1 1 0 0 -statements_digest 9cd87a128f42563e408470beabce0c67 INSERT INTO t1 VALUES (?) /* , ... */ 2 7 0 0 -statements_digest ad1d1fe91d9a162e932c9ea1f3a608fd INSERT INTO t3 VALUES (...) /* , ... */ 1 3 0 0 -statements_digest ce69c038025346ca067c89642c2f52cf INSERT INTO t5 VALUES (...) /* , ... */ 1 3 0 0 -statements_digest b79f3a1cfcbb7f00a003e0188d65def2 INSERT INTO t1 VALUES ( NULL ) 1 1 0 0 -statements_digest 287b8c44a891b5493d66f7415a8fd66f INSERT INTO t6 VALUES (...) 5 5 0 0 -statements_digest 6b8d1ccb722aa9d1b1626087df7e8c75 SELECT ? + ? 3 0 0 0 -statements_digest 7008434d63e1beb77ddff08d04277941 SELECT ? 1 0 0 0 -statements_digest 918970552d725ac63aa6110b10d9e016 CREATE SCHEMA statements_digest_temp 2 2 0 0 -statements_digest fd673eff746778302416b6dcc29ed9fa DROP SCHEMA statements_digest_temp 2 0 0 0 -statements_digest 70338854a230244d7471b4216ed34286 SELECT ? FROM no_such_table 1 0 0 1 -statements_digest bca52158ca42a81cc284368a33d8af20 CREATE TABLE dup_table ( c CHARACTER (?) ) 2 0 0 1 -statements_digest c28c8c445b70aceb0cd0c7326402a026 DROP TABLE dup_table 1 0 0 0 -statements_digest b4502f9354ff2ee4fb6d67ca1e3153dc INSERT IGNORE INTO t11 VALUES (?) 1 1 1 0 -statements_digest 32a06bfa93118f6a2f6c9559e344d9f9 SHOW WARNINGS 1 0 0 0 -statements_digest b480d4ca5174d6e7c1e3d46a17f0824d PREPARE stmt FROM ? 1 0 0 0 -statements_digest 6b343ebf720214f641d3955a6fbf520f EXECUTE stmt 2 0 0 0 -statements_digest c8308af88ea2a3bb1b488499156d8999 DEALLOCATE PREPARE stmt 1 0 0 0 -statements_digest c58e428c96fe77026d9f59fdde6f0de3 CREATE PROCEDURE p1 ( ) BEGIN SELECT * FROM t12 ; END 1 0 0 0 -statements_digest 41aeaff9006e79233b372bc3f25ec796 CALL p1 ( ) 2 0 0 0 -statements_digest 0c90c632580c8caf6869aa08dcf46beb DROP PROCEDURE p1 1 0 0 0 -statements_digest dcd538bf118d546183a5d437eafe17d1 CREATE FUNCTION `func` ( a INTEGER , b INTEGER ) RETURNS INTEGER (?) RETURN a + b 1 0 0 0 -statements_digest d85a51663d5a6b99c81e896a0af4e764 SELECT func (...) 2 0 0 0 -statements_digest 4b86074b9884872fa2f2796a16bdff0a DROP FUNCTION func 1 0 0 0 -statements_digest 08baa1ccc7d336a98e6f42932aa35444 CREATE TRIGGER trg BEFORE INSERT ON t12 FOR EACH ROW SET @? := ? 1 0 0 0 -statements_digest 1b60f2b7f0a0e834558b396acd888012 INSERT INTO t12 VALUES (?) 2 2 0 0 -statements_digest cc7ff3bd3e5e7c6836cbb89b7c9eec48 DROP TRIGGER trg 1 0 0 0 +statements_digest ? TRUNCATE TABLE performance_schema . events_statements_summary_by_digest 1 0 0 0 +statements_digest ? SELECT ? FROM t1 1 0 0 0 +statements_digest ? SELECT ? FROM `t1` 1 0 0 0 +statements_digest ? SELECT ?, ... FROM t1 2 0 0 0 +statements_digest ? SELECT ? FROM t2 1 0 0 0 +statements_digest ? SELECT ?, ... FROM t2 2 0 0 0 +statements_digest ? INSERT INTO t1 VALUES (?) 1 1 0 0 +statements_digest ? INSERT INTO t2 VALUES (?) 1 1 0 0 +statements_digest ? INSERT INTO t3 VALUES (...) 4 4 0 0 +statements_digest ? INSERT INTO t4 VALUES (...) 1 1 0 0 +statements_digest ? INSERT INTO t5 VALUES (...) 1 1 0 0 +statements_digest ? INSERT INTO t1 VALUES (?) /* , ... */ 2 7 0 0 +statements_digest ? INSERT INTO t3 VALUES (...) /* , ... */ 1 3 0 0 +statements_digest ? INSERT INTO t5 VALUES (...) /* , ... */ 1 3 0 0 +statements_digest ? INSERT INTO t1 VALUES ( NULL ) 1 1 0 0 +statements_digest ? INSERT INTO t6 VALUES (...) 5 5 0 0 +statements_digest ? SELECT ? + ? 3 0 0 0 +statements_digest ? SELECT ? 1 0 0 0 +statements_digest ? CREATE SCHEMA statements_digest_temp 2 2 0 0 +statements_digest ? DROP SCHEMA statements_digest_temp 2 0 0 0 +statements_digest ? SELECT ? FROM no_such_table 1 0 0 1 +statements_digest ? CREATE TABLE dup_table ( c CHARACTER (?) ) 2 0 0 1 +statements_digest ? DROP TABLE dup_table 1 0 0 0 +statements_digest ? INSERT IGNORE INTO t11 VALUES (?) 1 1 1 0 +statements_digest ? SHOW WARNINGS 1 0 0 0 +statements_digest ? PREPARE stmt FROM ? 1 0 0 0 +statements_digest ? EXECUTE stmt 2 0 0 0 +statements_digest ? DEALLOCATE PREPARE stmt 1 0 0 0 +statements_digest ? CREATE PROCEDURE p1 ( ) BEGIN SELECT * FROM t12 ; END 1 0 0 0 +statements_digest ? CALL p1 ( ) 2 0 0 0 +statements_digest ? DROP PROCEDURE p1 1 0 0 0 +statements_digest ? CREATE FUNCTION `func` ( a INTEGER , b INTEGER ) RETURNS INTEGER (?) RETURN a + b 1 0 0 0 +statements_digest ? SELECT func (...) 2 0 0 0 +statements_digest ? DROP FUNCTION func 1 0 0 0 +statements_digest ? CREATE TRIGGER trg BEFORE INSERT ON t12 FOR EACH ROW SET @? := ? 1 0 0 0 +statements_digest ? INSERT INTO t12 VALUES (?) 2 2 0 0 +statements_digest ? DROP TRIGGER trg 1 0 0 0 #################################### # CLEANUP #################################### === modified file 'mysql-test/suite/perfschema/r/statement_digest_consumers.result' --- mysql-test/suite/perfschema/r/statement_digest_consumers.result 2014-08-29 11:13:33 +0000 +++ mysql-test/suite/perfschema/r/statement_digest_consumers.result 2014-10-09 15:13:28 +0000 @@ -128,43 +128,43 @@ #################################### SELECT schema_name, digest, digest_text, count_star FROM performance_schema.events_statements_summary_by_digest; schema_name digest digest_text count_star -statements_digest eed7e04cbba55015979c7e0144720d20 TRUNCATE TABLE performance_schema . events_statements_summary_by_digest 1 -statements_digest e4f74e36242a1845b50a95947e2a2207 SELECT ? FROM t1 1 -statements_digest afc93a8bd3f2a1cbdc1d83ad2c5434ad SELECT ? FROM `t1` 1 -statements_digest ac3d6fe0aa8e03dc30461e6bc656fcde SELECT ?, ... FROM t1 2 -statements_digest 74f6362d05cb0488115d46bea22dca71 SELECT ? FROM t2 1 -statements_digest c711072022875a454f9d967d49e58b1a SELECT ?, ... FROM t2 2 -statements_digest 37baee255103083e5608dd893ebf1282 INSERT INTO t1 VALUES (?) 1 -statements_digest 5462af0df967aa92e6dab6a205eff514 INSERT INTO t2 VALUES (?) 1 -statements_digest 6a5180f92d808268fd52e292691756b4 INSERT INTO t3 VALUES (...) 4 -statements_digest 428417563393960bcea862bb0942a3c3 INSERT INTO t4 VALUES (...) 1 -statements_digest 1406833de8b0bd971b4ed4a8a812c2a6 INSERT INTO t5 VALUES (...) 1 -statements_digest 9cd87a128f42563e408470beabce0c67 INSERT INTO t1 VALUES (?) /* , ... */ 2 -statements_digest ad1d1fe91d9a162e932c9ea1f3a608fd INSERT INTO t3 VALUES (...) /* , ... */ 1 -statements_digest ce69c038025346ca067c89642c2f52cf INSERT INTO t5 VALUES (...) /* , ... */ 1 -statements_digest b79f3a1cfcbb7f00a003e0188d65def2 INSERT INTO t1 VALUES ( NULL ) 1 -statements_digest 287b8c44a891b5493d66f7415a8fd66f INSERT INTO t6 VALUES (...) 5 -statements_digest 6b8d1ccb722aa9d1b1626087df7e8c75 SELECT ? + ? 3 -statements_digest 7008434d63e1beb77ddff08d04277941 SELECT ? 1 -statements_digest 918970552d725ac63aa6110b10d9e016 CREATE SCHEMA statements_digest_temp 2 -statements_digest fd673eff746778302416b6dcc29ed9fa DROP SCHEMA statements_digest_temp 2 -statements_digest 70338854a230244d7471b4216ed34286 SELECT ? FROM no_such_table 1 -statements_digest bca52158ca42a81cc284368a33d8af20 CREATE TABLE dup_table ( c CHARACTER (?) ) 2 -statements_digest c28c8c445b70aceb0cd0c7326402a026 DROP TABLE dup_table 1 -statements_digest b4502f9354ff2ee4fb6d67ca1e3153dc INSERT IGNORE INTO t11 VALUES (?) 1 -statements_digest 32a06bfa93118f6a2f6c9559e344d9f9 SHOW WARNINGS 1 -statements_digest b480d4ca5174d6e7c1e3d46a17f0824d PREPARE stmt FROM ? 1 -statements_digest 6b343ebf720214f641d3955a6fbf520f EXECUTE stmt 2 -statements_digest c8308af88ea2a3bb1b488499156d8999 DEALLOCATE PREPARE stmt 1 -statements_digest c58e428c96fe77026d9f59fdde6f0de3 CREATE PROCEDURE p1 ( ) BEGIN SELECT * FROM t12 ; END 1 -statements_digest 41aeaff9006e79233b372bc3f25ec796 CALL p1 ( ) 2 -statements_digest 0c90c632580c8caf6869aa08dcf46beb DROP PROCEDURE p1 1 -statements_digest dcd538bf118d546183a5d437eafe17d1 CREATE FUNCTION `func` ( a INTEGER , b INTEGER ) RETURNS INTEGER (?) RETURN a + b 1 -statements_digest d85a51663d5a6b99c81e896a0af4e764 SELECT func (...) 2 -statements_digest 4b86074b9884872fa2f2796a16bdff0a DROP FUNCTION func 1 -statements_digest 08baa1ccc7d336a98e6f42932aa35444 CREATE TRIGGER trg BEFORE INSERT ON t12 FOR EACH ROW SET @? := ? 1 -statements_digest 1b60f2b7f0a0e834558b396acd888012 INSERT INTO t12 VALUES (?) 2 -statements_digest cc7ff3bd3e5e7c6836cbb89b7c9eec48 DROP TRIGGER trg 1 +statements_digest ? TRUNCATE TABLE performance_schema . events_statements_summary_by_digest 1 +statements_digest ? SELECT ? FROM t1 1 +statements_digest ? SELECT ? FROM `t1` 1 +statements_digest ? SELECT ?, ... FROM t1 2 +statements_digest ? SELECT ? FROM t2 1 +statements_digest ? SELECT ?, ... FROM t2 2 +statements_digest ? INSERT INTO t1 VALUES (?) 1 +statements_digest ? INSERT INTO t2 VALUES (?) 1 +statements_digest ? INSERT INTO t3 VALUES (...) 4 +statements_digest ? INSERT INTO t4 VALUES (...) 1 +statements_digest ? INSERT INTO t5 VALUES (...) 1 +statements_digest ? INSERT INTO t1 VALUES (?) /* , ... */ 2 +statements_digest ? INSERT INTO t3 VALUES (...) /* , ... */ 1 +statements_digest ? INSERT INTO t5 VALUES (...) /* , ... */ 1 +statements_digest ? INSERT INTO t1 VALUES ( NULL ) 1 +statements_digest ? INSERT INTO t6 VALUES (...) 5 +statements_digest ? SELECT ? + ? 3 +statements_digest ? SELECT ? 1 +statements_digest ? CREATE SCHEMA statements_digest_temp 2 +statements_digest ? DROP SCHEMA statements_digest_temp 2 +statements_digest ? SELECT ? FROM no_such_table 1 +statements_digest ? CREATE TABLE dup_table ( c CHARACTER (?) ) 2 +statements_digest ? DROP TABLE dup_table 1 +statements_digest ? INSERT IGNORE INTO t11 VALUES (?) 1 +statements_digest ? SHOW WARNINGS 1 +statements_digest ? PREPARE stmt FROM ? 1 +statements_digest ? EXECUTE stmt 2 +statements_digest ? DEALLOCATE PREPARE stmt 1 +statements_digest ? CREATE PROCEDURE p1 ( ) BEGIN SELECT * FROM t12 ; END 1 +statements_digest ? CALL p1 ( ) 2 +statements_digest ? DROP PROCEDURE p1 1 +statements_digest ? CREATE FUNCTION `func` ( a INTEGER , b INTEGER ) RETURNS INTEGER (?) RETURN a + b 1 +statements_digest ? SELECT func (...) 2 +statements_digest ? DROP FUNCTION func 1 +statements_digest ? CREATE TRIGGER trg BEFORE INSERT ON t12 FOR EACH ROW SET @? := ? 1 +statements_digest ? INSERT INTO t12 VALUES (?) 2 +statements_digest ? DROP TRIGGER trg 1 SELECT digest, digest_text FROM performance_schema.events_statements_current; digest digest_text #################################### === modified file 'mysql-test/suite/perfschema/r/statement_digest_long_query.result' --- mysql-test/suite/perfschema/r/statement_digest_long_query.result 2014-08-29 11:13:33 +0000 +++ mysql-test/suite/perfschema/r/statement_digest_long_query.result 2014-10-09 15:13:28 +0000 @@ -8,5 +8,5 @@ #################################### SELECT schema_name, digest, digest_text, count_star FROM events_statements_summary_by_digest; schema_name digest digest_text count_star -performance_schema e6cf249edf2d8b5e1e069ff94fe5e186 TRUNCATE TABLE events_statements_summary_by_digest 1 -performance_schema 71cce63db06e262d567ae1630c89b264 SELECT ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ... 1 +performance_schema ? TRUNCATE TABLE events_statements_summary_by_digest 1 +performance_schema ? SELECT ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ? + ... 1 === modified file 'mysql-test/suite/perfschema/t/digest_table_full.test' --- mysql-test/suite/perfschema/t/digest_table_full.test 2013-04-03 05:55:53 +0000 +++ mysql-test/suite/perfschema/t/digest_table_full.test 2014-10-09 15:13:28 +0000 @@ -19,6 +19,7 @@ --echo #################################### --echo # QUERYING PS STATEMENT DIGEST --echo #################################### +--replace_column 2 ? SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS, SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest; === modified file 'mysql-test/suite/perfschema/t/rpl_gtid_func.test' --- mysql-test/suite/perfschema/t/rpl_gtid_func.test 2013-04-03 05:55:53 +0000 +++ mysql-test/suite/perfschema/t/rpl_gtid_func.test 2014-10-09 15:13:28 +0000 @@ -44,6 +44,7 @@ select * from performance_schema.setup_objects order by object_type, object_schema, object_name; +--replace_column 1 ? select digest, digest_text, count_star from performance_schema.events_statements_summary_by_digest where digest_text like "%in_%_digest%"; @@ -66,6 +67,7 @@ select * from performance_schema.setup_objects order by object_type, object_schema, object_name; +--replace_column 1 ? select digest, digest_text, count_star from performance_schema.events_statements_summary_by_digest where digest_text like "%in_%_digest%"; === modified file 'mysql-test/suite/perfschema/t/statement_digest.test' --- mysql-test/suite/perfschema/t/statement_digest.test 2014-08-06 11:17:22 +0000 +++ mysql-test/suite/perfschema/t/statement_digest.test 2014-10-09 15:13:28 +0000 @@ -17,6 +17,7 @@ --echo #################################### --echo # QUERYING PS STATEMENT DIGEST --echo #################################### +--replace_column 2 ? SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS, SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest; === modified file 'mysql-test/suite/perfschema/t/statement_digest_consumers.test' --- mysql-test/suite/perfschema/t/statement_digest_consumers.test 2013-04-03 05:55:53 +0000 +++ mysql-test/suite/perfschema/t/statement_digest_consumers.test 2014-10-09 15:13:28 +0000 @@ -28,7 +28,9 @@ --echo #################################### --echo # QUERYING PS STATEMENT DIGEST --echo #################################### +--replace_column 2 ? SELECT schema_name, digest, digest_text, count_star FROM performance_schema.events_statements_summary_by_digest; +--replace_column 1 ? SELECT digest, digest_text FROM performance_schema.events_statements_current; # Cleanup for Digest === modified file 'mysql-test/suite/perfschema/t/statement_digest_long_query.test' --- mysql-test/suite/perfschema/t/statement_digest_long_query.test 2013-04-03 05:55:53 +0000 +++ mysql-test/suite/perfschema/t/statement_digest_long_query.test 2014-10-09 15:13:28 +0000 @@ -20,4 +20,5 @@ --echo #################################### --echo # QUERYING PS STATEMENT DIGEST --echo #################################### +--replace_column 2 ? SELECT schema_name, digest, digest_text, count_star FROM events_statements_summary_by_digest;