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;