mirror of
https://github.com/MariaDB/server.git
synced 2025-10-05 07:19:14 +02:00
37ca3ea8c5MySQL created `rpl_injector` to assist in binlogging the NDB Cluster
storage engine. It describes itself as for notifying the MySQL server
of externally spawned rows.
However, we use Galera here at MariaDB, not MySQL NDB Cluster.
MDEV-34 removed the NDB storage engine from our fork,
which orphaned `rpl_injector`.
c096caee71 said that this is considered dead code and a subsequent patch
will remove the rest. That patch never came, so this commit shall be it.
58 lines
2.1 KiB
SQL
58 lines
2.1 KiB
SQL
#############################################################
|
|
# Author: JBM
|
|
# Date: 2006-02-23
|
|
# Purpose: To reuse through out test and make maint easier
|
|
#############################################################
|
|
connection master;
|
|
--echo "--- Insert into t1 --" as "";
|
|
|
|
--disable_query_log
|
|
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ',
|
|
'Must make it bug free for the customer',
|
|
654321.4321,15.21,0,1965,"1905-11-14");
|
|
INSERT INTO t1 VALUES(2,1,'Testing MySQL databases is a cool ',
|
|
'Must make it bug free for the customer',
|
|
654321.4321,15.21,0,1965,"1965-11-14");
|
|
INSERT INTO t1 VALUES(4,1,'Testing MySQL databases is a cool ',
|
|
'Must make it bug free for the customer',
|
|
654321.4321,15.21,0,1965,"1985-11-14");
|
|
INSERT INTO t1 VALUES(142,1,'Testing MySQL databases is a cool ',
|
|
'Must make it bug free for the customer',
|
|
654321.4321,15.21,0,1965,"1995-11-14");
|
|
INSERT INTO t1 VALUES(412,1,'Testing MySQL databases is a cool ',
|
|
'Must make it bug free for the customer',
|
|
654321.4321,15.21,0,1965,"2005-11-14");
|
|
--enable_query_log
|
|
|
|
--echo --- Select from t1 on master ---
|
|
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
|
|
|
|
sync_slave_with_master;
|
|
--echo --- Select from t1 on slave ---
|
|
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
|
|
|
|
connection master;
|
|
|
|
--echo --- Update t1 on master --
|
|
UPDATE t1 SET b1 = 0, t="2006-02-22" WHERE id = 412;
|
|
|
|
--echo --- Check the update on master ---
|
|
SELECT id,hex(b1),vc,bc,d,f,total,y,t FROM t1 WHERE id = 412;
|
|
|
|
sync_slave_with_master;
|
|
--echo --- Check Update on slave ---
|
|
SELECT id,hex(b1),vc,bc,d,f,total,y,t FROM t1 WHERE id = 412;
|
|
|
|
connection master;
|
|
--echo --- Remove a record from t1 on master ---
|
|
DELETE FROM t1 WHERE id = 42;
|
|
|
|
--echo --- Show current count on master for t1 ---
|
|
SELECT COUNT(*) FROM t1;
|
|
|
|
sync_slave_with_master;
|
|
--echo --- Show current count on slave for t1 ---
|
|
SELECT COUNT(*) FROM t1;
|
|
|
|
connection master;
|
|
DELETE FROM t1;
|