Gecko [ www.jdcpatala.org ]

Name	Size	Permission
disabled.def	919 B	-rw-r--r--
ndb_apply_status.frm	8.51 KB	-rw-r--r--
ndb_conflict_info.inc	3.79 KB	-rw-r--r--
ndb_conflict_info_epoch2.inc	3.2 KB	-rw-r--r--
ndb_conflict_info_epoch2_init....	1.33 KB	-rw-r--r--
ndb_conflict_info_init.inc	1.23 KB	-rw-r--r--
ndb_connect_to_primary.inc	160 B	-rw-r--r--
ndb_connect_to_secondary.inc	161 B	-rw-r--r--
ndb_dist_priv_check.inc	1.13 KB	-rw-r--r--
ndb_dist_priv_common.inc	6.89 KB	-rw-r--r--
ndb_dist_priv_default-master.o...	54 B	-rw-r--r--
ndb_dist_priv_default.test	975 B	-rw-r--r--
ndb_dist_priv_ndb-master.opt	54 B	-rw-r--r--
ndb_dist_priv_ndb.test	1.84 KB	-rw-r--r--
ndb_rpl_2innodb-master.opt	32 B	-rw-r--r--
ndb_rpl_2innodb-slave.opt	47 B	-rw-r--r--
ndb_rpl_2innodb.test	1.63 KB	-rw-r--r--
ndb_rpl_2multi_basic.inc	3.75 KB	-rw-r--r--
ndb_rpl_2multi_eng.inc	10.33 KB	-rw-r--r--
ndb_rpl_2myisam-master.opt	25 B	-rw-r--r--
ndb_rpl_2myisam-slave.opt	47 B	-rw-r--r--
ndb_rpl_2myisam.test	1.8 KB	-rw-r--r--
ndb_rpl_2ndb-slave.opt	58 B	-rw-r--r--
ndb_rpl_2ndb.test	858 B	-rw-r--r--
ndb_rpl_2other-slave.opt	45 B	-rw-r--r--
ndb_rpl_2other.test	2.18 KB	-rw-r--r--
ndb_rpl_add_column.test	3.81 KB	-rw-r--r--
ndb_rpl_apply_status-master.op...	28 B	-rw-r--r--
ndb_rpl_apply_status.test	1.5 KB	-rw-r--r--
ndb_rpl_auto_inc.test	4.18 KB	-rw-r--r--
ndb_rpl_bank.test	6.68 KB	-rw-r--r--
ndb_rpl_basic.test	11.65 KB	-rw-r--r--
ndb_rpl_batch.test	4.07 KB	-rw-r--r--
ndb_rpl_batch_handling.test	2.32 KB	-rw-r--r--
ndb_rpl_binlog_format_errors.t...	3.32 KB	-rw-r--r--
ndb_rpl_binlog_row_image_minim...	81 B	-rw-r--r--
ndb_rpl_binlog_row_image_minim...	293 B	-rw-r--r--
ndb_rpl_bitfield.test	8.11 KB	-rw-r--r--
ndb_rpl_blob.test	4.12 KB	-rw-r--r--
ndb_rpl_break_3_chain.cnf	1.59 KB	-rw-r--r--
ndb_rpl_break_3_chain.test	3.67 KB	-rw-r--r--
ndb_rpl_bug22045.test	2.4 KB	-rw-r--r--
ndb_rpl_bug_13440282.test	1.37 KB	-rw-r--r--
ndb_rpl_check_for_mixed.test	1014 B	-rw-r--r--
ndb_rpl_checksum.test	7.74 KB	-rw-r--r--
ndb_rpl_circular.test	4.42 KB	-rw-r--r--
ndb_rpl_circular_2ch.cnf	948 B	-rw-r--r--
ndb_rpl_circular_2ch.test	4.41 KB	-rw-r--r--
ndb_rpl_circular_2ch_rep_statu...	183 B	-rw-r--r--
ndb_rpl_circular_2ch_rep_statu...	11.9 KB	-rw-r--r--
ndb_rpl_circular_simplex.test	2.43 KB	-rw-r--r--
ndb_rpl_conflict_1.inc	5.15 KB	-rw-r--r--
ndb_rpl_conflict_basic.test	19.85 KB	-rw-r--r--
ndb_rpl_conflict_epoch.cnf	561 B	-rw-r--r--
ndb_rpl_conflict_epoch.inc	9.81 KB	-rw-r--r--
ndb_rpl_conflict_epoch.test	52 B	-rw-r--r--
ndb_rpl_conflict_epoch2.cnf	67 B	-rw-r--r--
ndb_rpl_conflict_epoch2.test	2.43 KB	-rw-r--r--
ndb_rpl_conflict_epoch2_extra....	37 B	-rw-r--r--
ndb_rpl_conflict_epoch2_extra....	31.45 KB	-rw-r--r--
ndb_rpl_conflict_epoch2_trans....	754 B	-rw-r--r--
ndb_rpl_conflict_epoch2_trans....	1.66 KB	-rw-r--r--
ndb_rpl_conflict_epoch_1.inc	18.75 KB	-rw-r--r--
ndb_rpl_conflict_epoch_ext.cnf	561 B	-rw-r--r--
ndb_rpl_conflict_epoch_ext.tes...	86 B	-rw-r--r--
ndb_rpl_conflict_epoch_extende...	868 B	-rw-r--r--
ndb_rpl_conflict_epoch_extende...	10.95 KB	-rw-r--r--
ndb_rpl_conflict_epoch_trans.c...	868 B	-rw-r--r--
ndb_rpl_conflict_epoch_trans.i...	27.77 KB	-rw-r--r--
ndb_rpl_conflict_epoch_trans.t...	58 B	-rw-r--r--
ndb_rpl_conflict_epoch_trans_e...	868 B	-rw-r--r--
ndb_rpl_conflict_epoch_trans_e...	92 B	-rw-r--r--
ndb_rpl_conflict_max-master.op...	28 B	-rw-r--r--
ndb_rpl_conflict_max.test	5.09 KB	-rw-r--r--
ndb_rpl_conflict_max_delete_wi...	28 B	-rw-r--r--
ndb_rpl_conflict_max_delete_wi...	4.92 KB	-rw-r--r--
ndb_rpl_conflict_old-master.op...	28 B	-rw-r--r--
ndb_rpl_conflict_old.test	5.11 KB	-rw-r--r--
ndb_rpl_conflict_read_tracking...	889 B	-rw-r--r--
ndb_rpl_conflict_read_tracking...	19.62 KB	-rw-r--r--
ndb_rpl_ctype_ucs2_def-master....	70 B	-rw-r--r--
ndb_rpl_ctype_ucs2_def.test	1.33 KB	-rw-r--r--
ndb_rpl_dd_advance.test	10.44 KB	-rw-r--r--
ndb_rpl_dd_basic.test	1.58 KB	-rw-r--r--
ndb_rpl_dd_partitions-master.o...	11 B	-rw-r--r--
ndb_rpl_dd_partitions-slave.op...	11 B	-rw-r--r--
ndb_rpl_dd_partitions.test	8.73 KB	-rw-r--r--
ndb_rpl_ddl_open_trans.test	360 B	-rw-r--r--
ndb_rpl_dist_priv.test	8.33 KB	-rw-r--r--
ndb_rpl_do_db-slave.opt	26 B	-rw-r--r--
ndb_rpl_do_db.test	1.73 KB	-rw-r--r--
ndb_rpl_do_table-slave.opt	29 B	-rw-r--r--
ndb_rpl_do_table.test	1.41 KB	-rw-r--r--
ndb_rpl_empty_epoch.test	1.12 KB	-rw-r--r--
ndb_rpl_gap_event-master.opt	24 B	-rw-r--r--
ndb_rpl_gap_event.test	2.26 KB	-rw-r--r--
ndb_rpl_get_binlog_events.inc	1.09 KB	-rw-r--r--
ndb_rpl_get_server_error_log.i...	553 B	-rw-r--r--
ndb_rpl_idempotent.test	5.72 KB	-rw-r--r--
ndb_rpl_ignore_db-master.opt	25 B	-rw-r--r--
ndb_rpl_ignore_db.test	1.27 KB	-rw-r--r--
ndb_rpl_init_rep_status.test	2.71 KB	-rw-r--r--
ndb_rpl_innodb2ndb-slave.opt	42 B	-rw-r--r--
ndb_rpl_innodb2ndb.test	714 B	-rw-r--r--
ndb_rpl_innodb_trans-slave.opt	25 B	-rw-r--r--
ndb_rpl_innodb_trans.test	1.54 KB	-rw-r--r--
ndb_rpl_last_conflict_epoch_va...	36 B	-rw-r--r--
ndb_rpl_last_conflict_epoch_va...	3.92 KB	-rw-r--r--
ndb_rpl_load.test	2.55 KB	-rw-r--r--
ndb_rpl_logging.test	3.96 KB	-rw-r--r--
ndb_rpl_mix_eng_trans.test	8.84 KB	-rw-r--r--
ndb_rpl_mix_innodb-master.opt	32 B	-rw-r--r--
ndb_rpl_mix_innodb.test	533 B	-rw-r--r--
ndb_rpl_mixed_tables-master.op...	13 B	-rw-r--r--
ndb_rpl_mixed_tables-slave.opt	61 B	-rw-r--r--
ndb_rpl_mixed_tables.test	8.35 KB	-rw-r--r--
ndb_rpl_multi.test	2.93 KB	-rw-r--r--
ndb_rpl_multi_binlog_update.cn...	1.83 KB	-rw-r--r--
ndb_rpl_multi_binlog_update.in...	6.78 KB	-rw-r--r--
ndb_rpl_multi_engine2.inc	2.56 KB	-rw-r--r--
ndb_rpl_multi_update2-slave.op...	42 B	-rw-r--r--
ndb_rpl_myisam2ndb-slave.opt	42 B	-rw-r--r--
ndb_rpl_myisam2ndb.test	890 B	-rw-r--r--
ndb_rpl_ndbapi-examples.test	996 B	-rw-r--r--
ndb_rpl_rep_error.test	14.2 KB	-rw-r--r--
ndb_rpl_rep_ignore-slave.opt	63 B	-rw-r--r--
ndb_rpl_rep_ignore.test	1.78 KB	-rw-r--r--
ndb_rpl_skip_gap_event-slave.o...	24 B	-rw-r--r--
ndb_rpl_skip_gap_event.test	2.39 KB	-rw-r--r--
ndb_rpl_slave_binlog_index.tes...	2.82 KB	-rw-r--r--
ndb_rpl_slave_conflict_role_va...	4.94 KB	-rw-r--r--
ndb_rpl_slave_lsu.cnf	57 B	-rw-r--r--
ndb_rpl_slave_lsu.test	5.87 KB	-rw-r--r--
ndb_rpl_slave_lsu_anyval.cnf	176 B	-rw-r--r--
ndb_rpl_slave_lsu_anyval.test	2.46 KB	-rw-r--r--
ndb_rpl_slave_replay.test	14.63 KB	-rw-r--r--
ndb_rpl_slave_restart.test	3.3 KB	-rw-r--r--
ndb_rpl_stm_innodb-master.opt	32 B	-rw-r--r--
ndb_rpl_stm_innodb.test	622 B	-rw-r--r--
ndb_rpl_sync.test	3.19 KB	-rw-r--r--
ndb_rpl_ui.test	2.29 KB	-rw-r--r--
ndb_rpl_ui2.test	957 B	-rw-r--r--
ndb_rpl_ui3.test	1.5 KB	-rw-r--r--
ndb_rpl_xxx_innodb.inc	6.25 KB	-rw-r--r--
ndb_slave_exec_info_init.inc	704 B	-rw-r--r--
ndb_sync_primary_to_secondary....	215 B	-rw-r--r--
ndb_sync_secondary_to_primary....	215 B	-rw-r--r--
ndb_trans_conflict_info.inc	1.71 KB	-rw-r--r--
ndb_trans_conflict_info_init.i...	1.5 KB	-rw-r--r--
ndb_trans_conflict_info_stable...	2.28 KB	-rw-r--r--
ndb_wait_for_zero_commit_ack_m...	569 B	-rw-r--r--
rpl_truncate_7ndb.test	1.78 KB	-rw-r--r--
rpl_truncate_7ndb_2.test	593 B	-rw-r--r--
select_ndb_apply_status.inc	505 B	-rw-r--r--
show_binlog_using_logname.inc	968 B	-rw-r--r--
show_mysqld_warnings.inc	780 B	-rw-r--r--
show_slave_max_replicated_epoc...	380 B	-rw-r--r--
wait_schema_logging.inc	2.33 KB	-rw-r--r--

