Debian Codegraph @

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

raw
1 FLUSH TABLES;
2 CREATE TABLE t1 (a INT PRIMARY KEY, b TEXT) ENGINE=InnoDB;
3 CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=InnoDB;
4 CREATE TABLE t3 (a INT PRIMARY KEY, b TEXT, c TEXT) ENGINE=InnoDB;
5 INSERT INTO t1 VALUES (1,REPEAT('a',30000)),(2,REPEAT('b',40000));
6 SET DEBUG_SYNC='before_row_upd_extern SIGNAL have_latch WAIT_FOR go1';
7 BEGIN;
8 UPDATE t1 SET a=a+2;
9 ROLLBACK;
10 BEGIN;
11 UPDATE t1 SET b=CONCAT(b,'foo');
12 connect con1,localhost,root,,;
13 SET DEBUG_SYNC='now WAIT_FOR have_latch';
14 SELECT a, RIGHT(b,20) FROM t1;
15 connect con2,localhost,root,,;
16 SET DEBUG_SYNC='now SIGNAL go1';
17 connection con1;
18 a RIGHT(b,20)
19 1 aaaaaaaaaaaaaaaaaaaa
20 2 bbbbbbbbbbbbbbbbbbbb
21 connection default;
22 SET DEBUG_DBUG='+d,row_ins_extern_checkpoint';
23 SET DEBUG_SYNC='before_row_ins_extern_latch SIGNAL rec_not_blob WAIT_FOR crash';
24 ROLLBACK;
25 BEGIN;
26 INSERT INTO t1 VALUES (3,REPEAT('c',50000));
27 connection con1;
28 SET DEBUG_SYNC='now WAIT_FOR rec_not_blob';
29 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
30 SELECT @@transaction_isolation;
31 @@transaction_isolation
32 READ-UNCOMMITTED
33 SELECT a, RIGHT(b,20) FROM t1;
34 a RIGHT(b,20)
35 1 aaaaaaaaaaaaaaaaaaaa
36 2 bbbbbbbbbbbbbbbbbbbb
37 SELECT a FROM t1;
38 a
39 1
40 2
41 3
42 BEGIN;
43 INSERT INTO t2 VALUES (42);
44 # restart
45 disconnect con1;
46 disconnect con2;
47 connection default;
48 ERROR HY000: Lost connection to server during query
49 CHECK TABLE t1;
50 Table Op Msg_type Msg_text
51 test.t1 check status OK
52 INSERT INTO t3 VALUES
53 (1,REPEAT('d',7000),REPEAT('e',100)),
54 (2,REPEAT('g',7000),REPEAT('h',100));
55 SET DEBUG_SYNC='blob_write_middle SIGNAL go_sel WAIT_FOR go_upd';
56 UPDATE t3 SET c=REPEAT('f',3000) WHERE a=1;
57 # Connection con1:
58 connect con1,localhost,root,,;
59 SET DEBUG_SYNC='now WAIT_FOR go_sel';
60 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
61 SELECT @@transaction_isolation;
62 @@transaction_isolation
63 READ-UNCOMMITTED
64 SELECT a, RIGHT(b,20), RIGHT(c,20) FROM t3;
65 a RIGHT(b,20) RIGHT(c,20)
66 2 gggggggggggggggggggg hhhhhhhhhhhhhhhhhhhh
67 set debug_sync='now SIGNAL go_upd';
68 # Connection default:
69 connection default;
70 # reap UPDATE t3 SET c=REPEAT('f',3000) WHERE a=1;
71 # Connection con1:
72 connection con1;
73 SELECT a, RIGHT(b,20), RIGHT(c,20) FROM t3;
74 a RIGHT(b,20) RIGHT(c,20)
75 1 dddddddddddddddddddd ffffffffffffffffffff
76 2 gggggggggggggggggggg hhhhhhhhhhhhhhhhhhhh
77 disconnect con1;
78 connection default;
79 CHECK TABLE t1,t2,t3;
80 Table Op Msg_type Msg_text
81 test.t1 check status OK
82 test.t2 check status OK
83 test.t3 check status OK
84 connect con2,localhost,root,,;
85 BEGIN;
86 INSERT INTO t2 VALUES (347);
87 connection default;
88 SET DEBUG_DBUG='+d,row_upd_extern_checkpoint';
89 SET DEBUG_SYNC='before_row_upd_extern SIGNAL have_latch WAIT_FOR crash';
90 UPDATE t3 SET c=REPEAT('i',3000) WHERE a=2;
91 connection con2;
92 SET DEBUG_SYNC='now WAIT_FOR have_latch';
93 SELECT info FROM information_schema.processlist
94 WHERE state = 'debug sync point: before_row_upd_extern';
95 info
96 UPDATE t3 SET c=REPEAT('i',3000) WHERE a=2
97 connect con3,localhost,root,,;
98 SET GLOBAL innodb_flush_log_at_trx_commit=1;
99 DELETE FROM t1;
100 ROLLBACK;
101 disconnect con3;
102 connection con2;
103 # restart
104 disconnect con2;
105 connection default;
106 ERROR HY000: Lost connection to server during query
107 CHECK TABLE t1,t2,t3;
108 Table Op Msg_type Msg_text
109 test.t1 check status OK
110 test.t2 check status OK
111 test.t3 check status OK
112 SELECT a, RIGHT(b,20), RIGHT(c,20) FROM t3;
113 a RIGHT(b,20) RIGHT(c,20)
114 1 dddddddddddddddddddd ffffffffffffffffffff
115 2 gggggggggggggggggggg hhhhhhhhhhhhhhhhhhhh
116 SELECT a FROM t3;
117 a
118 1
119 2
120 connect con2,localhost,root,,;
121 BEGIN;
122 INSERT INTO t2 VALUES (33101);
123 connection default;
124 SET DEBUG_DBUG='+d,row_upd_extern_checkpoint';
125 SET DEBUG_SYNC='after_row_upd_extern SIGNAL have_latch WAIT_FOR crash';
126 UPDATE t3 SET c=REPEAT('j',3000) WHERE a=2;
127 connection con2;
128 SET DEBUG_SYNC='now WAIT_FOR have_latch';
129 SELECT info FROM information_schema.processlist
130 WHERE state = 'debug sync point: after_row_upd_extern';
131 info
132 UPDATE t3 SET c=REPEAT('j',3000) WHERE a=2
133 # restart
134 disconnect con2;
135 connection default;
136 ERROR HY000: Lost connection to server during query
137 CHECK TABLE t1,t2,t3;
138 Table Op Msg_type Msg_text
139 test.t1 check status OK
140 test.t2 check status OK
141 test.t3 check status OK
142 SELECT a, RIGHT(b,20), RIGHT(c,20) FROM t3;
143 a RIGHT(b,20) RIGHT(c,20)
144 1 dddddddddddddddddddd ffffffffffffffffffff
145 2 gggggggggggggggggggg hhhhhhhhhhhhhhhhhhhh
146 SELECT a FROM t3;
147 a
148 1
149 2
150 SELECT * FROM t2;
151 a
152 DROP TABLE t1,t2,t3;
153 CREATE TABLE t1(f1 INT PRIMARY KEY, f2 TEXT)ENGINE=InnoDB
154 ROW_FORMAT=REDUNDANT;
155 SET @fill_amount = (@@innodb_page_size / 2 ) + 1 ;
156 INSERT INTO t1 VALUES(1, REPEAT(2, @fill_amount));
157 UPDATE t1 SET f1 = 2;
158 DROP TABLE t1;