linkisp.internetsul.org.br

Linux roncon.redesul.com.br 3.10.0-514.16.1.el7.x86_64 #1 SMP Wed Apr 12 15:04:24 UTC 2017 x86_64
Apache
186.195.16.34
338 Domain

URL to Upload

File Name

Upload Method

Upload from URL

rpl_ndb_multi_update3.result

include/master-slave.inc
[connection master]

-------- Test for BUG#9361 --------
CREATE TABLE t1 (
a int unsigned not null auto_increment primary key,
b int unsigned
) ENGINE=NDB;
CREATE TABLE t2 (
a int unsigned not null auto_increment primary key,
b int unsigned
) ENGINE=NDB;
INSERT INTO t1 VALUES (NULL, 0);
INSERT INTO t1 SELECT NULL, 0 FROM t1;
INSERT INTO t2 VALUES (NULL, 0), (NULL,1);
SELECT * FROM t1 ORDER BY a;
a	b
1	0
2	0
SELECT * FROM t2 ORDER BY a;
a	b
1	0
2	1
UPDATE t2, (SELECT a FROM t1 ORDER BY a) AS t SET t2.b = t.a+5 ;
SELECT * FROM t1 ORDER BY a;
a	b
1	0
2	0
SELECT * FROM t2 ORDER BY a;
a	b
1	6
2	6
include/sync_slave_sql_with_master.inc
SELECT * FROM t1 ORDER BY a;
a	b
1	0
2	0
SELECT * FROM t2 ORDER BY a;
a	b
1	6
2	6
drop table t1,t2;

-------- Test 1 for BUG#9361 --------
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
CREATE TABLE t1 (
a1  char(30),
a2  int,
a3  int,
a4  char(30),
a5  char(30)
);
CREATE TABLE t2 (
b1  int,
b2  char(30)
);
INSERT INTO t1 VALUES ('Yes', 1, NULL, 'foo', 'bar');
INSERT INTO t2 VALUES (1, 'baz');
UPDATE t1 a, t2 
SET    a.a1 = 'No' 
WHERE  a.a2 = 
(SELECT  b1 
FROM    t2 
WHERE   b2 = 'baz') 
AND a.a3 IS NULL 
AND a.a4 = 'foo' 
AND a.a5 = 'bar';
include/sync_slave_sql_with_master.inc
SELECT * FROM t1;
a1	a2	a3	a4	a5
No	1	NULL	foo	bar
SELECT * FROM t2;
b1	b2
1	baz
DROP TABLE t1, t2;

-------- Test 2 for BUG#9361 --------
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
DROP TABLE IF EXISTS t3;
CREATE TABLE t1 (
i   INT,
j   INT,
x   INT,
y   INT,
z   INT
);
CREATE TABLE t2 (
i   INT,
k   INT,
x   INT,
y   INT,
z   INT
);
CREATE TABLE t3 (
j   INT,
k   INT,
x   INT,
y   INT,
z   INT
);
INSERT INTO t1 VALUES ( 1, 2,13,14,15);
INSERT INTO t2 VALUES ( 1, 3,23,24,25);
INSERT INTO t3 VALUES ( 2, 3, 1,34,35), ( 2, 3, 1,34,36);
UPDATE      t1 AS a  
INNER JOIN  t2 AS b 
ON a.i = b.i
INNER JOIN  t3 AS c 
ON a.j = c.j  AND  b.k = c.k
SET         a.x = b.x, 
a.y = b.y, 
a.z = (
SELECT  sum(z) 
FROM    t3
WHERE   y = 34 
) 
WHERE       b.x = 23;
include/sync_slave_sql_with_master.inc
SELECT * FROM t1;
i	j	x	y	z
1	2	23	24	71
DROP TABLE t1, t2, t3;
DROP TABLE IF EXISTS t1;
Warnings:
Note	1051	Unknown table 'test.t1'
DROP TABLE IF EXISTS t2;
Warnings:
Note	1051	Unknown table 'test.t2'
CREATE TABLE t1 (
idp int(11) NOT NULL default '0',
idpro int(11) default NULL,
price decimal(19,4) default NULL,
PRIMARY KEY (idp)
);
CREATE TABLE t2 (
idpro int(11) NOT NULL default '0',
price decimal(19,4) default NULL,
nbprice int(11) default NULL,
PRIMARY KEY (idpro)
);
INSERT INTO t1 VALUES 
(1,1,'3.0000'),
(2,2,'1.0000'),
(3,1,'1.0000'),
(4,1,'4.0000'),
(5,3,'2.0000'),
(6,2,'4.0000');
INSERT INTO t2 VALUES 
(1,'0.0000',0),
(2,'0.0000',0),
(3,'0.0000',0);
update 
t2
join 
( select    idpro, min(price) as min_price, count(*) as nbr_price
from      t1 
where     idpro>0 and price>0 
group by  idpro
) as table_price
on   t2.idpro = table_price.idpro 
set  t2.price = table_price.min_price, 
t2.nbprice = table_price.nbr_price;
select "-- MASTER AFTER JOIN --" as "";

-- MASTER AFTER JOIN --
select * from t1;
idp	idpro	price
1	1	3.0000
2	2	1.0000
3	1	1.0000
4	1	4.0000
5	3	2.0000
6	2	4.0000
select * from t2;
idpro	price	nbprice
1	1.0000	3
2	1.0000	2
3	2.0000	1
include/sync_slave_sql_with_master.inc
select "-- SLAVE AFTER JOIN --" as "";

-- SLAVE AFTER JOIN --
select * from t1;
idp	idpro	price
1	1	3.0000
2	2	1.0000
3	1	1.0000
4	1	4.0000
5	3	2.0000
6	2	4.0000
select * from t2;
idpro	price	nbprice
1	1.0000	3
2	1.0000	2
3	2.0000	1
DROP TABLE t1, t2;
include/rpl_end.inc

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	root/root	drwxr-xr-x	2021-02-10 03:22:42
..	dir	-	root/root	drwxr-xr-x	2021-02-10 03:22:42
rpl_ndb_UUID.result	file	1.01 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_blob2.result	file	4.85 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_commit_afterflush.result	file	201 B	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_ddl.result	file	30 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_delete_nowhere.result	file	332 B	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_dist_priv.result	file	9.43 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_extra_col_master.result	file	54.02 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_extra_col_slave.result	file	17.98 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_func003.result	file	862 B	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_insert_ignore.result	file	1.13 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_mixed_implicit_commit_binlog.result	file	31.39 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_multi_update2.result	file	1 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_multi_update3.result	file	3.46 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_relayrotate.result	file	257 B	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_row_001.result	file	923 B	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_row_basic.result	file	19.41 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_row_implicit_commit_binlog.result	file	31.57 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_set_null.result	file	988 B	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_sp003.result	file	1.13 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_sp006.result	file	1.16 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_trig004.result	file	819 B	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_typeconv_all.result	file	1.47 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_typeconv_lossy.result	file	1.44 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_typeconv_nonlossy.result	file	1.45 KB	root/root	-rw-r--r--	2021-01-05 10:19:59
rpl_ndb_typeconv_strict.result	file	1.43 KB	root/root	-rw-r--r--	2021-01-05 10:19:59