Debian Codegraph @

mysql-test/suite/maria/repair.test

raw
1 --source include/have_sequence.inc
2 --source include/test_db_charset_latin1.inc
3
4 #
5 # MDEV-11539 test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed upon select from I_S
6 #
7 CREATE TABLE t1 (i INT) ENGINE=Aria TRANSACTIONAL=1;
8 INSERT t1 VALUES (1);
9 LOCK TABLE t1 WRITE;
10 REPAIR TABLE t1;
11 --disable_result_log
12 SELECT * FROM INFORMATION_SCHEMA.TABLES;
13 --enable_result_log
14 SELECT * FROM t1;
15 UNLOCK TABLES;
16 DROP TABLE t1;
17
18 CREATE TABLE t1 (i INT) ENGINE=Aria TRANSACTIONAL=1;
19 INSERT t1 VALUES (1);
20 LOCK TABLE t1 WRITE;
21 OPTIMIZE TABLE t1;
22 --disable_result_log
23 SELECT * FROM INFORMATION_SCHEMA.TABLES;
24 --enable_result_log
25 SELECT * FROM t1;
26 UNLOCK TABLES;
27 DROP TABLE t1;
28
29 --echo
30 --echo # MDEV-17223 Assertion `thd->killed != 0' failed in
31 --echo # ha_maria::enable_indexes
32 --echo #
33
34 CREATE OR REPLACE TABLE t1 (c VARCHAR(1024) NOT NULL) ENGINE=Aria ROW_FORMAT FIXED;
35 insert into t1 select char(seq) from seq_65_to_256;
36 insert into t1 values ("a");
37 --error ER_DUP_ENTRY
38 ALTER TABLE t1 ADD PRIMARY KEY(c(67));
39 select count(*) from t1;
40 drop table t1;
41
42 --echo
43 --echo # MDEV-17223 Assertion `thd->killed != 0' failed in
44 --echo # ha_maria::enable_indexes
45 --echo #
46
47 SET SESSION aria_sort_buffer_size=1023;
48 CREATE TABLE t2 (c TEXT,INDEX(c(1000))) ENGINE=Aria;
49 --disable_warnings
50 INSERT INTO t2 select char(seq) from seq_65_to_255;
51 --enable_warnings
52 SELECT COUNT(*) FROM t2;
53 DROP TABLE t2;
54 SET SESSION aria_sort_buffer_size=default;
55
56 --echo #
57 --echo # End of 10.3 tests
58 --echo #
59
60 --echo #
61 --echo # MDEV-34055 Assertion `readbytes != (size_t)-1 ||
62 --echo # (*__errno_location ()) != 9' failure or corruption errors upon
63 --echo # REPAIR on Aria tables
64 --echo #
65
66 CREATE OR REPLACE TABLE t1 (a INT, b INT, UNIQUE(b), UNIQUE(a)) ENGINE=Aria;
67 INSERT INTO t1 VALUES (1,2);
68 REPAIR TABLE t1 EXTENDED QUICK USE_FRM;
69 CREATE TABLE t2 (c INT) ENGINE=Aria;
70 SELECT * FROM t2;
71 REPLACE INTO t1 VALUES (1,3);
72 REPAIR TABLE t2, t1 QUICK;
73 DROP TABLE t1, t2;
74
75 --echo #
76 --echo # End of 10.5 tests
77 --echo #
78
79 --source include/test_db_charset_restore.inc