Debian Codegraph @

mysql-test/suite/maria/repair.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 CREATE TABLE t1 (i INT) ENGINE=Aria TRANSACTIONAL=1;
3 INSERT t1 VALUES (1);
4 LOCK TABLE t1 WRITE;
5 REPAIR TABLE t1;
6 Table Op Msg_type Msg_text
7 test.t1 repair status OK
8 SELECT * FROM INFORMATION_SCHEMA.TABLES;
9 SELECT * FROM t1;
10 i
11 1
12 UNLOCK TABLES;
13 DROP TABLE t1;
14 CREATE TABLE t1 (i INT) ENGINE=Aria TRANSACTIONAL=1;
15 INSERT t1 VALUES (1);
16 LOCK TABLE t1 WRITE;
17 OPTIMIZE TABLE t1;
18 Table Op Msg_type Msg_text
19 test.t1 optimize status OK
20 SELECT * FROM INFORMATION_SCHEMA.TABLES;
21 SELECT * FROM t1;
22 i
23 1
24 UNLOCK TABLES;
25 DROP TABLE t1;
26
27 # MDEV-17223 Assertion `thd->killed != 0' failed in
28 # ha_maria::enable_indexes
29 #
30 CREATE OR REPLACE TABLE t1 (c VARCHAR(1024) NOT NULL) ENGINE=Aria ROW_FORMAT FIXED;
31 insert into t1 select char(seq) from seq_65_to_256;
32 insert into t1 values ("a");
33 ALTER TABLE t1 ADD PRIMARY KEY(c(67));
34 ERROR 23000: Duplicate entry 'a' for key 'PRIMARY'
35 select count(*) from t1;
36 count(*)
37 193
38 drop table t1;
39
40 # MDEV-17223 Assertion `thd->killed != 0' failed in
41 # ha_maria::enable_indexes
42 #
43 SET SESSION aria_sort_buffer_size=1023;
44 Warnings:
45 Warning 1292 Truncated incorrect aria_sort_buffer_size value: '1023'
46 CREATE TABLE t2 (c TEXT,INDEX(c(1000))) ENGINE=Aria;
47 INSERT INTO t2 select char(seq) from seq_65_to_255;
48 SELECT COUNT(*) FROM t2;
49 COUNT(*)
50 191
51 DROP TABLE t2;
52 SET SESSION aria_sort_buffer_size=default;
53 #
54 # End of 10.3 tests
55 #
56 #
57 # MDEV-34055 Assertion `readbytes != (size_t)-1 ||
58 # (*__errno_location ()) != 9' failure or corruption errors upon
59 # REPAIR on Aria tables
60 #
61 CREATE OR REPLACE TABLE t1 (a INT, b INT, UNIQUE(b), UNIQUE(a)) ENGINE=Aria;
62 INSERT INTO t1 VALUES (1,2);
63 REPAIR TABLE t1 EXTENDED QUICK USE_FRM;
64 Table Op Msg_type Msg_text
65 test.t1 repair warning Number of rows changed from 0 to 1
66 test.t1 repair status OK
67 CREATE TABLE t2 (c INT) ENGINE=Aria;
68 SELECT * FROM t2;
69 c
70 REPLACE INTO t1 VALUES (1,3);
71 REPAIR TABLE t2, t1 QUICK;
72 Table Op Msg_type Msg_text
73 test.t2 repair status OK
74 test.t1 repair status OK
75 DROP TABLE t1, t2;
76 #
77 # End of 10.5 tests
78 #
79 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;