summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/r/statement_digest_consumers.result
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2012-09-27 20:09:46 +0200
committerSergei Golubchik <sergii@pisem.net>2012-09-27 20:09:46 +0200
commit474fe6d9d9e0b4d8803bdf439dd017ba0c729729 (patch)
tree6b088655217934bf0cbb6cdf85df0a217ef1d939 /mysql-test/suite/perfschema/r/statement_digest_consumers.result
parentcd9f773020c6ddfc1ea39e9037e4258b8bc32a08 (diff)
downloadmariadb-git-474fe6d9d9e0b4d8803bdf439dd017ba0c729729.tar.gz
fixes for test failures
and small collateral changes mysql-test/lib/My/Test.pm: somehow with "print" we get truncated writes sometimes mysql-test/suite/perfschema/r/digest_table_full.result: md5 hashes of statement digests differ, because yacc token codes are different in mariadb mysql-test/suite/perfschema/r/dml_handler.result: host table is not ported over yet mysql-test/suite/perfschema/r/information_schema.result: host table is not ported over yet mysql-test/suite/perfschema/r/nesting.result: this differs, because we don't rewrite general log queries, and multi-statement packets are logged as a one entry. this result file is identical to what mysql-5.6.5 produces with the --log-raw option. mysql-test/suite/perfschema/r/relaylog.result: MariaDB modifies the binlog index file directly, while MySQL 5.6 has a feature "crash-safe binlog index" and modifies a special "crash-safe" shadow copy of the index file and then moves it over. That's why this test shows "NONE" index file writes in MySQL and "MANY" in MariaDB. mysql-test/suite/perfschema/r/server_init.result: MariaDB initializes the "manager" resources from the "manager" thread, and starts this thread only when --flush-time is not 0. MySQL 5.6 initializes "manager" resources unconditionally on server startup. mysql-test/suite/perfschema/r/stage_mdl_global.result: this differs, because MariaDB disables query cache when query_cache_size=0. MySQL does not do that, and this causes useless mutex locks and waits. mysql-test/suite/perfschema/r/statement_digest.result: md5 hashes of statement digests differ, because yacc token codes are different in mariadb mysql-test/suite/perfschema/r/statement_digest_consumers.result: md5 hashes of statement digests differ, because yacc token codes are different in mariadb mysql-test/suite/perfschema/r/statement_digest_long_query.result: md5 hashes of statement digests differ, because yacc token codes are different in mariadb mysql-test/suite/rpl/r/rpl_mixed_drop_create_temp_table.result: will be updated to match 5.6 when alfranio.correia@oracle.com-20110512172919-c1b5kmum4h52g0ni and anders.song@greatopensource.com-20110105052107-zoab0bsf5a6xxk2y are merged mysql-test/suite/rpl/r/rpl_non_direct_mixed_mixing_engines.result: will be updated to match 5.6 when anders.song@greatopensource.com-20110105052107-zoab0bsf5a6xxk2y is merged
Diffstat (limited to 'mysql-test/suite/perfschema/r/statement_digest_consumers.result')
-rw-r--r--mysql-test/suite/perfschema/r/statement_digest_consumers.result44
1 files changed, 22 insertions, 22 deletions
diff --git a/mysql-test/suite/perfschema/r/statement_digest_consumers.result b/mysql-test/suite/perfschema/r/statement_digest_consumers.result
index c01ae691a8b..6daabcbd8bf 100644
--- a/mysql-test/suite/perfschema/r/statement_digest_consumers.result
+++ b/mysql-test/suite/perfschema/r/statement_digest_consumers.result
@@ -88,28 +88,28 @@ Warning 1265 Data truncated for column 'c' at row 1
####################################
SELECT digest, digest_text, count_star FROM performance_schema.events_statements_summary_by_digest;
digest digest_text count_star
-dee8f4f04e57a5e456c31892855e6835 TRUNCATE TABLE performance_schema . events_statements_summary_by_digest 1
-658a159558b029617bfa7c090827fc31 SELECT ? FROM t1 1
-66c495c9ee7e052e0db2212a0cd7a3cd SELECT ? FROM `t1` 1
-e7f8dc15f1156f57978116e457cc7488 SELECT ?, ... FROM t1 2
-5098d41dbf74d89d261b29400c46dae7 SELECT ? FROM t2 1
-3b8d5477aa795a19c9e9183e4ad04e6b SELECT ?, ... FROM t2 2
-5737343d989b1c42464fd3632614d25e INSERT INTO t1 VALUES (?) 1
-1e7fe109d5dd49394ee079690a029452 INSERT INTO t2 VALUES (?) 1
-d63092ea2fa59316f398af6283bf80a5 INSERT INTO t3 VALUES (...) 1
-7383272b3a17c661872524713abae82f INSERT INTO t4 VALUES (...) 1
-42e8c9d8a502b06ac931886d3ff1ed1e INSERT INTO t5 VALUES (...) 1
-db545539039d269501474510fbc2da56 INSERT INTO t1 VALUES (?) /* , ... */ 2
-446dead39135f87b4fc4168f00dff254 INSERT INTO t3 VALUES (...) /* , ... */ 1
-3ec23fcc5b568c4ad359703ff996e0bd INSERT INTO t5 VALUES (...) /* , ... */ 1
-6b473a776aa59140774b6ee689e68c9e SELECT ? + ? 3
-b608da273ea6dffe2120354f751cc8ba SELECT ? 1
-30046d97cfdc44c95bdaa7f3987d0a20 CREATE SCHEMA statements_digest_temp 2
-8e40e6461f3ab4454ddb8f21b5cda3ba DROP SCHEMA statements_digest_temp 2
-b2a18812618a648d37136507aa1abf76 SELECT ? FROM t11 1
-26b3a8aaadea1ef0afd3658728b3b2c9 CREATE TABLE t11 ( c CHARACTER (?) ) 2
-fe695877d27d136594145ebd4f683491 INSERT INTO t11 VALUES (?) 1
-09dae9a52da4bcb4bd4f396e3f723980 SHOW WARNINGS 1
+d238cb191361f39845a6adb2961f5501 TRUNCATE TABLE performance_schema . events_statements_summary_by_digest 1
+85d75a1b361e6afe5460639bddfc88ed SELECT ? FROM t1 1
+83d5ef3dc373ad216098b07c72e61063 SELECT ? FROM `t1` 1
+ea6492426a33544a059bc12766c5ba3d SELECT ?, ... FROM t1 2
+c050a704c0817ec2865ead136ceea6ec SELECT ? FROM t2 1
+a98062477bd693dacfc0df96c68c5585 SELECT ?, ... FROM t2 2
+72470fa90a09ac60fb0ab822a3d6ade0 INSERT INTO t1 VALUES (?) 1
+3f5fd5225f11e3e8d5e8bda8ee6c1546 INSERT INTO t2 VALUES (?) 1
+2057d54e44b8760b5414781df21e53e5 INSERT INTO t3 VALUES (...) 1
+b6becf79cc1c5b9faf07bcd4680e87d1 INSERT INTO t4 VALUES (...) 1
+7d68bb708120922be9668e8c29b2ba7e INSERT INTO t5 VALUES (...) 1
+16760e44bae66c003e39919411b8adbb INSERT INTO t1 VALUES (?) /* , ... */ 2
+29df714911c3f9b83460385a21b5386d INSERT INTO t3 VALUES (...) /* , ... */ 1
+5504ad628fc868be29157ccf556c6175 INSERT INTO t5 VALUES (...) /* , ... */ 1
+0babf2f70315be35a2a9ad6d3d800960 SELECT ? + ? 3
+060c9d59b5b13bc4ec6188ec4f2822b1 SELECT ? 1
+bce3f7384ae2ab78354b031184fde12d CREATE SCHEMA statements_digest_temp 2
+2a0e36afeaac85dc117c3856388a4fae DROP SCHEMA statements_digest_temp 2
+8761fd6b83357bdd00acd0b301cd1d43 SELECT ? FROM t11 1
+2707097430c8f6e7b8c60d15d1f3ff9a CREATE TABLE t11 ( c CHARACTER (?) ) 2
+503e81940feaf05afaafc435903f6bc3 INSERT INTO t11 VALUES (?) 1
+cb0f8f969018eb9b6019e9fe069f6e2a SHOW WARNINGS 1
SELECT digest, digest_text FROM performance_schema.events_statements_current;
digest digest_text
####################################