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 Warnings:
19 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
20 ### insert max unsigned
21 ### a) declarative
22 INSERT IGNORE INTO t1 VALUES (18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615,18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615);;
23 TRUNCATE t1;
24 ### b) user var
25 INSERT IGNORE INTO t1 VALUES (@positive,
26 @positive,
27 @positive,
28 @positive,
29 @positive,
30 @positive,
31 @positive,
32 @positive,
33 @positive,
34 @positive,
35 @positive,
36 @positive,
37 @positive,
38 @positive);
39 ## assertion: checks that User_var_log_event::pack_info
40 ## correctly displays the binlog content by taking into
41 ## account the unsigned_flag
42 include/show_binlog_events.inc
43 Log_name Pos Event_type Server_id End_log_pos Info
44 binlog.000001 # Query # # use `test`; CREATE TABLE t1 (`tinyint` TINYINT,
45 `smallint` SMALLINT,
46 `mediumint` MEDIUMINT,
47 `integer` INTEGER,
48 `bigint` BIGINT,
49 `utinyint` TINYINT UNSIGNED,
50 `usmallint` SMALLINT UNSIGNED,
51 `umediumint` MEDIUMINT UNSIGNED,
52 `uinteger` INTEGER UNSIGNED,
53 `ubigint` BIGINT UNSIGNED,
54 `double` DOUBLE,
55 `float` FLOAT,
56 `real` REAL(30,2),
57 `decimal` DECIMAL(30,2)) ENGINE = MyISAM
58 binlog.000001 # Query # # BEGIN
59 binlog.000001 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES (18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615,18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615)
60 binlog.000001 # Query # # COMMIT
61 binlog.000001 # Query # # use `test`; TRUNCATE t1
62 binlog.000001 # Query # # BEGIN
63 binlog.000001 # User var # # @`positive`=18446744073709551615
64 binlog.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 binlog.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 binlog.000001 # Query # # use `test`; CREATE TABLE t1 (`tinyint` TINYINT,
104 `smallint` SMALLINT,
105 `mediumint` MEDIUMINT,
106 `integer` INTEGER,
107 `bigint` BIGINT,
108 `utinyint` TINYINT UNSIGNED,
109 `usmallint` SMALLINT UNSIGNED,
110 `umediumint` MEDIUMINT UNSIGNED,
111 `uinteger` INTEGER UNSIGNED,
112 `ubigint` BIGINT UNSIGNED,
113 `double` DOUBLE,
114 `float` FLOAT,
115 `real` REAL(30,2),
116 `decimal` DECIMAL(30,2)) ENGINE = MyISAM
117 binlog.000001 # Query # # BEGIN
118 binlog.000001 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES (18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615,18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615)
119 binlog.000001 # Query # # COMMIT
120 binlog.000001 # Query # # use `test`; TRUNCATE t1
121 binlog.000001 # Query # # BEGIN
122 binlog.000001 # User var # # @`positive`=18446744073709551615
123 binlog.000001 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES (@positive,
124 @positive,
125 @positive,
126 @positive,
127 @positive,
128 @positive,
129 @positive,
130 @positive,
131 @positive,
132 @positive,
133 @positive,
134 @positive,
135 @positive,
136 @positive)
137 binlog.000001 # Query # # COMMIT
138 binlog.000001 # Query # # BEGIN
139 binlog.000001 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES (-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808,-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808)
140 binlog.000001 # Query # # COMMIT
141 binlog.000001 # Query # # use `test`; TRUNCATE t1
142 binlog.000001 # Query # # BEGIN
143 binlog.000001 # User var # # @`negative`=-9223372036854775808
144 binlog.000001 # Query # # use `test`; INSERT IGNORE INTO t1 VALUES (@negative,
145 @negative,
146 @negative,
147 @negative,
148 @negative,
149 @negative,
150 @negative,
151 @negative,
152 @negative,
153 @negative,
154 @negative,
155 @negative,
156 @negative,
157 @negative)
158 binlog.000001 # Query # # COMMIT
159 DROP TABLE t1;