1include/master-slave.inc 2Warnings: 3Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. 4Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 5[connection master] 6DROP PROCEDURE IF EXISTS test.p1; 7DROP TABLE IF EXISTS test.t1; 8CREATE TABLE test.t1 (a INT, blob_column LONGBLOB, PRIMARY KEY(a)); 9INSERT INTO test.t1 VALUES(1,'test'); 10UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=1; 11create procedure test.p1() 12begin 13INSERT INTO test.t1 VALUES(2,'test'); 14UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=2; 15end| 16CALL test.p1(); 17SELECT * FROM test.t1 ORDER BY blob_column; 18a blob_column 191 abase 20abased 21abasement 22abasements 23abases 24abash 25abashed 26abashes 27abashing 28abasing 29abate 30abated 31abatement 32abatements 33abater 34abates 35abating 36Abba 37abbe 38abbey 39abbeys 40abbot 41abbots 42Abbott 43abbreviate 44abbreviated 45abbreviates 46abbreviating 47abbreviation 48abbreviations 49Abby 50abdomen 51abdomens 52abdominal 53abduct 54abducted 55abduction 56abductions 57abductor 58abductors 59abducts 60Abe 61abed 62Abel 63Abelian 64Abelson 65Aberdeen 66Abernathy 67aberrant 68aberration 69 702 abase 71abased 72abasement 73abasements 74abases 75abash 76abashed 77abashes 78abashing 79abasing 80abate 81abated 82abatement 83abatements 84abater 85abates 86abating 87Abba 88abbe 89abbey 90abbeys 91abbot 92abbots 93Abbott 94abbreviate 95abbreviated 96abbreviates 97abbreviating 98abbreviation 99abbreviations 100Abby 101abdomen 102abdomens 103abdominal 104abduct 105abducted 106abduction 107abductions 108abductor 109abductors 110abducts 111Abe 112abed 113Abel 114Abelian 115Abelson 116Aberdeen 117Abernathy 118aberrant 119aberration 120 121include/sync_slave_sql_with_master.inc 122SELECT * FROM test.t1 ORDER BY blob_column; 123a blob_column 1241 abase 125abased 126abasement 127abasements 128abases 129abash 130abashed 131abashes 132abashing 133abasing 134abate 135abated 136abatement 137abatements 138abater 139abates 140abating 141Abba 142abbe 143abbey 144abbeys 145abbot 146abbots 147Abbott 148abbreviate 149abbreviated 150abbreviates 151abbreviating 152abbreviation 153abbreviations 154Abby 155abdomen 156abdomens 157abdominal 158abduct 159abducted 160abduction 161abductions 162abductor 163abductors 164abducts 165Abe 166abed 167Abel 168Abelian 169Abelson 170Aberdeen 171Abernathy 172aberrant 173aberration 174 1752 abase 176abased 177abasement 178abasements 179abases 180abash 181abashed 182abashes 183abashing 184abasing 185abate 186abated 187abatement 188abatements 189abater 190abates 191abating 192Abba 193abbe 194abbey 195abbeys 196abbot 197abbots 198Abbott 199abbreviate 200abbreviated 201abbreviates 202abbreviating 203abbreviation 204abbreviations 205Abby 206abdomen 207abdomens 208abdominal 209abduct 210abducted 211abduction 212abductions 213abductor 214abductors 215abducts 216Abe 217abed 218Abel 219Abelian 220Abelson 221Aberdeen 222Abernathy 223aberrant 224aberration 225 226DROP PROCEDURE IF EXISTS test.p1; 227DROP TABLE test.t1; 228include/sync_slave_sql_with_master.inc 229include/rpl_reset.inc 230SELECT repeat('x',20) INTO OUTFILE 'MYSQLTEST_VARDIR/tmp/bug_39701.data'; 231DROP TABLE IF EXISTS t1; 232CREATE TABLE t1 (t text); 233CREATE PROCEDURE p(file varchar(4096)) 234BEGIN 235INSERT INTO t1 VALUES (LOAD_FILE(file)); 236END| 237include/stop_slave.inc 238CALL p('MYSQLTEST_VARDIR/tmp/bug_39701.data'); 239include/start_slave.inc 240include/sync_slave_sql_with_master.inc 241include/diff_tables.inc [master:t1, slave:t1] 242DROP TABLE t1; 243DROP PROCEDURE p; 244include/rpl_end.inc 245