Debian Codegraph @

mysql-test/suite/rpl/r/rpl_stm_user_variables.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 SET @positive= 18446744073709551615;
7 SET @negative= -9223372036854775808;
8 CREATE TABLE t1 (`tinyint` TINYINT,
9 `smallint` SMALLINT,
10 `mediumint` MEDIUMINT,
11 `integer` INTEGER,
12 `bigint` BIGINT,
13 `utinyint` TINYINT UNSIGNED,
14 `usmallint` SMALLINT UNSIGNED,
15 `umediumint` MEDIUMINT UNSIGNED,
16 `uinteger` INTEGER UNSIGNED,
17 `ubigint` BIGINT UNSIGNED,
18 `double` DOUBLE,
19 `float` FLOAT,
20 `real` REAL(30,2),
21 `decimal` DECIMAL(30,2)) ENGINE = MyISAM;
22 Warnings:
23 Warning 1681 Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
24 ### insert max unsigned
25 ### a) declarative
26 INSERT IGNORE INTO t1 VALUES (18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615,18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615, 18446744073709551615);;
27 #########################################
28 #### [ on master ]
29 SELECT * FROM t1;
30 tinyint 127
31 smallint 32767
32 mediumint 8388607
33 integer 2147483647
34 bigint 9223372036854775807
35 utinyint 255
36 usmallint 65535
37 umediumint 16777215
38 uinteger 4294967295
39 ubigint 18446744073709551615
40 double 1.8446744073709552e19
41 float 1.84467e19
42 real 18446744073709552000.00
43 decimal 18446744073709551615.00
44 include/sync_slave_sql_with_master.inc
45 #### [ on slave ]
46 SELECT * FROM t1;
47 tinyint 127
48 smallint 32767
49 mediumint 8388607
50 integer 2147483647
51 bigint 9223372036854775807
52 utinyint 255
53 usmallint 65535
54 umediumint 16777215
55 uinteger 4294967295
56 ubigint 18446744073709551615
57 double 1.8446744073709552e19
58 float 1.84467e19
59 real 18446744073709552000.00
60 decimal 18446744073709551615.00
61 #########################################
62 ## assertion: master and slave tables are in sync
63 include/diff_tables.inc [master:t1,slave:t1]
64 TRUNCATE t1;
65 ### b) user var
66 INSERT IGNORE INTO t1 VALUES (@positive,
67 @positive,
68 @positive,
69 @positive,
70 @positive,
71 @positive,
72 @positive,
73 @positive,
74 @positive,
75 @positive,
76 @positive,
77 @positive,
78 @positive,
79 @positive);
80 #########################################
81 #### [ on master ]
82 SELECT * FROM t1;
83 tinyint 127
84 smallint 32767
85 mediumint 8388607
86 integer 2147483647
87 bigint 9223372036854775807
88 utinyint 255
89 usmallint 65535
90 umediumint 16777215
91 uinteger 4294967295
92 ubigint 18446744073709551615
93 double 1.8446744073709552e19
94 float 1.84467e19
95 real 18446744073709552000.00
96 decimal 18446744073709551615.00
97 include/sync_slave_sql_with_master.inc
98 #### [ on slave ]
99 SELECT * FROM t1;
100 tinyint 127
101 smallint 32767
102 mediumint 8388607
103 integer 2147483647
104 bigint 9223372036854775807
105 utinyint 255
106 usmallint 65535
107 umediumint 16777215
108 uinteger 4294967295
109 ubigint 18446744073709551615
110 double 1.8446744073709552e19
111 float 1.84467e19
112 real 18446744073709552000.00
113 decimal 18446744073709551615.00
114 #########################################
115 ## assertion: master and slave tables are in sync
116 include/diff_tables.inc [master:t1,slave:t1]
117 TRUNCATE t1;
118 ### insert min signed
119 ### a) declarative
120 INSERT IGNORE INTO t1 VALUES (-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808,-9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808, -9223372036854775808);;
121 #########################################
122 #### [ on master ]
123 SELECT * FROM t1;
124 tinyint -128
125 smallint -32768
126 mediumint -8388608
127 integer -2147483648
128 bigint -9223372036854775808
129 utinyint 0
130 usmallint 0
131 umediumint 0
132 uinteger 0
133 ubigint 0
134 double -9.223372036854776e18
135 float -9.22337e18
136 real -9223372036854776000.00
137 decimal -9223372036854775808.00
138 include/sync_slave_sql_with_master.inc
139 #### [ on slave ]
140 SELECT * FROM t1;
141 tinyint -128
142 smallint -32768
143 mediumint -8388608
144 integer -2147483648
145 bigint -9223372036854775808
146 utinyint 0
147 usmallint 0
148 umediumint 0
149 uinteger 0
150 ubigint 0
151 double -9.223372036854776e18
152 float -9.22337e18
153 real -9223372036854776000.00
154 decimal -9223372036854775808.00
155 #########################################
156 ## assertion: master and slave tables are in sync
157 include/diff_tables.inc [master:t1,slave:t1]
158 TRUNCATE t1;
159 ### b) user var
160 INSERT IGNORE INTO t1 VALUES (@negative,
161 @negative,
162 @negative,
163 @negative,
164 @negative,
165 @negative,
166 @negative,
167 @negative,
168 @negative,
169 @negative,
170 @negative,
171 @negative,
172 @negative,
173 @negative);
174 #########################################
175 #### [ on master ]
176 SELECT * FROM t1;
177 tinyint -128
178 smallint -32768
179 mediumint -8388608
180 integer -2147483648
181 bigint -9223372036854775808
182 utinyint 0
183 usmallint 0
184 umediumint 0
185 uinteger 0
186 ubigint 0
187 double -9.223372036854776e18
188 float -9.22337e18
189 real -9223372036854776000.00
190 decimal -9223372036854775808.00
191 include/sync_slave_sql_with_master.inc
192 #### [ on slave ]
193 SELECT * FROM t1;
194 tinyint -128
195 smallint -32768
196 mediumint -8388608
197 integer -2147483648
198 bigint -9223372036854775808
199 utinyint 0
200 usmallint 0
201 umediumint 0
202 uinteger 0
203 ubigint 0
204 double -9.223372036854776e18
205 float -9.22337e18
206 real -9223372036854776000.00
207 decimal -9223372036854775808.00
208 #########################################
209 ## assertion: master and slave tables are in sync
210 include/diff_tables.inc [master:t1,slave:t1]
211 TRUNCATE t1;
212 ## check: contents of both tables master's and slave's
213 DROP TABLE t1;
214 include/sync_slave_sql_with_master.inc
215 include/rpl_reset.inc
216 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
217 CREATE TABLE t1 ( c INT, PRIMARY KEY (c)) Engine=MyISAM;
218 CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW SET @aux = -1 ;
219 SET @aux = 10294947273192243200;
220 SET @aux1= @aux;
221 INSERT INTO t1 VALUES (@aux) , (@aux1);
222 ERROR 23000: Duplicate entry '2147483647' for key 't1.PRIMARY'
223 include/sync_slave_sql_with_master.inc
224 ## assertion: master and slave tables are in sync
225 include/diff_tables.inc [master:t1,slave:t1]
226 DROP TRIGGER tr1;
227 DROP TABLE t1;
228 SET sql_mode = default;
229 include/sync_slave_sql_with_master.inc
230 include/rpl_end.inc