Debian Codegraph @

mysql-test/suite/maria/maria-64bit.result

raw
1 set session storage_engine=aria;
2 Warnings:
3 Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
4 #
5 # BUG#47444 - --myisam_repair_threads > 1 can result in all index
6 # cardinalities=1
7 #
8 SET aria_repair_threads=2;
9 SET aria_sort_buffer_size=16384;
10 CREATE TABLE t1(a CHAR(255), KEY(a), KEY(a), KEY(a));
11 Warnings:
12 Note 1831 Duplicate index `a_2`. This is deprecated and will be disallowed in a future release
13 Note 1831 Duplicate index `a_3`. This is deprecated and will be disallowed in a future release
14 INSERT INTO t1 VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(0),(1),(2),(3);
15 REPAIR TABLE t1;
16 Table Op Msg_type Msg_text
17 test.t1 repair status OK
18 SELECT CARDINALITY FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1';
19 CARDINALITY
20 14
21 14
22 14
23 CHECK TABLE t1;
24 Table Op Msg_type Msg_text
25 test.t1 check status OK
26 DROP TABLE t1;
27 SET aria_sort_buffer_size=@@global.aria_sort_buffer_size;
28 SET aria_repair_threads=@@global.aria_repair_threads;
29 #
30 # BUG#47073 - valgrind errs, corruption,failed repair of partition,
31 # low myisam_sort_buffer_size
32 #
33 CREATE TABLE t1(a INT, b CHAR(10), KEY(a), KEY(b));
34 INSERT INTO t1 select seq,'0' from seq_1_to_65536;
35 SET aria_sort_buffer_size=16384;
36 REPAIR TABLE t1;
37 Table Op Msg_type Msg_text
38 test.t1 repair status OK
39 CHECK TABLE t1;
40 Table Op Msg_type Msg_text
41 test.t1 check status OK
42 SET aria_repair_threads=2;
43 REPAIR TABLE t1;
44 Table Op Msg_type Msg_text
45 test.t1 repair status OK
46 CHECK TABLE t1;
47 Table Op Msg_type Msg_text
48 test.t1 check status OK
49 SET aria_repair_threads=@@global.aria_repair_threads;
50 SET aria_sort_buffer_size=@@global.aria_sort_buffer_size;
51 DROP TABLE t1;