1 include/master-slave.inc
4 -------- Test for BUG#9361 --------
6 a int unsigned not null auto_increment primary key,
10 a int unsigned not null auto_increment primary key,
13 INSERT INTO t1 VALUES (NULL, 0);
14 INSERT INTO t1 SELECT NULL, 0 FROM t1;
15 INSERT INTO t2 VALUES (NULL, 0), (NULL,1);
16 SELECT * FROM t1 ORDER BY a;
20 SELECT * FROM t2 ORDER BY a;
24 UPDATE t2, (SELECT a FROM t1 ORDER BY a) AS t SET t2.b = t.a+5 ;
25 SELECT * FROM t1 ORDER BY a;
29 SELECT * FROM t2 ORDER BY a;
33 SELECT * FROM t1 ORDER BY a;
37 SELECT * FROM t2 ORDER BY a;
43 -------- Test 1 for BUG#9361 --------
44 DROP TABLE IF EXISTS t1;
45 DROP TABLE IF EXISTS t2;
57 INSERT INTO t1 VALUES ('Yes', 1, NULL, 'foo', 'bar');
58 INSERT INTO t2 VALUES (1, 'baz');
76 -------- Test 2 for BUG#9361 --------
77 DROP TABLE IF EXISTS t1;
78 DROP TABLE IF EXISTS t2;
79 DROP TABLE IF EXISTS t3;
101 INSERT INTO t1 VALUES ( 1, 2,13,14,15);
102 INSERT INTO t2 VALUES ( 1, 3,23,24,25);
103 INSERT INTO t3 VALUES ( 2, 3, 1,34,35), ( 2, 3, 1,34,36);
108 ON a.j = c.j AND b.k = c.k
120 DROP TABLE t1, t2, t3;
121 DROP TABLE IF EXISTS t1;
123 Note 1051 Unknown table 't1'
124 DROP TABLE IF EXISTS t2;
126 Note 1051 Unknown table 't2'
128 idp int(11) NOT NULL default '0',
129 idpro int(11) default NULL,
130 price decimal(19,4) default NULL,
134 idpro int(11) NOT NULL default '0',
135 price decimal(19,4) default NULL,
136 nbprice int(11) default NULL,
139 INSERT INTO t1 VALUES
146 INSERT INTO t2 VALUES
153 ( select idpro, min(price) as min_price, count(*) as nbr_price
155 where idpro>0 and price>0
158 on t2.idpro = table_price.idpro
159 set t2.price = table_price.min_price,
160 t2.nbprice = table_price.nbr_price;
161 select "-- MASTER AFTER JOIN --" as "";
163 -- MASTER AFTER JOIN --
177 select "-- SLAVE AFTER JOIN --" as "";
179 -- SLAVE AFTER JOIN --