Code Editor : ndb_rpl_rep_error.test

# The include statement below is a temp one for tests that are yet to
#be ported to run with InnoDB,
#but needs to be kept for tests that would need MyISAM in future.
--source include/force_myisam_default.inc

#
# Some negative tests of the ndb_replication table
#
#
--source include/have_multi_ndb.inc
--source include/have_binlog_format_mixed_or_row.inc
--source suite/ndb_rpl/ndb_master-slave.inc

# Need suppressions on all servers where warnings/errors can be seen.
--disable_query_log
--connection server1
call mtr.add_suppression("NDB: .*Bad schema for mysql.ndb_replication table.*");
call mtr.add_suppression("NDB Slave: .* unknown conflict resolution function .*");
call mtr.add_suppression("NDB Slave: .* has wrong datatype.*");
call mtr.add_suppression("NDB Slave: .* missing function argument .*");
call mtr.add_suppression("NDB Slave: .* missing \')\' .*");
--connection server2
call mtr.add_suppression("NDB: .*Bad schema for mysql.ndb_replication table.*");
call mtr.add_suppression("NDB Slave: .* unknown conflict resolution function .*");
call mtr.add_suppression("NDB Slave: .* has wrong datatype.*");
call mtr.add_suppression("NDB Slave: .* missing function argument .*");
call mtr.add_suppression("NDB Slave: .* missing \')\' .*");
--connection default
--enable_query_log

