Debian Codegraph @

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

raw
1 --source include/have_maria.inc
2 --source include/have_sequence.inc
3 --source include/have_64bit.inc
4
5 set session storage_engine=aria;
6
7 --echo #
8 --echo # BUG#47444 - --myisam_repair_threads > 1 can result in all index
9 --echo # cardinalities=1
10 --echo #
11
12 SET aria_repair_threads=2;
13 SET aria_sort_buffer_size=16384;
14 CREATE TABLE t1(a CHAR(255), KEY(a), KEY(a), KEY(a));
15 INSERT INTO t1 VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(0),(1),(2),(3);
16 --replace_regex /Current aria_sort_buffer_size.*/X/
17 REPAIR TABLE t1;
18 SELECT CARDINALITY FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1';
19 CHECK TABLE t1;
20 DROP TABLE t1;
21 SET aria_sort_buffer_size=@@global.aria_sort_buffer_size;
22 SET aria_repair_threads=@@global.aria_repair_threads;
23
24 --echo #
25 --echo # BUG#47073 - valgrind errs, corruption,failed repair of partition,
26 --echo # low myisam_sort_buffer_size
27 --echo #
28 CREATE TABLE t1(a INT, b CHAR(10), KEY(a), KEY(b));
29 INSERT INTO t1 select seq,'0' from seq_1_to_65536;
30 SET aria_sort_buffer_size=16384;
31 --replace_regex /Current aria_sort_buffer_size.*/X/
32 REPAIR TABLE t1;
33 CHECK TABLE t1;
34 SET aria_repair_threads=2;
35 # May report different values depending on threads activity.
36 --replace_regex /Current aria_sort_buffer_size.*/X/
37 REPAIR TABLE t1;
38 CHECK TABLE t1;
39 SET aria_repair_threads=@@global.aria_repair_threads;
40 SET aria_sort_buffer_size=@@global.aria_sort_buffer_size;
41 DROP TABLE t1;