Debian Codegraph @

mysql-test/suite/ndb_binlog/r/ndb_binlog_blob_alter.result

raw
1 Create table
2 NoLogging to avoid redo overload issues + increase write rate
3 create table t1 (a int primary key, y int, b text, c text, d text, e int) engine=ndb comment='NDB_TABLE=NOLOGGING=1';
4 create procedure blob_work()
5 begin
6 set @x = 0;
7 set @y = 0;
8 repeat
9 update t1 set y=@y+ 0, d=repeat('BJC', 1000), b=repeat('TSG', 2000), c= repeat('EIN', 3000), e=e+1 LIMIT 50;
10 update t1 set y=@y+ 1, c=repeat('BJC', 1000), d=repeat('TSG', 2000), b= repeat('EIN', 3000), e=e+1 LIMIT 50;
11 update t1 set y=@y+ 2, b=repeat('BJC', 1000), c=repeat('TSG', 2000), d= repeat('EIN', 3000), e=e+1 LIMIT 50;
12 update t1 set y=@y+ 3, d=repeat('BJC', 1000), b=repeat('TSG', 2000), c= repeat('EIN', 3000), e=e+1 LIMIT 50;
13 update t1 set y=@y+ 4, c=repeat('BJC', 1000), d=repeat('TSG', 2000), b= repeat('EIN', 3000), e=e+1 LIMIT 50;
14 update t1 set y=@y+ 5, b=repeat('BJC', 1000), c=repeat('TSG', 2000), d= repeat('EIN', 3000), e=e+1 LIMIT 50;
15 update t1 set y=@y+ 6, d=repeat('BJC', 1000), b=repeat('TSG', 2000), c= repeat('EIN', 3000), e=e+1 LIMIT 50;
16 update t1 set y=@y+ 7, c=repeat('BJC', 1000), d=repeat('TSG', 2000), b= repeat('EIN', 3000), e=e+1 LIMIT 50;
17 update t1 set y=@y+ 8, b=repeat('BJC', 1000), c=repeat('TSG', 2000), d= repeat('EIN', 3000), e=e+1 LIMIT 50;
18 update t1 set y=@y+ 9, d=repeat('BJC', 1000), b=repeat('TSG', 2000), c= repeat('EIN', 3000), e=e+1 LIMIT 50;
19 update t1 set y=@y+10, c=repeat('BJC', 1000), d=repeat('TSG', 2000), b= repeat('EIN', 3000), e=e+1 LIMIT 50;
20 update t1 set y=@y+11, b=repeat('BJC', 1000), c=repeat('TSG', 2000), d= repeat('EIN', 3000), e=e+1 LIMIT 50;
21 update t1 set y=@y+12, d=repeat('BJC', 1000), b=repeat('TSG', 2000), c= repeat('EIN', 3000), e=e+1 LIMIT 50;
22 update t1 set y=@y+13, c=repeat('BJC', 1000), d=repeat('TSG', 2000), b= repeat('EIN', 3000), e=e+1 LIMIT 50;
23 update t1 set y=@y+14, b=repeat('BJC', 1000), c=repeat('TSG', 2000), d= repeat('EIN', 3000), e=e+1 LIMIT 50;
24 set @y = @y+15;
25 select count(1) into @x from t1 where a=10000;
26 until @x > 0
27 end repeat;
28 end%
29 Starting blob work on server 1
30 call blob_work();
31 Starting adding columns to t1 on server 2
32 alter table t1 add column i100 int column_format dynamic;
33 alter table t1 add column i99 int column_format dynamic;
34 alter table t1 add column i98 int column_format dynamic;
35 alter table t1 add column i97 int column_format dynamic;
36 alter table t1 add column i96 int column_format dynamic;
37 alter table t1 add column i95 int column_format dynamic;
38 alter table t1 add column i94 int column_format dynamic;
39 alter table t1 add column i93 int column_format dynamic;
40 alter table t1 add column i92 int column_format dynamic;
41 alter table t1 add column i91 int column_format dynamic;
42 alter table t1 add column i90 int column_format dynamic;
43 alter table t1 add column i89 int column_format dynamic;
44 alter table t1 add column i88 int column_format dynamic;
45 alter table t1 add column i87 int column_format dynamic;
46 alter table t1 add column i86 int column_format dynamic;
47 alter table t1 add column i85 int column_format dynamic;
48 alter table t1 add column i84 int column_format dynamic;
49 alter table t1 add column i83 int column_format dynamic;
50 alter table t1 add column i82 int column_format dynamic;
51 alter table t1 add column i81 int column_format dynamic;
52 alter table t1 add column i80 int column_format dynamic;
53 alter table t1 add column i79 int column_format dynamic;
54 alter table t1 add column i78 int column_format dynamic;
55 alter table t1 add column i77 int column_format dynamic;
56 alter table t1 add column i76 int column_format dynamic;
57 alter table t1 add column i75 int column_format dynamic;
58 alter table t1 add column i74 int column_format dynamic;
59 alter table t1 add column i73 int column_format dynamic;
60 alter table t1 add column i72 int column_format dynamic;
61 alter table t1 add column i71 int column_format dynamic;
62 alter table t1 add column i70 int column_format dynamic;
63 alter table t1 add column i69 int column_format dynamic;
64 alter table t1 add column i68 int column_format dynamic;
65 alter table t1 add column i67 int column_format dynamic;
66 alter table t1 add column i66 int column_format dynamic;
67 alter table t1 add column i65 int column_format dynamic;
68 alter table t1 add column i64 int column_format dynamic;
69 alter table t1 add column i63 int column_format dynamic;
70 alter table t1 add column i62 int column_format dynamic;
71 alter table t1 add column i61 int column_format dynamic;
72 alter table t1 add column i60 int column_format dynamic;
73 alter table t1 add column i59 int column_format dynamic;
74 alter table t1 add column i58 int column_format dynamic;
75 alter table t1 add column i57 int column_format dynamic;
76 alter table t1 add column i56 int column_format dynamic;
77 alter table t1 add column i55 int column_format dynamic;
78 alter table t1 add column i54 int column_format dynamic;
79 alter table t1 add column i53 int column_format dynamic;
80 alter table t1 add column i52 int column_format dynamic;
81 alter table t1 add column i51 int column_format dynamic;
82 alter table t1 add column i50 int column_format dynamic;
83 alter table t1 add column i49 int column_format dynamic;
84 alter table t1 add column i48 int column_format dynamic;
85 alter table t1 add column i47 int column_format dynamic;
86 alter table t1 add column i46 int column_format dynamic;
87 alter table t1 add column i45 int column_format dynamic;
88 alter table t1 add column i44 int column_format dynamic;
89 alter table t1 add column i43 int column_format dynamic;
90 alter table t1 add column i42 int column_format dynamic;
91 alter table t1 add column i41 int column_format dynamic;
92 alter table t1 add column i40 int column_format dynamic;
93 alter table t1 add column i39 int column_format dynamic;
94 alter table t1 add column i38 int column_format dynamic;
95 alter table t1 add column i37 int column_format dynamic;
96 alter table t1 add column i36 int column_format dynamic;
97 alter table t1 add column i35 int column_format dynamic;
98 alter table t1 add column i34 int column_format dynamic;
99 alter table t1 add column i33 int column_format dynamic;
100 alter table t1 add column i32 int column_format dynamic;
101 alter table t1 add column i31 int column_format dynamic;
102 alter table t1 add column i30 int column_format dynamic;
103 alter table t1 add column i29 int column_format dynamic;
104 alter table t1 add column i28 int column_format dynamic;
105 alter table t1 add column i27 int column_format dynamic;
106 alter table t1 add column i26 int column_format dynamic;
107 alter table t1 add column i25 int column_format dynamic;
108 alter table t1 add column i24 int column_format dynamic;
109 alter table t1 add column i23 int column_format dynamic;
110 alter table t1 add column i22 int column_format dynamic;
111 alter table t1 add column i21 int column_format dynamic;
112 alter table t1 add column i20 int column_format dynamic;
113 alter table t1 add column i19 int column_format dynamic;
114 alter table t1 add column i18 int column_format dynamic;
115 alter table t1 add column i17 int column_format dynamic;
116 alter table t1 add column i16 int column_format dynamic;
117 alter table t1 add column i15 int column_format dynamic;
118 alter table t1 add column i14 int column_format dynamic;
119 alter table t1 add column i13 int column_format dynamic;
120 alter table t1 add column i12 int column_format dynamic;
121 alter table t1 add column i11 int column_format dynamic;
122 alter table t1 add column i10 int column_format dynamic;
123 alter table t1 add column i9 int column_format dynamic;
124 alter table t1 add column i8 int column_format dynamic;
125 alter table t1 add column i7 int column_format dynamic;
126 alter table t1 add column i6 int column_format dynamic;
127 alter table t1 add column i5 int column_format dynamic;
128 alter table t1 add column i4 int column_format dynamic;
129 alter table t1 add column i3 int column_format dynamic;
130 alter table t1 add column i2 int column_format dynamic;
131 alter table t1 add column i1 int column_format dynamic;
132 100 columns added
133 Finish test
134 insert into t1 (a) values (10000);
135 drop procedure blob_work;
136 drop table test.t1;