#
--echo Wrong schema for the table, too few pks
#
--disable_warnings
--disable_query_log
drop table if exists mysql.ndb_replication;
CREATE TABLE mysql.ndb_replication
  (db VARBINARY(63),
   table_name VARBINARY(63),
   server_id INT UNSIGNED,
   binlog_type INT UNSIGNED,
   conflict_fn VARBINARY(128),
   PRIMARY KEY USING HASH (db,table_name))
  ENGINE=NDB PARTITION BY KEY(db,table_name);
--enable_warnings
--enable_query_log

# gives warning when trying to create table as logging
# may not be as intended
create table t1 (a int key, X int) engine ndb;
drop table t1;

#
--echo Wrong schema for the table, incorrect pk
#
--disable_warnings
--disable_query_log
drop table if exists mysql.ndb_replication;
CREATE TABLE mysql.ndb_replication
  (db VARBINARY(63),
   table_name VARBINARY(63),
   server_id INT UNSIGNED,
   binlog_type INT UNSIGNED,
   conflict_fn VARBINARY(128),
   PRIMARY KEY USING HASH (db,table_name,binlog_type))
  ENGINE=NDB PARTITION BY KEY(db,table_name);
--enable_warnings
--enable_query_log

# gives warning when trying to create table as logging
# may not be as intended
create table t1 (a int key, X int) engine ndb;
drop table t1;

