2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
8
create table t1(n char(30));
9
set @i1:=12345678901234, @i2:=-12345678901234, @i3:=0, @i4:=-1;
10
set @s1:='This is a test', @r1:=12.5, @r2:=-12.5;
12
set @s2:='', @s3:='abc\'def', @s4:= 'abc\\def', @s5:= 'abc''def';
13
insert into t1 values (@i1), (@i2), (@i3), (@i4);
14
insert into t1 values (@r1), (@r2);
15
insert into t1 values (@s1), (@s2), (@s3), (@s4), (@s5);
16
insert into t1 values (@n1);
17
insert into t1 values (@n2);
18
insert into t1 values (@a:=0), (@a:=@a+1), (@a:=@a+1);
19
insert into t1 values (@a+(@b:=@a+1));
21
insert t1 values (@q), (@q:=concat(@q, 'n1')), (@q:=concat(@q, 'n2'));
23
insert into t1 values (@a),(@a);
24
insert into t1 values (@a),(@a),(@a*5);
79
show binlog events from 98;
80
Log_name Pos Event_type Server_id End_log_pos Info
81
slave-bin.000001 # Query 1 # use `test`; create table t1(n char(30))
82
slave-bin.000001 # User var 2 # @`i1`=12345678901234
83
slave-bin.000001 # User var 2 # @`i2`=-12345678901234
84
slave-bin.000001 # User var 2 # @`i3`=0
85
slave-bin.000001 # User var 2 # @`i4`=-1
86
slave-bin.000001 # Query 1 # use `test`; insert into t1 values (@i1), (@i2), (@i3), (@i4)
87
slave-bin.000001 # User var 2 # @`r1`=12.5
88
slave-bin.000001 # User var 2 # @`r2`=-12.5
89
slave-bin.000001 # Query 1 # use `test`; insert into t1 values (@r1), (@r2)
90
slave-bin.000001 # User var 2 # @`s1`=_latin1 0x5468697320697320612074657374 COLLATE latin1_swedish_ci
91
slave-bin.000001 # User var 2 # @`s2`=_latin1 "" COLLATE latin1_swedish_ci
92
slave-bin.000001 # User var 2 # @`s3`=_latin1 0x61626327646566 COLLATE latin1_swedish_ci
93
slave-bin.000001 # User var 2 # @`s4`=_latin1 0x6162635C646566 COLLATE latin1_swedish_ci
94
slave-bin.000001 # User var 2 # @`s5`=_latin1 0x61626327646566 COLLATE latin1_swedish_ci
95
slave-bin.000001 # Query 1 # use `test`; insert into t1 values (@s1), (@s2), (@s3), (@s4), (@s5)
96
slave-bin.000001 # User var 2 # @`n1`=NULL
97
slave-bin.000001 # Query 1 # use `test`; insert into t1 values (@n1)
98
slave-bin.000001 # User var 2 # @`n2`=NULL
99
slave-bin.000001 # Query 1 # use `test`; insert into t1 values (@n2)
100
slave-bin.000001 # Query 1 # use `test`; insert into t1 values (@a:=0), (@a:=@a+1), (@a:=@a+1)
101
slave-bin.000001 # User var 2 # @`a`=2
102
slave-bin.000001 # Query 1 # use `test`; insert into t1 values (@a+(@b:=@a+1))
103
slave-bin.000001 # User var 2 # @`q`=_latin1 0x616263 COLLATE latin1_swedish_ci
104
slave-bin.000001 # Query 1 # use `test`; insert t1 values (@q), (@q:=concat(@q, 'n1')), (@q:=concat(@q, 'n2'))
105
slave-bin.000001 # User var 2 # @`a`=5
106
slave-bin.000001 # Query 1 # use `test`; insert into t1 values (@a),(@a)
107
slave-bin.000001 # User var 2 # @`a`=NULL
108
slave-bin.000001 # Query 1 # use `test`; insert into t1 values (@a),(@a),(@a*5)
109
insert into t1 select * FROM (select @var1 union select @var2) AS t2;