Debian Codegraph @

mysql-test/suite/rpl/include/rpl_loadfile.test

raw
1 # Begin clean up test section
2 --disable_warnings
3 connection master;
4 DROP PROCEDURE IF EXISTS test.p1;
5 DROP TABLE IF EXISTS test.t1;
6 --enable_warnings
7
8 # Section 1 test
9
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;
13 delimiter |;
14 create procedure test.p1()
15 begin
16 INSERT INTO test.t1 VALUES(2,'test');
17 UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=2;
18 end|
19 delimiter ;|
20
21 CALL test.p1();
22 SELECT * FROM test.t1 ORDER BY blob_column;
23 save_master_pos;
24 sync_slave_with_master;
25 connection slave;
26 SELECT * FROM test.t1 ORDER BY blob_column;
27
28 # Cleanup
29 connection master;
30 DROP PROCEDURE IF EXISTS test.p1;
31 DROP TABLE test.t1;
32 sync_slave_with_master;