#
--echo Wrong schema for the table, binlog_type is signed
#

--disable_warnings
--disable_query_log
drop table if exists mysql.ndb_replication;
CREATE TABLE mysql.ndb_replication
  (db VARBINARY(63),
   table_name VARBINARY(63),
   server_id INT UNSIGNED,
   binlog_type INT,
   conflict_fn VARBINARY(128),
   PRIMARY KEY USING HASH (db,table_name,server_id))
  ENGINE=NDB PARTITION BY KEY(db,table_name);
--enable_warnings
--enable_query_log

# gives warning when trying to create table as logging
# may not be as intended
create table t1 (a int key, X int) engine ndb;
drop table t1;

#
--echo Wrong schema for the table, conflict_fn is too long
#
--disable_warnings
--disable_query_log
drop table mysql.ndb_replication;
CREATE TABLE mysql.ndb_replication
  (db VARBINARY(63),
   table_name VARBINARY(63),
   server_id INT UNSIGNED,
   binlog_type INT UNSIGNED,
   conflict_fn VARBINARY(257),
   PRIMARY KEY USING HASH (db,table_name,server_id))
  ENGINE=NDB PARTITION BY KEY(db,table_name);
--enable_warnings
--enable_query_log

# gives warning when trying to create table as logging
# may not be as intended
create table t1 (a int key, X int) engine ndb;
drop table t1;

