Debian Codegraph @

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

raw
1 CREATE TABLE t1 (a INT PRIMARY KEY, b TEXT) ENGINE=InnoDB;
2 CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=InnoDB;
3 CREATE TABLE t3 (a INT PRIMARY KEY, b TEXT, c TEXT) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1,REPEAT('a',30000)),(2,REPEAT('b',40000));
5 SET DEBUG_SYNC='before_row_upd_extern SIGNAL have_latch WAIT_FOR go1';
6 BEGIN;
7 UPDATE t1 SET a=a+2;
8 ROLLBACK;
9 BEGIN;
10 UPDATE t1 SET b=CONCAT(b,'foo');
11 SET DEBUG_SYNC='now WAIT_FOR have_latch';
12 SELECT a, RIGHT(b,20) FROM t1;
13 SET DEBUG_SYNC='now SIGNAL go1';
14 a RIGHT(b,20)
15 1 aaaaaaaaaaaaaaaaaaaa
16 2 bbbbbbbbbbbbbbbbbbbb
17 SET DEBUG='+d,row_ins_extern_checkpoint';
18 SET DEBUG_SYNC='before_row_ins_extern_latch SIGNAL rec_not_blob WAIT_FOR crash';
19 ROLLBACK;
20 BEGIN;
21 INSERT INTO t1 VALUES (3,REPEAT('c',50000));
22 SET DEBUG_SYNC='now WAIT_FOR rec_not_blob';
23 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
24 SELECT @@transaction_isolation;
25 @@transaction_isolation
26 READ-UNCOMMITTED
27 SELECT a, RIGHT(b,20) FROM t1;
28 a RIGHT(b,20)
29 1 aaaaaaaaaaaaaaaaaaaa
30 2 bbbbbbbbbbbbbbbbbbbb
31 SELECT a FROM t1;
32 a
33 1
34 2
35 3
36 SET DEBUG='+d,crash_commit_before';
37 INSERT INTO t2 VALUES (42);
38 ERROR HY000: Lost connection to MySQL server during query
39 ERROR HY000: Lost connection to MySQL server during query
40 CHECK TABLE t1;
41 Table Op Msg_type Msg_text
42 test.t1 check status OK
43 INSERT INTO t3 VALUES
44 (1,REPEAT('d',7000),REPEAT('e',100)),
45 (2,REPEAT('g',7000),REPEAT('h',100));
46 SET DEBUG_SYNC='blob_write_middle SIGNAL go_sel WAIT_FOR go_upd';
47 UPDATE t3 SET c=REPEAT('f',3000) WHERE a=1;
48 # Connection con1:
49 SET DEBUG_SYNC='now WAIT_FOR go_sel';
50 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
51 SELECT @@transaction_isolation;
52 @@transaction_isolation
53 READ-UNCOMMITTED
54 SELECT a, RIGHT(b,20), RIGHT(c,20) FROM t3;
55 a RIGHT(b,20) RIGHT(c,20)
56 1 ffffffffffffffffffff
57 2 gggggggggggggggggggg hhhhhhhhhhhhhhhhhhhh
58 set debug_sync='now SIGNAL go_upd';
59 # Connection default:
60 # reap UPDATE t3 SET c=REPEAT('f',3000) WHERE a=1;
61 # Connection con1:
62 SELECT a, RIGHT(b,20), RIGHT(c,20) FROM t3;
63 a RIGHT(b,20) RIGHT(c,20)
64 1 dddddddddddddddddddd ffffffffffffffffffff
65 2 gggggggggggggggggggg hhhhhhhhhhhhhhhhhhhh
66 CHECK TABLE t1,t2,t3;
67 Table Op Msg_type Msg_text
68 test.t1 check status OK
69 test.t2 check status OK
70 test.t3 check status OK
71 BEGIN;
72 INSERT INTO t2 VALUES (347);
73 SET DEBUG='+d,row_upd_extern_checkpoint';
74 SET DEBUG_SYNC='before_row_upd_extern SIGNAL have_latch WAIT_FOR crash';
75 UPDATE t3 SET c=REPEAT('i',3000) WHERE a=2;
76 SET DEBUG_SYNC='now WAIT_FOR have_latch';
77 SELECT info FROM information_schema.processlist
78 WHERE state = 'debug sync point: before_row_upd_extern';
79 info
80 UPDATE t3 SET c=REPEAT('i',3000) WHERE a=2
81 Warnings:
82 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
83 SET DEBUG='+d,crash_commit_before';
84 COMMIT;
85 ERROR HY000: Lost connection to MySQL server during query
86 ERROR HY000: Lost connection to MySQL server during query
87 CHECK TABLE t1,t2,t3;
88 Table Op Msg_type Msg_text
89 test.t1 check status OK
90 test.t2 check status OK
91 test.t3 check status OK
92 SELECT a, RIGHT(b,20), RIGHT(c,20) FROM t3;
93 a RIGHT(b,20) RIGHT(c,20)
94 1 dddddddddddddddddddd ffffffffffffffffffff
95 2 gggggggggggggggggggg hhhhhhhhhhhhhhhhhhhh
96 SELECT a FROM t3;
97 a
98 1
99 2
100 BEGIN;
101 INSERT INTO t2 VALUES (33101);
102 SET DEBUG='+d,row_upd_extern_checkpoint';
103 SET DEBUG_SYNC='after_row_upd_extern SIGNAL have_latch WAIT_FOR crash';
104 UPDATE t3 SET c=REPEAT('j',3000) WHERE a=2;
105 SET DEBUG_SYNC='now WAIT_FOR have_latch';
106 SELECT info FROM information_schema.processlist
107 WHERE state = 'debug sync point: after_row_upd_extern';
108 info
109 UPDATE t3 SET c=REPEAT('j',3000) WHERE a=2
110 Warnings:
111 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
112 SET DEBUG='+d,crash_commit_before';
113 COMMIT;
114 ERROR HY000: Lost connection to MySQL server during query
115 ERROR HY000: Lost connection to MySQL server during query
116 CHECK TABLE t1,t2,t3;
117 Table Op Msg_type Msg_text
118 test.t1 check status OK
119 test.t2 check status OK
120 test.t3 check status OK
121 SELECT a, RIGHT(b,20), RIGHT(c,20) FROM t3;
122 a RIGHT(b,20) RIGHT(c,20)
123 1 dddddddddddddddddddd ffffffffffffffffffff
124 2 gggggggggggggggggggg hhhhhhhhhhhhhhhhhhhh
125 SELECT a FROM t3;
126 a
127 1
128 2
129 SELECT * FROM t2;
130 a
131 DROP TABLE t1,t2,t3;
132 #
133 # Bug #29866408 SERVER CRASHES WHEN ADDING LONGTEXT COLUMN
134 #
135 CREATE TABLE t1 (
136 id int(11) COLLATE utf8mb4_unicode_ci NOT NULL,
137 data longtext COLLATE utf8mb4_unicode_ci NOT NULL,
138 PRIMARY KEY (id),
139 UNIQUE KEY unq_id (id)
140 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
141 Warnings:
142 Warning 1681 Integer display width is deprecated and will be removed in a future release.
143 INSERT INTO t1 VALUES (1,'');
144 SET @old_mode=@@sql_mode;
145 SET GLOBAL SQL_MODE="";
146 ALTER TABLE t1 ADD COLUMN d3 DATETIME NOT NULL;
147 ALTER TABLE t1 ADD COLUMN d2 DATETIME NOT NULL;
148 ALTER TABLE t1 ADD COLUMN d1 DATETIME NOT NULL;
149 SET GLOBAL SQL_MODE=@old_mode;
150 DROP TABLE t1;