Some --big-test MTR tests fail for Percona Server

[Laurynas Biveinis]

--big-test MTR tests have not been updated for Percona Server. As a result, some of them fail. This bug is for tests where the issue is a missed simple .test/.result update. Test failures exposing server bugs will have separate bugs if needed.

[Laurynas Biveinis (laurynas-biveinis)]

main.information_schema-big [ fail ]
        Test ended at 2015-02-09 16:44:58

CURRENT_TEST: main.information_schema-big
--- /Users/laurynas/percona/lp-mysql-server/big-test-fixes/mysql-test/r/information_schema-big.result 2015-02-06 12:11:37.000000000 +0300
+++ /Users/laurynas/percona/lp-mysql-server/big-test-fixes/obj-debug/mysql-test/var/log/information_schema-big.reject 2015-02-09 17:44:57.000000000 +0300
@@ -21,14 +21,17 @@
   AND t.table_name NOT LIKE 'innodb%';
 table_name column_name
 CHARACTER_SETS CHARACTER_SET_NAME
+CLIENT_STATISTICS CLIENT
 COLLATIONS COLLATION_NAME
 COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME
 COLUMNS TABLE_SCHEMA
 COLUMN_PRIVILEGES TABLE_SCHEMA
+INDEX_STATISTICS TABLE_SCHEMA
 ENGINES ENGINE
 EVENTS EVENT_SCHEMA
 FILES TABLE_SCHEMA
 GLOBAL_STATUS VARIABLE_NAME
+GLOBAL_TEMPORARY_TABLES TABLE_SCHEMA
 GLOBAL_VARIABLES VARIABLE_NAME
 KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
 OPTIMIZER_TRACE QUERY
@@ -48,9 +51,16 @@
 TABLESPACES TABLESPACE_NAME
 TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
 TABLE_PRIVILEGES TABLE_SCHEMA
+TABLE_STATISTICS TABLE_SCHEMA
+TEMPORARY_TABLES TABLE_SCHEMA
+THREAD_STATISTICS THREAD_ID
 TRIGGERS TRIGGER_SCHEMA
 USER_PRIVILEGES GRANTEE
+USER_STATISTICS USER
 VIEWS TABLE_SCHEMA
+XTRADB_INTERNAL_HASH_TABLES INTERNAL_HASH_TABLE_NAME
+XTRADB_RSEG rseg_id
+XTRADB_READ_VIEW READ_VIEW_UNDO_NUMBER
 SELECT t.table_name, c1.column_name
 FROM information_schema.tables t
 INNER JOIN
@@ -69,14 +79,17 @@
   AND t.table_name NOT LIKE 'innodb%';
 table_name column_name
 CHARACTER_SETS CHARACTER_SET_NAME
+CLIENT_STATISTICS CLIENT
 COLLATIONS COLLATION_NAME
 COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME
 COLUMNS TABLE_SCHEMA
 COLUMN_PRIVILEGES TABLE_SCHEMA
+INDEX_STATISTICS TABLE_SCHEMA
 ENGINES ENGINE
 EVENTS EVENT_SCHEMA
 FILES TABLE_SCHEMA
 GLOBAL_STATUS VARIABLE_NAME
+GLOBAL_TEMPORARY_TABLES TABLE_SCHEMA
 GLOBAL_VARIABLES VARIABLE_NAME
 KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
 OPTIMIZER_TRACE QUERY
@@ -96,6 +109,13 @@
 TABLESPACES TABLESPACE_NAME
 TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
 TABLE_PRIVILEGES TABLE_SCHEMA
+TABLE_STATISTICS TABLE_SCHEMA
+TEMPORARY_TABLES TABLE_SCHEMA
+THREAD_STATISTICS THREAD_ID
 TRIGGERS TRIGGER_SCHEMA
 USER_PRIVILEGES GRANTEE
+USER_STATISTICS USER
 VIEWS TABLE_SCHEMA
+XTRADB_INTERNAL_HASH_TABLES INTERNAL_HASH_TABLE_NAME
+XTRADB_RSEG rseg_id
+XTRADB_READ_VIEW READ_VIEW_UNDO_NUMBER

mysqltest: Result content mismatch

[Laurynas Biveinis (laurynas-biveinis)]

main.variables-big [ fail ]
        Test ended at 2015-02-09 16:55:30

CURRENT_TEST: main.variables-big
--- /Users/laurynas/percona/lp-mysql-server/big-test-fixes/mysql-test/r/variables-big.result 2015-02-06 12:11:37.000000000 +0300
+++ /Users/laurynas/percona/lp-mysql-server/big-test-fixes/obj-debug/mysql-test/var/log/variables-big.reject 2015-02-09 17:55:30.000000000 +0300
@@ -1,22 +1,22 @@
 SET @def_var= @@session.transaction_prealloc_size;
 SET SESSION transaction_prealloc_size=1024*1024*1024*1;
 SHOW PROCESSLIST;
-Id User Host db Command Time State Info
-<Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST
+Id User Host db Command Time State Info Rows_sent Rows_examined
+<Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST 0 0
 SET SESSION transaction_prealloc_size=1024*1024*1024*2;
 SHOW PROCESSLIST;
-Id User Host db Command Time State Info
-<Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST
+Id User Host db Command Time State Info Rows_sent Rows_examined
+<Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST 0 0
 SET SESSION transaction_prealloc_size=1024*1024*1024*3;
 SHOW PROCESSLIST;
-Id User Host db Command Time State Info
-<Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST
+Id User Host db Command Time State Info Rows_sent Rows_examined
+<Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST 0 0
 SET SESSION transaction_prealloc_size=1024*1024*1024*4;
 SHOW PROCESSLIST;
-Id User Host db Command Time State Info
-<Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST
+Id User Host db Command Time State Info Rows_sent Rows_examined
+<Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST 0 0
 SET SESSION transaction_prealloc_size=1024*1024*1024*5;
 SHOW PROCESSLIST;
-Id User Host db Command Time State Info
-<Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST
+Id User Host db Command Time State Info Rows_sent Rows_examined
+<Id> root <Host> test Query <Time> <State> SHOW PROCESSLIST 0 0
 SET @@session.transaction_prealloc_size= @def_var;

mysqltest: Result content mismatch

[Shahriyar Rzayev (rzayev-sehriyar)]

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