#
--echo Correct schema for the table but no conflict fn
#
--disable_warnings
--disable_query_log
drop table mysql.ndb_replication;
CREATE TABLE mysql.ndb_replication
  (db VARBINARY(63),
   table_name VARBINARY(63),
   server_id INT UNSIGNED,
   binlog_type INT UNSIGNED,
   PRIMARY KEY USING HASH (db,table_name,server_id))
  ENGINE=NDB PARTITION BY KEY(db,table_name);
--enable_warnings
--enable_query_log

insert into mysql.ndb_replication values ("test", "t1", 0, 7);
create table test.t1 (a int primary key) engine=ndb;
show warnings;
drop table test.t1;

--let server_num=1.1
--let $pattern=%NDB Binlog: logging%
--let $limit=1
--source suite/ndb_rpl/t/show_mysqld_warnings.inc

delete from mysql.ndb_replication;

--echo Check that NULL uses server defaults
show variables like 'ndb_log_update_as_write';
show variables like 'ndb_log_updated_only';
insert into mysql.ndb_replication values ("test", "t1", 0, NULL);

create table test.t1 (a int primary key) engine=ndb;
show warnings;
drop table test.t1;

--source suite/ndb_rpl/t/show_mysqld_warnings.inc

#
--echo Correct schema for the table but other errors
#
--disable_warnings
--disable_query_log
drop table mysql.ndb_replication;
CREATE TABLE mysql.ndb_replication
  (db VARBINARY(63),
   table_name VARBINARY(63),
   server_id INT UNSIGNED,
   binlog_type INT UNSIGNED,
   conflict_fn VARBINARY(128),
   PRIMARY KEY USING HASH (db,table_name,server_id))
  ENGINE=NDB PARTITION BY KEY(db,table_name);
--enable_warnings
--enable_query_log

# Non existant conflict_fn
# gives error when creating table
#call mtr.add_suppression("NDB Slave: .* unknown conflict resolution function .*");

insert into mysql.ndb_replication values ("test", "t1", 0, NULL, "NDB$X(X)");
--error 1296 
create table t1 (a int key, X int) engine ndb;
show warnings;
delete from mysql.ndb_replication;

# Column type cannot be used for this function
# gives warning when creating table
#call mtr.add_suppression("NDB Slave: .* has wrong datatype.*");

insert into mysql.ndb_replication values ("test", "t1", 0, NULL, "NDB$MAX(X)");
create table t1 (a int key, X int) engine ndb;
drop table t1;
delete from mysql.ndb_replication;

# Too few arguments
# gives error when creating table
#call mtr.add_suppression("NDB Slave: .* missing function argument .*");

