Debian Codegraph @

mysql-test/suite/binlog/r/binlog_stm_user_variables.result

raw
1 RESET MASTER;
2 SET @positive= 18446744073709551615;
3 SET @negative= -9223372036854775808;
4 CREATE TABLE t1 (`tinyint` TINYINT,
5 `smallint` SMALLINT,
6 `mediumint` MEDIUMINT,
7 `integer` INTEGER,
8 `bigint` BIGINT,
9 `utinyint` TINYINT UNSIGNED,
10 `usmallint` SMALLINT UNSIGNED,
11 `umediumint` MEDIUMINT UNSIGNED,
12 `uinteger` INTEGER UNSIGNED,
13 `ubigint` BIGINT UNSIGNED,
14 `double` DOUBLE,
15 `float` FLOAT,
16 `real` REAL(30,2),
17 `decimal` DECIMAL(30,2)) ENGINE = MyISAM;
18 ### insert max unsigned
19 ### a) declarative
20 INSERT IGNORE INTO t1 VALUES (18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615,18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615);;
21 TRUNCATE t1;
22 ### b) user var
23 INSERT IGNORE INTO t1 VALUES (@positive,
24 @positive,
25 @positive,
26 @positive,
27 @positive,
28 @positive,
29 @positive,
30 @positive,
31 @positive,
32 @positive,
33 @positive,
34 @positive,
35 @positive,
36 @positive);
37 ## assertion: checks that User_var_log_event::pack_info
38 ## correctly displays the binlog content by taking into
39 ## account the unsigned_flag
40 include/show_binlog_events.inc
41 Log_name Pos Event_type Server_id End_log_pos Info
42 master-bin.000001 # Gtid # # GTID #-#-#
43 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (`tinyint` TINYINT,
44 `smallint` SMALLINT,
45 `mediumint` MEDIUMINT,
46 `integer` INTEGER,
47 `bigint` BIGINT,
48 `utinyint` TINYINT UNSIGNED,
49 `usmallint` SMALLINT UNSIGNED,
50 `umediumint` MEDIUMINT UNSIGNED,
51 `uinteger` INTEGER UNSIGNED,
52 `ubigint` BIGINT UNSIGNED,
53 `double` DOUBLE,
54 `float` FLOAT,
55 `real` REAL(30,2),
56 `decimal` DECIMAL(30,2)) ENGINE = MyISAM
57 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
58 master-bin.000001 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES (18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615,18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615)
59 master-bin.000001 # Query # # COMMIT
60 master-bin.000001 # Gtid # # GTID #-#-#
61 master-bin.000001 # Query # # use `test`; TRUNCATE t1
62 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
63 master-bin.000001 # User var # # @`positive`=18446744073709551615
64 master-bin.000001 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES (@positive,
65 @positive,
66 @positive,
67 @positive,
68 @positive,
69 @positive,
70 @positive,
71 @positive,
72 @positive,
73 @positive,
74 @positive,
75 @positive,
76 @positive,
77 @positive)
78 master-bin.000001 # Query # # COMMIT
79 ### insert min signed
80 ### a) declarative
81 INSERT IGNORE INTO t1 VALUES (-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808,-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808);;
82 TRUNCATE t1;
83 ### b) user var
84 INSERT IGNORE INTO t1 VALUES (@negative,
85 @negative,
86 @negative,
87 @negative,
88 @negative,
89 @negative,
90 @negative,
91 @negative,
92 @negative,
93 @negative,
94 @negative,
95 @negative,
96 @negative,
97 @negative);
98 ## assertion: checks that User_var_log_event::pack_info
99 ## correctly displays the binlog content by taking into
100 ## account the unsigned_flag
101 include/show_binlog_events.inc
102 Log_name Pos Event_type Server_id End_log_pos Info
103 master-bin.000001 # Gtid # # GTID #-#-#
104 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (`tinyint` TINYINT,
105 `smallint` SMALLINT,
106 `mediumint` MEDIUMINT,
107 `integer` INTEGER,
108 `bigint` BIGINT,
109 `utinyint` TINYINT UNSIGNED,
110 `usmallint` SMALLINT UNSIGNED,
111 `umediumint` MEDIUMINT UNSIGNED,
112 `uinteger` INTEGER UNSIGNED,
113 `ubigint` BIGINT UNSIGNED,
114 `double` DOUBLE,
115 `float` FLOAT,
116 `real` REAL(30,2),
117 `decimal` DECIMAL(30,2)) ENGINE = MyISAM
118 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
119 master-bin.000001 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES (18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615,18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615)
120 master-bin.000001 # Query # # COMMIT
121 master-bin.000001 # Gtid # # GTID #-#-#
122 master-bin.000001 # Query # # use `test`; TRUNCATE t1
123 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
124 master-bin.000001 # User var # # @`positive`=18446744073709551615
125 master-bin.000001 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES (@positive,
126 @positive,
127 @positive,
128 @positive,
129 @positive,
130 @positive,
131 @positive,
132 @positive,
133 @positive,
134 @positive,
135 @positive,
136 @positive,
137 @positive,
138 @positive)
139 master-bin.000001 # Query # # COMMIT
140 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
141 master-bin.000001 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES (-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808,-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808)
142 master-bin.000001 # Query # # COMMIT
143 master-bin.000001 # Gtid # # GTID #-#-#
144 master-bin.000001 # Query # # use `test`; TRUNCATE t1
145 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
146 master-bin.000001 # User var # # @`negative`=-9223372036854775808
147 master-bin.000001 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES (@negative,
148 @negative,
149 @negative,
150 @negative,
151 @negative,
152 @negative,
153 @negative,
154 @negative,
155 @negative,
156 @negative,
157 @negative,
158 @negative,
159 @negative,
160 @negative)
161 master-bin.000001 # Query # # COMMIT
162 DROP TABLE t1;