Debian Codegraph @

mysql-test/suite/innodb/r/row_format_redundant.result

raw
1 SET GLOBAL innodb_fast_shutdown=0;
2 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-data-file-path=ibdata1:1M:autoextend --innodb_undo_directory=MYSQLTEST_VARDIR/tmp/undo_dir --innodb-undo-tablespaces=0 --innodb-stats-persistent=0
3 #
4 # Bug#21644827 - FTS, ASSERT !SRV_READ_ONLY_MODE || M_IMPL.M_LOG_MODE ==
5 # MTR_LOG_NO_REDO
6 #
7 create table t1 (a int not null, d varchar(15) not null, b
8 varchar(198) not null, c char(156)) engine=InnoDB
9 row_format=redundant;
10 create temporary table t like t1;
11 insert into t values(123, 'abcdef', 'jghikl', 'mnop');
12 insert into t values(456, 'abcdef', 'jghikl', 'mnop');
13 insert into t values(789, 'abcdef', 'jghikl', 'mnop');
14 insert into t values(134, 'kasdfsdsadf', 'adfjlasdkfjasd', 'adfsadflkasdasdfljasdf');
15 insert into t1 select a,d,b,c from t, seq_1_to_1024;
16 SET GLOBAL innodb_file_per_table=OFF;
17 Warnings:
18 Warning 1287 '@@innodb_file_per_table' is deprecated and will be removed in a future release
19 create table t2 (a int not null, d varchar(15) not null, b
20 varchar(198) not null, c char(156), fulltext ftsic(c)) engine=InnoDB
21 row_format=redundant;
22 insert into t2 select a,d,b,c from t, seq_1_to_1024;
23 create table t3 (a int not null, d varchar(15) not null, b varchar(198),
24 c varchar(150), index k1(c(99), b(56)), index k2(b(5), c(10))) engine=InnoDB
25 row_format=redundant;
26 insert into t3 values(444, 'dddd', 'bbbbb', 'aaaaa');
27 insert into t3 values(555, 'eeee', 'ccccc', 'aaaaa');
28 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-data-file-path=ibdata1:1M:autoextend --innodb_undo_directory=MYSQLTEST_VARDIR/tmp/undo_dir --innodb-undo-tablespaces=0 --innodb-stats-persistent=0 --innodb-read-only
29 SELECT COUNT(*) FROM t1;
30 COUNT(*)
31 4096
32 SELECT COUNT(*) FROM t2;
33 COUNT(*)
34 4096
35 SELECT COUNT(*) FROM t3;
36 COUNT(*)
37 2
38 TRUNCATE TABLE t1;
39 ERROR HY000: Table 't1' is read only
40 TRUNCATE TABLE t2;
41 ERROR HY000: Table 't2' is read only
42 TRUNCATE TABLE t3;
43 ERROR HY000: Table 't3' is read only
44 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-data-file-path=ibdata1:1M:autoextend --innodb_undo_directory=MYSQLTEST_VARDIR/tmp/undo_dir --innodb-undo-tablespaces=0 --innodb-stats-persistent=0 --skip-innodb-fast-shutdown
45 TRUNCATE TABLE t1;
46 TRUNCATE TABLE t2;
47 TRUNCATE TABLE t3;
48 corrupted SYS_TABLES.MIX_LEN for test/t1
49 corrupted SYS_TABLES.MIX_LEN for test/t2
50 corrupted SYS_TABLES.MIX_LEN for test/t3
51 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/row_format_redundant --innodb-data-file-path=ibdata1:1M:autoextend --innodb_undo_directory=MYSQLTEST_VARDIR/tmp/undo_dir --innodb-undo-tablespaces=0 --innodb-stats-persistent=0 --skip-innodb-fast-shutdown
52 TRUNCATE TABLE t1;
53 ERROR 42S02: Table 'test.t1' doesn't exist in engine
54 TRUNCATE TABLE t2;
55 TRUNCATE TABLE t3;
56 SELECT COUNT(*) FROM t1;
57 ERROR 42S02: Table 'test.t1' doesn't exist in engine
58 SELECT COUNT(*) FROM t2;
59 COUNT(*)
60 0
61 SELECT COUNT(*) FROM t3;
62 COUNT(*)
63 0
64 RENAME TABLE t1 TO tee_one;
65 ERROR HY000: Error on rename of './test/t1' to './test/tee_one' (errno: 155 "The table does not exist in the storage engine")
66 DROP TABLE t1;
67 Warnings:
68 Warning 1932 Table 'test.t1' doesn't exist in engine
69 DROP TABLE t2,t3;
70 FOUND 1 /\[ERROR\] InnoDB: Table test/t1 in InnoDB data dictionary contains invalid flags\. SYS_TABLES\.TYPE=1 SYS_TABLES\.MIX_LEN=511\b.*/ in mysqld.1.err
71 # restart
72 ib_logfile0
73 ibdata1
74 db.opt