insert into mysql.ndb_replication values ("test", "t1", 0, NULL, "NDB$MAX()");
--error 1296 
create table t1 (a int key, X int) engine ndb;
show warnings;
delete from mysql.ndb_replication;

# Too many arguments
# gives error when creating table
#call mtr.add_suppression("NDB Slave: .* missing \')\' .*");
insert into mysql.ndb_replication values ("test", "t1", 0, NULL, "NDB$MAX(X Y)");
--error 1296
create table t1 (a int key, X int) engine ndb;
show warnings;
delete from mysql.ndb_replication;

show variables like 'server_id';

create database europenorth;
create database europesouth;
create database usnorth;
create database ussouth;

--echo Basic wildcard tests
--echo Note that we put in bad conflict fn names so that the warnings generated
--echo when the table create fails give an indication of which ndb_replication
--echo table row was chosen.
--echo
--echo Wild serverid
insert into mysql.ndb_replication values ("europenorth", "france", 1, NULL, "NDB$A()");
insert into mysql.ndb_replication values ("europenorth", "france", 0, NULL, "NDB$B()");

--echo Should match specific entry (1) with algorithm A.
--error 1296
create table europenorth.france (a int primary key) engine=ndb;
show warnings;

delete from mysql.ndb_replication where server_id=1;

--echo Should match generic entry (0) with algorthin B.
--error 1296
create table europenorth.france (a int primary key) engine=ndb;
show warnings;

delete from mysql.ndb_replication;

--echo Wild table_name
insert into mysql.ndb_replication values ("europenorth", "fr_nce", 1, NULL, "NDB$A()");
insert into mysql.ndb_replication values ("europenorth", "%any", 1, NULL, "NDB$B()");

--echo Should match specific entry (fr_nce) with algorithm A.
--error 1296
create table europenorth.france (a int primary key) engine=ndb;
show warnings;

--echo Should match specific entry (%any) with algorithm B.
--error 1296
create table europenorth.germany (a int primary key) engine=ndb;
show warnings;

--echo Should match specific entry (%any) with algorithm B.
--error 1296
create table europenorth.romany (a int primary key) engine=ndb;
show warnings;

--echo No match, should be fine
create table europenorth.uk (a int primary key) engine=ndb;
show warnings;
drop table europenorth.uk;

delete from mysql.ndb_replication;

--echo Wild db
insert into mysql.ndb_replication values ("%north", "countries", 1, NULL, "NDB$A()");
insert into mysql.ndb_replication values ("%south", "countries", 1, NULL, "NDB$B()");

--echo Should match north with A
--error 1296
create table europenorth.countries (a int primary key) engine=ndb;
show warnings;

--echo Should match north with A
--error 1296
create table usnorth.countries (a int primary key) engine=ndb;
show warnings;

--echo Should match south with B
--error 1296
create table europesouth.countries (a int primary key) engine=ndb;
show warnings;

--echo Should match south with B
--error 1296 
create table ussouth.countries (a int primary key) engine=ndb;
show warnings;

delete from mysql.ndb_replication;

--echo Now test wildcard matching precedence
--echo Wildcards match in the following precedence (highest->lowest)
--echo   Exact match
--echo   Wild serverid
--echo   Wild table_name
--echo   Wild serverid + wild table_name
--echo   Wild db
--echo   Wild db + wild serverid
--echo   Wild db + wild table_name
--echo   All wild
--echo
--echo The 'wild serverid' is 0
--echo
--echo Multiple matches at the same precedence are ambiguous and result
--echo in an error.
--echo

--echo Start with full set of potential matches, and chip away
# Put in duplicate matches at every precedence
# Delete rows to get one then no matches at each precedence.

# Unique
insert into mysql.ndb_replication values ("europenorth", "netherlands", 1, NULL, "NDB$A()");

# Wild serverid
insert into mysql.ndb_replication values ("europenorth", "netherlands", 0, NULL, "NDB$B()");

