1 # Begin clean up test section
4 DROP PROCEDURE IF EXISTS test.p1;
5 DROP TABLE IF EXISTS test.t1;
10 CREATE TABLE test.t1 (a INT, blob_column LONGBLOB, PRIMARY KEY(a));
11 INSERT INTO test.t1 VALUES(1,'test');
12 UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=1;
14 create procedure test.p1()
16 INSERT INTO test.t1 VALUES(2,'test');
17 UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=2;
22 SELECT * FROM test.t1 ORDER BY blob_column;
24 sync_slave_with_master;
26 # Need to allow some time when NDB engine is used for
27 # the injector thread to have time to populate binlog
28 let $wait_condition= SELECT INSTR(blob_column,'aberration') > 0 FROM test.t1 WHERE a = 2;
29 --source include/wait_condition.inc
30 SELECT * FROM test.t1 ORDER BY blob_column;
34 DROP PROCEDURE IF EXISTS test.p1;
36 sync_slave_with_master;