Debian Codegraph @

mysql-test/suite/innodb/r/innodb_prefix_index_restart_server.result

raw
1 CREATE TABLE worklog5743 (
2 col_1_text TEXT(4000) , col_2_text TEXT(4000) ,
3 PRIMARY KEY (col_1_text(3072))
4 ) charset latin1 ROW_FORMAT=DYNAMIC, engine = innodb;
5 INSERT INTO worklog5743 VALUES(REPEAT("a", 3500) , REPEAT("o", 3500));
6 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
7 worklog5743;
8 col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500)
9 1 1
10 "In connection 1"
11 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
12 worklog5743;
13 col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500)
14 1 1
15 SELECT COUNT(*) FROM worklog5743;
16 COUNT(*)
17 1
18 "In connection 2"
19 START TRANSACTION;
20 INSERT INTO worklog5743 VALUES(REPEAT("b", 3500) , REPEAT("o", 3500));
21 "In connection 1"
22 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
23 worklog5743;
24 col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500)
25 1 1
26 SELECT COUNT(*) FROM worklog5743;
27 COUNT(*)
28 1
29 START TRANSACTION;
30 "In connection default ....restarting the server"
31 # restart
32 SELECT COUNT(*) FROM worklog5743;
33 COUNT(*)
34 1
35 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
36 worklog5743;
37 col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500)
38 1 1
39 "In connection 1"
40 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
41 worklog5743;
42 col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500)
43 1 1
44 SELECT COUNT(*) FROM worklog5743;
45 COUNT(*)
46 1
47 START TRANSACTION;
48 INSERT INTO worklog5743 VALUES(REPEAT("b", 3500) , REPEAT("o", 3500));
49 DELETE FROM worklog5743 WHERE col_1_text = REPEAT("b", 3500);
50 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
51 worklog5743;
52 col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500)
53 1 1
54 "In connection default ....restarting the server"
55 # restart
56 SELECT COUNT(*) FROM worklog5743;
57 COUNT(*)
58 1
59 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
60 worklog5743;
61 col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500)
62 1 1
63 "In connection 1"
64 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
65 worklog5743;
66 col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500)
67 1 1
68 SELECT COUNT(*) FROM worklog5743;
69 COUNT(*)
70 1
71 START TRANSACTION;
72 UPDATE worklog5743 SET col_1_text = REPEAT("b", 3500) WHERE col_1_text = REPEAT("a", 3500);
73 SELECT col_1_text = REPEAT("b", 3500) , col_2_text = REPEAT("o", 3500) FROM
74 worklog5743;
75 col_1_text = REPEAT("b", 3500) col_2_text = REPEAT("o", 3500)
76 1 1
77 "In connection default ....restarting the server"
78 # restart
79 SELECT COUNT(*) FROM worklog5743;
80 COUNT(*)
81 1
82 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
83 worklog5743;
84 col_1_text = REPEAT("a", 3500) col_2_text = REPEAT("o", 3500)
85 1 1
86 DROP TABLE worklog5743;
87 SET sql_mode='NO_ENGINE_SUBSTITUTION';
88 create table t1(f1 varchar(3800) binary not null, key(f1))
89 character set utf8 collate utf8_general_ci row_format=dynamic;
90 Warnings:
91 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
92 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
93 Warning 3778 'utf8mb3_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
94 Warning 1071 Specified key was too long; max key length is 3072 bytes
95 insert into t1 values('aaa');
96 drop table t1;
97 SET sql_mode=default;