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