Debian Codegraph @

mysql-test/suite/encryption/r/tempfiles.result

raw
1 select @@encrypt_tmp_files;
2 @@encrypt_tmp_files
3 1
4 CREATE TABLE t1(a INT);
5 INSERT INTO t1 VALUES(1),(2);
6 DELETE FROM t1 WHERE a=1;
7 OPTIMIZE TABLE t1;
8 Table Op Msg_type Msg_text
9 test.t1 optimize status OK
10 CHECK TABLE t1;
11 Table Op Msg_type Msg_text
12 test.t1 check status OK
13 DROP TABLE t1;
14 create table t1 (v varchar(10), c char(10), t text, key(v), key(c), key(t(10)));
15 insert into t1 (v) select concat(char(ascii('a')+s2.seq),repeat(' ',s1.seq))
16 from seq_0_to_9 as s1, seq_0_to_26 as s2;
17 update t1 set c=v, t=v;
18 select sql_big_result t,count(t) from t1 group by t limit 10;
19 t count(t)
20 { 10
21 a 10
22 b 10
23 c 10
24 d 10
25 e 10
26 f 10
27 g 10
28 h 10
29 i 10
30 drop table t1;
31 reset master;
32 set @save_binlog_cache_size=@@global.binlog_cache_size;
33 set global binlog_cache_size=8192;
34 connect con1, localhost, root;
35 create table t1 (a text) engine=innodb;
36 start transaction;
37 insert t1 select repeat(seq, 1000) from seq_1_to_15;
38 commit;
39 start transaction;
40 insert t1 select repeat(seq, 1000) from seq_1_to_8;
41 commit;
42 disconnect con1;
43 connect con2, localhost, root;
44 create table t2 (a text) engine=innodb;
45 start transaction;
46 insert t2 select repeat(seq, 1000) from seq_1_to_15;
47 savepoint foo;
48 insert t2 select repeat(seq, 1000) from seq_16_to_30;
49 rollback to savepoint foo;
50 insert t2 select repeat(seq, 1000) from seq_31_to_40;
51 commit;
52 disconnect con2;
53 connection default;
54 flush binary logs;
55 drop table t1, t2;
56 set @@global.binlog_cache_size=@save_binlog_cache_size;
57 select left(a, 10) from t1;
58 left(a, 10)
59 1111111111
60 2222222222
61 3333333333
62 4444444444
63 5555555555
64 6666666666
65 7777777777
66 8888888888
67 9999999999
68 1010101010
69 1111111111
70 1212121212
71 1313131313
72 1414141414
73 1515151515
74 1111111111
75 2222222222
76 3333333333
77 4444444444
78 5555555555
79 6666666666
80 7777777777
81 8888888888
82 select left(a, 10) from t2;
83 left(a, 10)
84 1111111111
85 2222222222
86 3333333333
87 4444444444
88 5555555555
89 6666666666
90 7777777777
91 8888888888
92 9999999999
93 1010101010
94 1111111111
95 1212121212
96 1313131313
97 1414141414
98 1515151515
99 3131313131
100 3232323232
101 3333333333
102 3434343434
103 3535353535
104 3636363636
105 3737373737
106 3838383838
107 3939393939
108 4040404040
109 drop table t1, t2;