1-- source myconn.inc 2 3--echo # 4--echo # Checking Sending Commands 5--echo # 6connection master; 7 8--replace_result $SLAVE_MYPORT SLAVE_PORT 9eval CREATE TABLE t1 ( 10 command VARCHAR(128) NOT NULL, 11 warnings INT(4) NOT NULL FLAG=3, 12 number INT(5) NOT NULL FLAG=1, 13 message VARCHAR(255) FLAG=2) 14 ENGINE=CONNECT TABLE_TYPE=MYSQL CONNECTION='mysql://root@127.0.0.1:$SLAVE_MYPORT/test' OPTION_LIST='Execsrc=1,maxerr=2'; 15 16SELECT * FROM t1 WHERE command IN ('Warning','Note', 17 'drop table if exists t1', 18 'create table t1 (id int key auto_increment, msg varchar(32) not null)', 19 "insert into t1(msg) values('One'),(NULL),('Three')", 20 "insert into t1 values(2,'Deux') on duplicate key update msg = 'Two'", 21 "insert into t1(message) values('Four'),('Five'),('Six')", 22 'insert ignore into t1(id) values(NULL)', 23 "update t1 set msg = 'Four' where id = 4", 24 'select * from t1'); 25 26--echo # 27--echo # Checking Using Procedure 28--echo # 29DROP PROCEDURE IF EXISTS p1; 30CREATE PROCEDURE p1(cmd varchar(512)) 31 READS SQL DATA 32 SELECT * FROM t1 WHERE command IN ('Warning','Note',cmd); 33 34CALL p1('insert ignore into t1(id) values(NULL)'); 35CALL p1('update t1 set msg = "Five" where id = 5'); 36DROP PROCEDURE p1; 37DROP TABLE t1; 38 39connection slave; 40--sorted_result 41SELECT * FROM t1; 42DROP TABLE t1; 43 44-- source myconn_cleanup.inc 45 46