# Wild table_name (two)
insert into mysql.ndb_replication values ("europenorth", "%lands", 1, NULL, "NDB$C()");
insert into mysql.ndb_replication values ("europenorth", "nether%s", 1, NULL, "NDB$D()");

# Wild server_id and table_name
insert into mysql.ndb_replication values ("europenorth", "%lands", 0, NULL, "NDB$E()");
insert into mysql.ndb_replication values ("europenorth", "nether%s", 0, NULL, "NDB$F()");

# Wild db
insert into mysql.ndb_replication values ("Europe%", "netherlands", 1, NULL, "NDB$G()");
insert into mysql.ndb_replication values ("%North", "netherlands", 1, NULL, "NDB$H()");

# Wild db + Wild server_id

insert into mysql.ndb_replication values ("Europe%", "netherlands", 0, NULL, "NDB$I()");
insert into mysql.ndb_replication values ("%North", "netherlands", 0, NULL, "NDB$J()");

# Wild db + Wild table_name

insert into mysql.ndb_replication values ("Europe%", "%lands", 1, NULL, "NDB$K()");
insert into mysql.ndb_replication values ("%North", "nether%s", 1, NULL, "NDB$L()");

# All wild

insert into mysql.ndb_replication values ("Europe%", "%lands", 0, NULL, "NDB$M()");
insert into mysql.ndb_replication values ("%North", "nether%s", 0, NULL, "NDB$N()");

--echo Unique match (A)
--error 1296
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;

delete from mysql.ndb_replication where db="europenorth" and table_name="netherlands" and server_id=1;

--echo Unique match with wild serverid (B)
--error 1296
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;

delete from mysql.ndb_replication where db="europenorth" and table_name="netherlands" and server_id=0;

--echo Ambiguous wild table name
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;
drop table europenorth.netherlands;

delete from mysql.ndb_replication where db="europenorth" and table_name="%lands" and server_id=1;

--echo Wild table name (D)
--error 1296
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;

delete from mysql.ndb_replication where db="europenorth" and table_name="nether%s" and server_id=1;

--echo Ambiguous wild server id and table name
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;
drop table europenorth.netherlands;

delete from mysql.ndb_replication where db="europenorth" and table_name="nether%s" and server_id=0;

--echo Wild server id and table name (E)
--error 1296
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;

delete from mysql.ndb_replication where db="europenorth" and table_name="%lands" and server_id=0;

--echo Amiguous wild db
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;
drop table europenorth.netherlands;

delete from mysql.ndb_replication where db="Europe%" and table_name="netherlands" and server_id=1;

--echo Wild db (H)
--error 1296 
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;

delete from mysql.ndb_replication where db="%North" and table_name="netherlands" and server_id=1;

--echo Ambiguous wild db + server_id
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;
drop table europenorth.netherlands;

delete from mysql.ndb_replication where db="Europe%" and table_name="netherlands" and server_id=0;

--echo Wild db + server id (J)
--error 1296 
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;

delete from mysql.ndb_replication where db="%North" and table_name="netherlands" and server_id=0;

--echo Ambiguous wild db + table_name
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;
drop table europenorth.netherlands;

delete from mysql.ndb_replication where db="Europe%" and table_name="%lands" and server_id=1;

--echo Wild db + table_name (L)
--error 1296 
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;

delete from mysql.ndb_replication where db="%North" and table_name="nether%s" and server_id=1;

--echo Ambiguous all wild
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;
drop table europenorth.netherlands;

delete from mysql.ndb_replication where db="Europe%" and table_name="%lands" and server_id=0;

--echo All wild (N)
--error 1296
create table europenorth.netherlands (a int primary key) engine=ndb;
show warnings;

delete from mysql.ndb_replication;

drop database europenorth;
drop database europesouth;
drop database usnorth;
drop database ussouth;

--disable_query_log
--sync_slave_with_master
stop slave;
drop table mysql.ndb_replication;
--connection master
drop table mysql.ndb_replication;
--enable_query_log

${this.title}

Code Editor : ndb_rpl_rep_error.test