-
Type:
Bug
-
Status: Done
-
Priority:
Low
-
Resolution: Fixed
-
Affects Version/s: 5.5.59-38.11, Not 5.6.x, Not 5.7.x
-
Fix Version/s: 5.5.61-38.13, 5.6.41-84.1, 5.7.23-23
-
Component/s: None
-
Labels:
name : main.variables-big comment : " Server [mysqld.1 - pid: 2844 result : fail output : CURRENT_TEST: main.variables-big --- /github/inikep-ps/mysql-test/r/variables-big.result 2018-04-27 16:04:29.989791353 +0300 +++ /github/inikep-ps/mysql-test/r/variables-big.reject 2018-04-27 19:47:27.430521028 +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> NULL SHOW PROCESSLIST +Id User Host db Command Time State Info Rows_sent Rows_examined Rows_read +<Id> root <Host> test Query <Time> NULL SHOW PROCESSLIST 0 0 0
name : main.information_schema-big
start_time : 2018-04-27T16:47:24Z
output : CURRENT_TEST: main.information_schema-big
--- /github/inikep-ps/mysql-test/r/information_schema-big.result 2018-04-27 16:04:29.949792210 +0300
+++ /github/inikep-ps/mysql-test/r/information_schema-big.reject 2018-04-27 19:47:33.218399092 +0300
@@ -20,14 +20,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
PARAMETERS SPECIFIC_SCHEMA
@@ -37,6 +40,7 @@
PROFILING QUERY_ID
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
ROUTINES ROUTINE_SCHEMA
+QUERY_RESPONSE_TIME time
SCHEMATA SCHEMA_NAME
SCHEMA_PRIVILEGES TABLE_SCHEMA
SESSION_STATUS VARIABLE_NAME
@@ -46,9 +50,14 @@
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_ADMIN_COMMAND result_message
SELECT t.table_name, c1.column_name
FROM information_schema.tables t
INNER JOIN
CURRENT_TEST: innodb.innodb_bug14676111 --- /github/inikep-ps/mysql-test/suite/innodb/r/innodb_bug14676111.result 2018-04-27 16:04:30.065789728 +0300 +++ /github/inikep-ps/mysql-test/suite/innodb/r/innodb_bug14676111.reject 2018-04-30 12:24:11.646636539 +0300 @@ -28,12 +28,14 @@ 5.0000 set global innodb_limit_optimistic_insert_debug = 10000; delete from t1 where a=2; +Timeout in wait_condition.inc for SELECT VARIABLE_VALUE < 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS +WHERE VARIABLE_NAME = 'INNODB_PURGE_TRX_ID_AGE' analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status OK select DATA_LENGTH / 16384 from information_schema.TABLES where TABLE_SCHEMA = 'test' and TABLE_NAME = 't1'; DATA_LENGTH / 16384 -3.0000 +5.0000 insert into t1 values (2); delete from t1 where a=2; analyze table t1; @@ -41,13 +43,15 @@ test.t1 analyze status OK select DATA_LENGTH / 16384 from information_schema.TABLES where TABLE_SCHEMA = 'test' and TABLE_NAME = 't1'; DATA_LENGTH / 16384 -2.0000 +3.0000 insert into t1 values (2); delete from t1 where a=2; +Timeout in wait_condition.inc for SELECT VARIABLE_VALUE < 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS +WHERE VARIABLE_NAME = 'INNODB_PURGE_TRX_ID_AGE' analyze table t1; Table Op Msg_type Msg_text test.t1 analyze status OK select DATA_LENGTH / 16384 from information_schema.TABLES where TABLE_SCHEMA = 'test' and TABLE_NAME = 't1'; DATA_LENGTH / 16384 -1.0000 +3.0000 drop table t1;