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

File Name : rpl_ndb_insert_ignore.result

include/master-slave.inc
[connection master]
CREATE TABLE t1 (
a int unsigned not null auto_increment primary key,
b int unsigned,
unique (b)
) ENGINE=NDB;
CREATE TABLE t2 (
a int unsigned, # to force INSERT SELECT to have a certain order
b int unsigned
) ENGINE=NDB;
INSERT INTO t1 VALUES (NULL, 1);
INSERT INTO t1 VALUES (NULL, 2);
INSERT INTO t1 VALUES (NULL, 3);
INSERT INTO t1 VALUES (NULL, 4);
INSERT INTO t2 VALUES (1, 1);
INSERT INTO t2 VALUES (2, 2);
INSERT INTO t2 VALUES (3, 5);
INSERT INTO t2 VALUES (4, 3);
INSERT INTO t2 VALUES (5, 4);
INSERT INTO t2 VALUES (6, 6);
INSERT IGNORE INTO t1 SELECT NULL, t2.b FROM t2 ORDER BY t2.a;
include/assert.inc [Count of elements in t1 should be 6.]
include/sync_slave_sql_with_master.inc
include/diff_tables.inc [master:test.t1 , slave:test.t1]
INSERT IGNORE INTO t1 SELECT NULL, t2.b FROM t2 ORDER BY t2.a;
include/assert.inc [Count of elements in t1 should be 6.]
include/assert.inc [In SBR or MIXED modes, the event in the binlog should be the same that was executed. In RBR mode, binlog position should stay unchanged.]
drop table t1, t2;
include/sync_slave_sql_with_master.inc
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