summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb_zip/r/wl6501_debug.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/innodb_zip/r/wl6501_debug.result')
-rw-r--r--mysql-test/suite/innodb_zip/r/wl6501_debug.result390
1 files changed, 0 insertions, 390 deletions
diff --git a/mysql-test/suite/innodb_zip/r/wl6501_debug.result b/mysql-test/suite/innodb_zip/r/wl6501_debug.result
deleted file mode 100644
index 9d712485a7f..00000000000
--- a/mysql-test/suite/innodb_zip/r/wl6501_debug.result
+++ /dev/null
@@ -1,390 +0,0 @@
-call mtr.add_suppression("The file '.*' already exists though the corresponding table did not exist in the InnoDB data dictionary");
-call mtr.add_suppression("Cannot create file '.*'");
-call mtr.add_suppression("InnoDB: Error number 17 means 'File exists'");
-"1. Hit crash point on completing drop of all indexes before creation"
-" of index is commenced."
-set global innodb_file_per_table = 1;
-set global innodb_file_format = 'Antelope';
-Warnings:
-Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
-set innodb_strict_mode=off;
-create table t (
-i int, f float, c char,
-primary key pk(i), unique findex(f), index ck(c))
-engine = innodb row_format = compact
-key_block_size = 16;
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-set session debug = "+d,ib_trunc_crash_drop_reinit_done_create_to_start";
-truncate table t;
-ERROR HY000: Lost connection to MySQL server during query
-# restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-select * from t where f < 2.5;
-i f c
-1 1.1 a
-2 2.2 b
-drop table t;
-"2. Hit crash point after data is updated to system-table and"
-" in-memory dict."
-set global innodb_file_per_table = 1;
-set global innodb_file_format = 'Antelope';
-Warnings:
-Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
-set innodb_strict_mode=off;
-create table t (
-i int, f float, c char,
-primary key pk(i), unique findex(f), index ck(c))
-engine = innodb row_format = compact
-key_block_size = 16;
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-set session debug = "+d,ib_trunc_crash_on_updating_dict_sys_info";
-truncate table t;
-ERROR HY000: Lost connection to MySQL server during query
-# restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-select * from t where f < 2.5;
-i f c
-1 1.1 a
-2 2.2 b
-drop table t;
-"3. Post truncate recovery, abruptly shutdown the server."
-" On restart ensure table state is maintained."
-set global innodb_file_per_table = 1;
-set global innodb_file_format = 'Antelope';
-Warnings:
-Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
-set innodb_strict_mode=off;
-create table t (
-i int, f float, c char,
-primary key pk(i), unique findex(f), index ck(c))
-engine = innodb row_format = compact
-key_block_size = 16;
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-set session debug = "+d,ib_trunc_crash_after_redo_log_write_complete";
-truncate table t;
-ERROR HY000: Lost connection to MySQL server during query
-# restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-# Kill and restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-select * from t where f < 2.5;
-i f c
-1 1.1 a
-2 2.2 b
-drop table t;
-call mtr.add_suppression("The file '.*' already exists though the corresponding table did not exist in the InnoDB data dictionary");
-call mtr.add_suppression("Cannot create file '.*'");
-call mtr.add_suppression("InnoDB: Error number 17 means 'File exists'");
-"1. Hit crash point on completing drop of all indexes before creation"
-" of index is commenced."
-set global innodb_file_per_table = 0;
-set global innodb_file_format = 'Antelope';
-Warnings:
-Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
-set innodb_strict_mode=off;
-create table t (
-i int, f float, c char,
-primary key pk(i), unique findex(f), index ck(c))
-engine = innodb row_format = compact
-key_block_size = 16;
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-set session debug = "+d,ib_trunc_crash_drop_reinit_done_create_to_start";
-truncate table t;
-ERROR HY000: Lost connection to MySQL server during query
-# restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-select * from t where f < 2.5;
-i f c
-1 1.1 a
-2 2.2 b
-drop table t;
-"2. Hit crash point after data is updated to system-table and"
-" in-memory dict."
-set global innodb_file_per_table = 0;
-set global innodb_file_format = 'Antelope';
-Warnings:
-Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
-set innodb_strict_mode=off;
-create table t (
-i int, f float, c char,
-primary key pk(i), unique findex(f), index ck(c))
-engine = innodb row_format = compact
-key_block_size = 16;
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-set session debug = "+d,ib_trunc_crash_on_updating_dict_sys_info";
-truncate table t;
-ERROR HY000: Lost connection to MySQL server during query
-# restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-select * from t where f < 2.5;
-i f c
-1 1.1 a
-2 2.2 b
-drop table t;
-"3. Post truncate recovery, abruptly shutdown the server."
-" On restart ensure table state is maintained."
-set global innodb_file_per_table = 0;
-set global innodb_file_format = 'Antelope';
-Warnings:
-Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
-set innodb_strict_mode=off;
-create table t (
-i int, f float, c char,
-primary key pk(i), unique findex(f), index ck(c))
-engine = innodb row_format = compact
-key_block_size = 16;
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-set session debug = "+d,ib_trunc_crash_after_redo_log_write_complete";
-truncate table t;
-ERROR HY000: Lost connection to MySQL server during query
-# restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-# Kill and restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-select * from t where f < 2.5;
-i f c
-1 1.1 a
-2 2.2 b
-drop table t;
-call mtr.add_suppression("The file '.*' already exists though the corresponding table did not exist in the InnoDB data dictionary");
-call mtr.add_suppression("Cannot create file '.*'");
-call mtr.add_suppression("InnoDB: Error number 17 means 'File exists'");
-"1. Hit crash point on completing drop of all indexes before creation"
-" of index is commenced."
-set global innodb_file_per_table = 1;
-set global innodb_file_format = 'Barracuda';
-Warnings:
-Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
-set innodb_strict_mode=off;
-create table t (
-i int, f float, c char,
-primary key pk(i), unique findex(f), index ck(c))
-engine = innodb row_format = compressed
-key_block_size = 16;
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-set session debug = "+d,ib_trunc_crash_drop_reinit_done_create_to_start";
-truncate table t;
-ERROR HY000: Lost connection to MySQL server during query
-# restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-select * from t where f < 2.5;
-i f c
-1 1.1 a
-2 2.2 b
-drop table t;
-"2. Hit crash point after data is updated to system-table and"
-" in-memory dict."
-set global innodb_file_per_table = 1;
-set global innodb_file_format = 'Barracuda';
-Warnings:
-Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
-set innodb_strict_mode=off;
-create table t (
-i int, f float, c char,
-primary key pk(i), unique findex(f), index ck(c))
-engine = innodb row_format = compressed
-key_block_size = 16;
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-set session debug = "+d,ib_trunc_crash_on_updating_dict_sys_info";
-truncate table t;
-ERROR HY000: Lost connection to MySQL server during query
-# restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-select * from t where f < 2.5;
-i f c
-1 1.1 a
-2 2.2 b
-drop table t;
-"3. Post truncate recovery, abruptly shutdown the server."
-" On restart ensure table state is maintained."
-set global innodb_file_per_table = 1;
-set global innodb_file_format = 'Barracuda';
-Warnings:
-Warning 131 Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
-set innodb_strict_mode=off;
-create table t (
-i int, f float, c char,
-primary key pk(i), unique findex(f), index ck(c))
-engine = innodb row_format = compressed
-key_block_size = 16;
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-set session debug = "+d,ib_trunc_crash_after_redo_log_write_complete";
-truncate table t;
-ERROR HY000: Lost connection to MySQL server during query
-# restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c');
-# Kill and restart
-check table t;
-Table Op Msg_type Msg_text
-test.t check status OK
-select * from t;
-i f c
-1 1.1 a
-2 2.2 b
-3 3.3 c
-select * from t where f < 2.5;
-i f c
-1 1.1 a
-2 2.2 b
-drop table t;
View Lorry Controller Status