Debian Codegraph @

mysql-test/suite/maria/repair-big-sort.result

raw
1 SET sql_mode='';
2 CREATE TEMPORARY TABLE t1 (a tinyINT,b CHAR(1)) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
3 INSERT INTO t1 VALUES (1,1),(3,3),(2,2);
4 SET SESSION tmp_table_size=True;
5 Warnings:
6 Warning 1292 Truncated incorrect tmp_table_size value: '1'
7 CREATE TABLE t2 (c INT, d DATE) ENGINE=InnoDB PARTITION BY RANGE (YEAR (d)) SUBPARTITION BY HASH (TO_DAYS (d)) (PARTITION p0 VALUES LESS THAN (1990) (SUBPARTITION s0, SUBPARTITION s1), PARTITION p1 VALUES LESS THAN MAXVALUE (SUBPARTITION s4, SUBPARTITION s5));
8 SET SESSION aria_sort_buffer_size=CAST(-1 AS UNSIGNED INT);
9 Warnings:
10 Note 1105 Cast to unsigned converted negative integer to it's positive complement
11 Note 1105 Cast to unsigned converted negative integer to it's positive complement
12 Warning 1292 Truncated incorrect aria_sort_buffer_size value: '18446744073709551615'
13 INSERT INTO t1 SELECT '', SEQ FROM seq_1_to_258;
14 Warnings:
15 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 1
16 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 2
17 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 3
18 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 4
19 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 5
20 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 6
21 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 7
22 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 8
23 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 9
24 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 10
25 Warning 1265 Data truncated for column 'b' at row 10
26 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 11
27 Warning 1265 Data truncated for column 'b' at row 11
28 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 12
29 Warning 1265 Data truncated for column 'b' at row 12
30 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 13
31 Warning 1265 Data truncated for column 'b' at row 13
32 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 14
33 Warning 1265 Data truncated for column 'b' at row 14
34 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 15
35 Warning 1265 Data truncated for column 'b' at row 15
36 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 16
37 Warning 1265 Data truncated for column 'b' at row 16
38 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 17
39 Warning 1265 Data truncated for column 'b' at row 17
40 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 18
41 Warning 1265 Data truncated for column 'b' at row 18
42 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 19
43 Warning 1265 Data truncated for column 'b' at row 19
44 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 20
45 Warning 1265 Data truncated for column 'b' at row 20
46 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 21
47 Warning 1265 Data truncated for column 'b' at row 21
48 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 22
49 Warning 1265 Data truncated for column 'b' at row 22
50 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 23
51 Warning 1265 Data truncated for column 'b' at row 23
52 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 24
53 Warning 1265 Data truncated for column 'b' at row 24
54 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 25
55 Warning 1265 Data truncated for column 'b' at row 25
56 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 26
57 Warning 1265 Data truncated for column 'b' at row 26
58 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 27
59 Warning 1265 Data truncated for column 'b' at row 27
60 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 28
61 Warning 1265 Data truncated for column 'b' at row 28
62 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 29
63 Warning 1265 Data truncated for column 'b' at row 29
64 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 30
65 Warning 1265 Data truncated for column 'b' at row 30
66 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 31
67 Warning 1265 Data truncated for column 'b' at row 31
68 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 32
69 Warning 1265 Data truncated for column 'b' at row 32
70 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 33
71 Warning 1265 Data truncated for column 'b' at row 33
72 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 34
73 Warning 1265 Data truncated for column 'b' at row 34
74 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 35
75 Warning 1265 Data truncated for column 'b' at row 35
76 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 36
77 Warning 1265 Data truncated for column 'b' at row 36
78 Warning 1366 Incorrect integer value: '' for column `test`.`t1`.`a` at row 37
79 SET SESSION aria_repair_threads=4;
80 UPDATE t1 SET a=( (SELECT MAX(a) FROM t1));
81 drop table t1,t2;