Debian Codegraph @

mysql-test/suite/rpl/r/rpl_window_functions.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 # Create table with columns of different data types and insert values
7 CREATE TABLE t1 (pk INT PRIMARY KEY,a DECIMAL(5,2),
8 b DOUBLE, c CHAR(10), d VARCHAR(20),
9 e DATE, f DATETIME, g TEXT, h BLOB, i VARBINARY(32));
10 INSERT INTO t1 VALUES
11 (1, 258, 6.8, 'Orange', 'Australia', '2002-02-20', '2011-07-29 02:43:24', 'Cookley', 'FgaBAi419MbgSXyFgaBAi4QYYtKp4EotEr6nHrFyw', x'24c38d4ac1e8def7c9beff99d2ef7bd0'),
12 (2, null, 2, 'Blue', 'Australia', '2004-07-17', '2010-06-04 21:51:57', 'Temp', '1cNnegQruhm9r6M7s96Lt8t2vDP5LLoz5', x'5fb4efd5f7e90783a792c6134ceb539f'),
13 (3, 72, 44.44, 'Blue', 'Madagascar', '1999-09-09', '2006-08-11 06:55:50', 'Bigtax', '199utjJtezqMHCewY', x'f9e4f8c6d7b5657b0854ceb1d628c9e7'),
14 (4, 9.2, 253, 'Green', 'Russia', '2004-09-16', '1996-10-22 11:59:17', 'Stim', '1JmpHmWbpyBNBJavMBt7NS48UEoWcJ7GSvJavMas', x'018f672ec2ab8c9bdf8160f79b7bf283'),
15 (5, 6, 44.44, 'Crimson', 'Netherlands', '2003-01-27', '2017-01-02 01:43:16', 'Bytecard', '1FZaNCRe6fzyFiBVyqwfg72eHvo3hZXQXFasasf', x'64ed41f90735e3ab48513ab920d1c6d7'),
16 (6, 70, 83932, 'Indigo', 'India', '2011-08-09', '2008-08-12 13:18:47', 'Alpha', '1Phng2CeXWwmbmdY9qwdqwdnTqBv6ecWgZBj3BKs', x'71048e95216358a9d95e1ed946a457ad'),
17 (7, 96, 6, 'Khaki', 'Luxembourg', '2009-10-22', '1997-11-30 15:00:16', 'Zontrax', '1Ph2ZUtAVskwebMnyKLRG5GasfasfG4RkdTQujTc', x'88b67753fb0c181d1f7f21e31c3c92c9'),
18 (8, 8.43, 2, 'Pink', 'China', '2005-06-15', '1998-11-02 17:47:53', 'Gembucket', '14BbxEvaUK7nyCzXc9YvkxQasfdewefwefTiZrnVHVFj1', x'e7f08241ac2573e39be9bdc4c8f42a44'),
19 (9, 221, -8.67, 'Magenta', 'Australia', '2010-09-20', '2007-08-27 14:06:53', 'Y-find', '138GWMWSZTqkkm8eQk3sdfsdfsdJDpv72i6cFuyemc', x'583b4cb865f1f2644bf1420595a08c53'),
20 (10, 430, 1.23456, 'Turquoise', 'Philippines', '2002-08-02', '2000-02-19 02:49:17', 'Tin', '1CPkZjahzzRgoqz4W1NfmHsdfsdfsdf5vueJ3irb7Ae', x'7273d3dc246ecfe4bdc7c8155d1ee6b7'),
21 (11, 80, 6.8, 'Orange', 'Australia', '2002-02-20', '2011-07-29 02:43:24', 'Cookley', '19MbgSXyFgaBAi4sdfsdfQYYtKp4EotEr6nHrFyw', x'a17d1e699322177dfa7c415bb35f22a2'),
22 (12, 95 , 2, 'Blue', 'Australia', '2004-07-17', '2010-06-04 21:51:57', 'Temp', '1cNnegQr1234234uhm9r6M7s96Lt8t2vDP5LLoz5', x'435f41a9060f01f0669942eeb4ed2e80'),
23 (13, 72, 69179, 'Blue', 'Madagascar', '1999-09-09', '2006-08-11 06:55:50', 'Bigtax', 'nmklaw9utjJtezqMHCewR9YpKtm3LaXmt5h4PY', x'92d3b9ee039b388673e575c7f269ce60'),
24 (14, 6, 2531, 'Turquoise', 'Russia', '2004-09-16', '1996-10-22 11:59:17', 'Stim', 'avMBt7NasdasdsadS48UEoWcJ7GSv', x'f0688d9f99b6c80ec459bf9e4a79f411'),
25 (15, 9.2, 44, 'Indigo', 'Netherlands', '2003-01-27', '2017-01-02 01:43:16', 'Bytecard', '1asdfRe6fzyFiBVyqwfg72eHvo3hZXQXF', x'3d643793f96df74f4f680557eebf5326'),
26 (16, 72, 832, 'Green', 'India', '2011-08-09', '2008-08-12 13:18:47', 'Alpha', 'XWwmbmdY9nTqBv6ecWgZBj3BKs', x'fd7d92a8fe576067319ddd0fe44ddb44'),
27 (17, 70, 1.23456, 'Khaki', 'Luxembourg', '2009-10-22', '1997-11-30 15:00:16', 'Zontrax', '1Ph2ZUtAVskwebMnyKwEFWEFLRG5GG4RkdTQujTc', x'4063e204f4ac3578c71c1f33a7968a53'),
28 (18, 96, 2, 'Pink', 'China', '2005-06-15', '1998-11-02 17:47:53', 'Gembucket', '14BbxEvaUK7nyCzXcewaf9YvkxQTiZrnVHVFj1', x'7c146d3cc41ad9a48be5864d3d05e6d0'),
29 (19, 21, -8.67, 'Magenta', 'Australia', '2010-09-20', '2007-08-27 14:06:53', 'Y-find', '138GWMWSZTqkkm8eQk3JaweffwDpv72i6cFuyemc', x'05534c032b05ad0527a6768d45d36568'),
30 (20, 8.43, 253, 'Crimson', 'Philippines', '2002-08-02', '2000-02-19 02:49:17', 'Tin', '1CPkZjahzzRgoqz4W1NfmH5vueJ3irb7Ae', x'e7f7807e521c9f9a2276b438cc0ca203');
31 # INSERT ... SELECT ... using basic non-aggregate window functions
32 CREATE TABLE t2 (
33 c1 int unsigned NOT NULL DEFAULT '0',
34 c2 int unsigned NOT NULL DEFAULT '0',
35 c3 int unsigned NOT NULL DEFAULT '0',
36 c4 int unsigned DEFAULT NULL,
37 c5 double NOT NULL DEFAULT '0',
38 c6 double NOT NULL DEFAULT '0'
39 );
40 INSERT INTO t2 SELECT
41 ROW_NUMBER() OVER w1 c1,
42 RANK() OVER w1 c2,
43 DENSE_RANK() OVER w1 c3,
44 NTILE(3) OVER w1 c4,
45 PERCENT_RANK() OVER w1 c5,
46 CUME_DIST() OVER w1 c6
47 FROM t1 WINDOW w1 AS (PARTITION BY c ORDER BY f);
48 INSERT INTO t2 SELECT
49 ROW_NUMBER() OVER (PARTITION BY b) c1,
50 RANK() OVER (PARTITION BY a ORDER BY e) c2,
51 DENSE_RANK() OVER (PARTITION BY a ORDER BY i) c3,
52 NTILE(3) OVER (ORDER BY b) c4,
53 PERCENT_RANK() OVER (ORDER BY a,b,c,d) c5,
54 CUME_DIST() OVER (ORDER BY e,f,g,h,i) c6
55 FROM t1;
56 # INSERT ... SELECT with window functions having frame specification
57 CREATE TABLE t3a (
58 c1 decimal(27,2) DEFAULT NULL,
59 c2 double DEFAULT NULL,
60 c3 bigint(21) NOT NULL DEFAULT '0',
61 c4 int DEFAULT NULL,
62 c5 int DEFAULT NULL,
63 c6 varbinary(32),
64 c7 date DEFAULT NULL,
65 c8 datetime DEFAULT NULL,
66 c9 double DEFAULT NULL,
67 c10 double DEFAULT NULL,
68 c11 double DEFAULT NULL,
69 c12 double DEFAULT NULL,
70 c13 json,
71 c14 json
72 );
73 Warnings:
74 Warning 1681 Integer display width is deprecated and will be removed in a future release.
75 INSERT INTO t3a SELECT
76 SUM(a) OVER (ROWS UNBOUNDED PRECEDING) c1,
77 AVG(b) OVER (ORDER BY pk ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING) c2a,
78 COUNT(*) OVER (PARTITION BY d ORDER BY pk ROWS BETWEEN CURRENT ROW AND 2 FOLLOWING) c3,
79 BIT_AND(pk) OVER (PARTITION BY d ORDER BY pk ROWS BETWEEN 2 PRECEDING AND UNBOUNDED FOLLOWING) c4,
80 BIT_OR(a) OVER (PARTITION BY d ORDER BY e ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c5,
81 BIT_XOR(i) OVER (PARTITION BY c) c6,
82 MIN(e) OVER (ORDER BY e ROWS BETWEEN 2 PRECEDING AND UNBOUNDED FOLLOWING) c7,
83 MAX(f) OVER (ORDER BY f ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING) c8,
84 STDDEV_SAMP(a) OVER (ORDER BY pk ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c9,
85 VAR_SAMP(a) OVER (ORDER BY pk ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c10,
86 STDDEV_POP(b) OVER () c11,
87 VAR_POP(a) OVER () c12,
88 JSON_ARRAYAGG(e) OVER (PARTITION BY d ORDER BY pk ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c13,
89 JSON_OBJECTAGG(pk, a) OVER (ORDER BY a ROWS BETWEEN CURRENT ROW AND 4 FOLLOWING) c14
90 FROM t1;
91 INSERT INTO t3a SELECT
92 SUM(a) OVER (RANGE UNBOUNDED PRECEDING) c1,
93 AVG(b) OVER (ORDER BY pk RANGE BETWEEN 2 PRECEDING AND 2 FOLLOWING) c2a,
94 COUNT(*) OVER (PARTITION BY d ORDER BY pk RANGE BETWEEN CURRENT ROW AND 2 FOLLOWING) c3,
95 BIT_AND(pk) OVER (PARTITION BY d ORDER BY pk RANGE BETWEEN 2 PRECEDING AND UNBOUNDED FOLLOWING) c4,
96 BIT_OR(a) OVER (PARTITION BY d ORDER BY e RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c5,
97 BIT_XOR(i) OVER (PARTITION BY c) c6,
98 MIN(e) OVER (ORDER BY e RANGE INTERVAL 5 YEAR PRECEDING) c7,
99 MAX(f) OVER (ORDER BY f RANGE BETWEEN CURRENT ROW AND INTERVAL 5 YEAR FOLLOWING) c8,
100 STDDEV_SAMP(a) OVER (ORDER BY pk RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c9,
101 VAR_SAMP(a) OVER (ORDER BY pk RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c10,
102 STDDEV_POP(b) OVER () c11,
103 VAR_POP(a) OVER () c12,
104 JSON_ARRAYAGG(b) OVER (ORDER BY f ROWS BETWEEN CURRENT ROW AND 5 FOLLOWING) c13,
105 JSON_OBJECTAGG(b, e) OVER (PARTITION BY d ORDER BY e ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c14
106 FROM t1;
107 SET @master_save_windowing_use_high_precision= (SELECT @@windowing_use_high_precision);
108 SET GLOBAL windowing_use_high_precision=0;
109 include/sync_slave_sql_with_master.inc
110 [Connection Slave]
111 SET @slave_save_windowing_use_high_precision= (SELECT @@windowing_use_high_precision);
112 SET GLOBAL windowing_use_high_precision=0;
113 [Connection Master]
114 CREATE TABLE t3b (
115 c1 decimal(27,2) DEFAULT NULL,
116 c2 double DEFAULT NULL,
117 c3 bigint(21) NOT NULL DEFAULT '0',
118 c4 int DEFAULT NULL,
119 c5 int DEFAULT NULL,
120 c6 varbinary(32),
121 c7 date DEFAULT NULL,
122 c8 datetime DEFAULT NULL,
123 c9 double DEFAULT NULL,
124 c10 double DEFAULT NULL,
125 c11 double DEFAULT NULL,
126 c12 double DEFAULT NULL,
127 c13 json,
128 c14 json
129 );
130 Warnings:
131 Warning 1681 Integer display width is deprecated and will be removed in a future release.
132 INSERT INTO t3b SELECT
133 SUM(a) OVER (ROWS UNBOUNDED PRECEDING) c1,
134 AVG(b) OVER (ORDER BY pk ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING) c2a,
135 COUNT(*) OVER (PARTITION BY d ORDER BY pk ROWS BETWEEN CURRENT ROW AND 2 FOLLOWING) c3,
136 BIT_AND(pk) OVER (PARTITION BY d ORDER BY pk ROWS BETWEEN 2 PRECEDING AND UNBOUNDED FOLLOWING) c4,
137 BIT_OR(a) OVER (PARTITION BY d ORDER BY e ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c5,
138 BIT_XOR(i) OVER (PARTITION BY c) c6,
139 MIN(e) OVER (ORDER BY e ROWS BETWEEN 2 PRECEDING AND UNBOUNDED FOLLOWING) c7,
140 MAX(f) OVER (ORDER BY f ROWS BETWEEN CURRENT ROW AND 2 FOLLOWING) c8,
141 STDDEV_SAMP(a) OVER (ORDER BY pk ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c9,
142 VAR_SAMP(a) OVER (ORDER BY pk ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c10,
143 STDDEV_POP(b) OVER () c11,
144 VAR_POP(a) OVER () c12,
145 JSON_ARRAYAGG(b) OVER (ROWS UNBOUNDED PRECEDING) c13,
146 JSON_OBJECTAGG(pk, f) OVER (PARTITION BY e ORDER BY pk RANGE BETWEEN CURRENT ROW AND 3 FOLLOWING) c14
147 FROM t1;
148 INSERT INTO t3b SELECT
149 SUM(a) OVER (RANGE UNBOUNDED PRECEDING) c1,
150 AVG(b) OVER (ORDER BY pk RANGE BETWEEN 2 PRECEDING AND 2 FOLLOWING) c2a,
151 COUNT(*) OVER (PARTITION BY d ORDER BY pk RANGE BETWEEN CURRENT ROW AND 2 FOLLOWING) c3,
152 BIT_AND(pk) OVER (PARTITION BY d ORDER BY f RANGE INTERVAL 2 YEAR PRECEDING) c4,
153 BIT_OR(a) OVER (PARTITION BY d ORDER BY e RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c5,
154 BIT_XOR(i) OVER (PARTITION BY c) c6,
155 MIN(e) OVER (ORDER BY e RANGE INTERVAL 5 YEAR PRECEDING) c4,
156 MAX(f) OVER (ORDER BY f RANGE BETWEEN CURRENT ROW AND INTERVAL 5 YEAR FOLLOWING) c5,
157 STDDEV_SAMP(a) OVER (ORDER BY pk RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c6,
158 VAR_SAMP(a) OVER (ORDER BY pk RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c7,
159 STDDEV_POP(b) OVER () c8,
160 VAR_POP(a) OVER () c9,
161 JSON_ARRAYAGG(e) OVER (ORDER BY e RANGE INTERVAL 4 YEAR PRECEDING) c12,
162 JSON_OBJECTAGG(pk, e) OVER (ORDER BY pk RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) c13
163 FROM t1;
164 SET GLOBAL windowing_use_high_precision=@master_save_windowing_use_high_precision;
165 include/sync_slave_sql_with_master.inc
166 [Connection Slave]
167 SET GLOBAL windowing_use_high_precision=@slave_save_windowing_use_high_precision;
168 [Connection Master]
169 # INSERT ... SELECT using window functions which return values having
170 # same type as that of the column
171 CREATE TABLE t4 (c1 decimal(5,2), c2 double, c3 char(10), c4 varchar(20), c5 date, c6 datetime, c7 text, c8 blob);
172 INSERT INTO t4 SELECT
173 FIRST_VALUE(a) OVER w1,
174 FIRST_VALUE(b) OVER w1,
175 FIRST_VALUE(c) OVER w1,
176 FIRST_VALUE(d) OVER w1,
177 FIRST_VALUE(e) OVER w1,
178 FIRST_VALUE(f) OVER w1,
179 FIRST_VALUE(g) OVER (PARTITION BY b ORDER BY pk ROWS 2 PRECEDING),
180 FIRST_VALUE(h) OVER (PARTITION BY b ORDER BY pk RANGE UNBOUNDED PRECEDING)
181 FROM t1
182 WINDOW w1 AS (PARTITION BY b ORDER BY pk);
183 INSERT INTO t4 SELECT
184 LAST_VALUE(a) OVER w1,
185 LAST_VALUE(b) OVER w1,
186 LAST_VALUE(c) OVER w1,
187 LAST_VALUE(d) OVER w2,
188 LAST_VALUE(e) OVER w2,
189 LAST_VALUE(f) OVER w1,
190 LAST_VALUE(g) OVER w2,
191 LAST_VALUE(h) OVER w1
192 FROM t1
193 WINDOW w1 AS (PARTITION BY c ORDER BY d ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING),
194 w2 AS (ORDER BY c,d);
195 INSERT INTO t4 SELECT
196 NTH_VALUE(a,1) OVER w1,
197 NTH_VALUE(b,2) OVER w1,
198 NTH_VALUE(c,3) OVER w1,
199 NTH_VALUE(d,1) OVER w1,
200 NTH_VALUE(e,2) OVER w1,
201 NTH_VALUE(f,3) OVER w1,
202 NTH_VALUE(g,1) OVER (PARTITION BY b ORDER BY pk ROWS 2 PRECEDING),
203 NTH_VALUE(h,2) OVER (PARTITION BY b ORDER BY pk RANGE BETWEEN UNBOUNDED PRECEDING AND 1 FOLLOWING)
204 FROM t1
205 WINDOW w1 AS (PARTITION BY b ORDER BY pk);
206 INSERT INTO t4 SELECT
207 LEAD(a,1,3) OVER w1,
208 LEAD(b,2) OVER w1,
209 LEAD(c) OVER w1,
210 LEAD(d,1) OVER w1,
211 LEAD(e,2) OVER w1,
212 LEAD(f,1) OVER w1,
213 LEAD(g,1) OVER w1,
214 LEAD(h,2) OVER w1
215 FROM t1
216 WINDOW w1 AS (PARTITION BY b ORDER BY pk);
217 INSERT INTO t4 SELECT
218 LAG(a,1,2) OVER w2,
219 LAG(b,2) OVER w1,
220 LAG(c) OVER w1,
221 LAG(d,1) OVER w2,
222 LAG(e,2) OVER w1,
223 LAG(f,1) OVER w2,
224 LAG(g,1) OVER w1,
225 LAG(h,2) OVER w3
226 FROM t1
227 WINDOW w1 AS (ORDER BY pk),
228 w2 AS (PARTITION BY g ORDER BY h),
229 w3 AS (PARTITION BY d ORDER BY NULL);
230 include/sync_slave_sql_with_master.inc
231 [Connection Slave]
232 include/diff_tables.inc [master:t4, slave:t4]
233 include/diff_tables.inc [master:t2, slave:t2]
234 include/diff_tables.inc [master:t3a, slave:t3a]
235 include/diff_tables.inc [master:t3b, slave:t3b]
236 [Connection Master]
237 # Update with window function in subquery
238 UPDATE t2 SET c1 = c1 + 1 WHERE c1 NOT IN (SELECT ROW_NUMBER() OVER () FROM DUAL);
239 UPDATE t2 SET c2 = c2 + 2 WHERE c2 IN (SELECT RANK() OVER () FROM DUAL);
240 UPDATE t2 SET c3 = c3 + 1 WHERE c3 IN (SELECT CUME_DIST() OVER () FROM DUAL);
241 UPDATE t4 SET c1=100 WHERE c1 IN (SELECT FIRST_VALUE(221) OVER () FROM DUAL);
242 UPDATE t4 SET c2=100 WHERE c2 = ANY (SELECT LAST_VALUE(2) OVER () FROM DUAL);
243 UPDATE t4 SET c3='Updated' WHERE c3 = SOME (SELECT NTH_VALUE('Blue',1) OVER () FROM DUAL);
244 UPDATE t4 SET c4='Updated' WHERE c4 = ALL (SELECT LEAD('Russia',0) OVER () FROM DUAL);
245 UPDATE t4 SET c5='2017-01-01' WHERE c5 IN (SELECT LAG('2010-09-20',0) OVER () FROM DUAL);
246 UPDATE t4 SET c6='2017-01-01 12:30:45' WHERE c6 IN (SELECT CAST(FIRST_VALUE('2007-08-27 14:06:53') OVER () AS DATETIME) FROM DUAL);
247 UPDATE t4 SET c7='Updated' WHERE c7 IN (SELECT LAST_VALUE('Alpha') OVER () FROM DUAL);
248 UPDATE t4 SET c8='Updated' WHERE c8 IN (SELECT NTH_VALUE('199utjJtezqMHCewY',1) OVER () FROM DUAL);
249 include/sync_slave_sql_with_master.inc
250 [Connection Slave]
251 include/diff_tables.inc [master:t2, slave:t2]
252 [Connection Master]
253 # Delete with window function in subquery
254 DELETE FROM t2 WHERE c1 IN (SELECT 1 + DENSE_RANK() OVER () FROM DUAL);
255 DELETE FROM t2 WHERE c2 = ANY (SELECT 2 + PERCENT_RANK() OVER () FROM DUAL);
256 DELETE FROM t2 WHERE c3 > SOME (SELECT NTILE(1) OVER () FROM DUAL);
257 DELETE FROM t4 WHERE c2 <= ALL (SELECT FIRST_VALUE(100) OVER () FROM DUAL);
258 DELETE FROM t4 WHERE c3 = ANY (SELECT LAST_VALUE('Updated') OVER () FROM DUAL);
259 DELETE FROM t4 WHERE c4 = ALL (SELECT NTH_VALUE('Updated',1) OVER () FROM DUAL);
260 DELETE FROM t4 WHERE c5 IN (SELECT LAG('2017-01-01',0) OVER () FROM DUAL);
261 DELETE FROM t4 WHERE c6 IN (SELECT CAST(FIRST_VALUE('2017-01-01 12:30:45') OVER () AS DATETIME) FROM DUAL);
262 DELETE FROM t4 WHERE c7 IN (SELECT LEAD('Updated') OVER () FROM DUAL);
263 DELETE FROM t4 WHERE c8 IN (SELECT NTH_VALUE('Updated',1) OVER () FROM DUAL);
264 include/sync_slave_sql_with_master.inc
265 [Connection Slave]
266 SELECT * FROM t2 where c1 IN (SELECT ROW_NUMBER() OVER () FROM DUAL);
267 c1 c2 c3 c4 c5 c6
268 include/diff_tables.inc [master:t2, slave:t2]
269 include/diff_tables.inc [master:t4, slave:t4]
270 [Connection Master]
271 # Clean up
272 DROP TABLE t1;
273 DROP TABLE t4;
274 DROP TABLE t2;
275 DROP TABLE t3a;
276 DROP TABLE t3b;
277 include/rpl_end.inc