Debian Codegraph @

mysql-test/suite/maria/optimize.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 drop table if exists t1;
3 check table t1;
4 Table Op Msg_type Msg_text
5 test.t1 check status OK
6 OPTIMIZE TABLE t1;
7 Table Op Msg_type Msg_text
8 test.t1 optimize status OK
9 drop table t1;
10 #
11 # MDEV-3870 - Valgrind warnings on OPTIMIZE MyISAM or Aria TABLE with
12 # disabled keys
13 #
14 CREATE TABLE t1 (a INT, KEY(a)) ENGINE=Aria;
15 INSERT INTO t1 VALUES (4),(3),(1),(0);
16 ALTER TABLE t1 DISABLE KEYS;
17 OPTIMIZE TABLE t1;
18 Table Op Msg_type Msg_text
19 test.t1 optimize status OK
20 DROP TABLE t1;
21 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;