1include/master-slave.inc 2[connection master] 3call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT"); 4==== Initialization ==== 5connection master; 6SET @m_auto_increment_increment= @@global.auto_increment_increment; 7SET @m_auto_increment_offset= @@global.auto_increment_offset; 8SET @m_character_set_client= @@global.character_set_client; 9SET @m_collation_connection= @@global.collation_connection; 10SET @m_collation_server= @@global.collation_server; 11SET @m_time_zone= @@global.time_zone; 12SET @m_lc_time_names= @@global.lc_time_names; 13SET @m_collation_database= @@global.collation_database; 14connection slave; 15SET @s_auto_increment_increment= @@global.auto_increment_increment; 16SET @s_auto_increment_offset= @@global.auto_increment_offset; 17SET @s_character_set_client= @@global.character_set_client; 18SET @s_collation_connection= @@global.collation_connection; 19SET @s_collation_server= @@global.collation_server; 20SET @s_time_zone= @@global.time_zone; 21SET @s_lc_time_names= @@global.lc_time_names; 22SET @s_collation_database= @@global.collation_database; 23SET @@global.auto_increment_increment=19; 24SET @@global.auto_increment_offset=4; 25SET @@global.character_set_client='latin2'; 26SET @@global.collation_connection='latin2_bin'; 27SET @@global.collation_server='geostd8_general_ci'; 28SET @@global.time_zone='Japan'; 29SET @@global.lc_time_names='sv_SE'; 30SET @@global.collation_database='geostd8_bin'; 31connection master; 32CREATE TABLE tstmt (id INT AUTO_INCREMENT PRIMARY KEY, 33num INT, 34text VARCHAR(100)); 35CREATE TABLE tproc LIKE tstmt; 36CREATE TABLE tfunc LIKE tstmt; 37CREATE TABLE ttrig LIKE tstmt; 38CREATE TABLE tprep LIKE tstmt; 39CREATE TABLE trigger_table (text CHAR(4)); 40==== Insert variables directly ==== 41SET @@pseudo_thread_id= 4712; 42INSERT INTO tstmt(num) VALUES (@@session.pseudo_thread_id); 43SET @@pseudo_thread_id= 4713; 44INSERT INTO tstmt(num) VALUES (@@session.pseudo_thread_id); 45SET @@foreign_key_checks= 0; 46INSERT INTO tstmt(num) VALUES (@@session.foreign_key_checks); 47SET @@foreign_key_checks= 1; 48INSERT INTO tstmt(num) VALUES (@@session.foreign_key_checks); 49SET @@sql_auto_is_null= 0; 50INSERT INTO tstmt(num) VALUES (@@session.sql_auto_is_null); 51SET @@sql_auto_is_null= 1; 52INSERT INTO tstmt(num) VALUES (@@session.sql_auto_is_null); 53SET @@unique_checks= 0; 54INSERT INTO tstmt(num) VALUES (@@session.unique_checks); 55SET @@unique_checks= 1; 56INSERT INTO tstmt(num) VALUES (@@session.unique_checks); 57SET @@auto_increment_increment= 11; 58INSERT INTO tstmt(num) VALUES (@@session.auto_increment_increment); 59SET @@auto_increment_increment= 19; 60INSERT INTO tstmt(num) VALUES (@@session.auto_increment_increment); 61SET @@auto_increment_offset= 13; 62INSERT INTO tstmt(num) VALUES (@@session.auto_increment_offset); 63SET @@auto_increment_offset= 17; 64INSERT INTO tstmt(num) VALUES (@@session.auto_increment_offset); 65SET @@auto_increment_increment= 1; 66SET @@auto_increment_offset= 1; 67SET @@character_set_client= 'cp1257'; 68INSERT INTO tstmt(text) VALUES (@@session.character_set_client); 69SET @@character_set_client= 'cp1256'; 70INSERT INTO tstmt(text) VALUES (@@session.character_set_client); 71SET @@collation_connection= 'cp1251_ukrainian_ci'; 72INSERT INTO tstmt(text) VALUES (@@session.collation_connection); 73INSERT INTO tstmt(text) VALUES (@@session.character_set_connection); 74SET @@collation_connection= 'cp1251_bulgarian_ci'; 75INSERT INTO tstmt(text) VALUES (@@session.collation_connection); 76INSERT INTO tstmt(text) VALUES (@@session.character_set_connection); 77SET @@collation_server= 'latin7_bin'; 78INSERT INTO tstmt(text) VALUES (@@session.collation_server); 79INSERT INTO tstmt(text) VALUES (@@session.character_set_server); 80SET @@collation_server= 'latin7_general_cs'; 81INSERT INTO tstmt(text) VALUES (@@session.collation_server); 82INSERT INTO tstmt(text) VALUES (@@session.character_set_server); 83SET @@time_zone= 'Europe/Moscow'; 84INSERT INTO tstmt(text) VALUES (@@session.time_zone); 85SET @@time_zone= 'Universal'; 86INSERT INTO tstmt(text) VALUES (@@session.time_zone); 87SET @@lc_time_names= 'sv_FI'; 88INSERT INTO tstmt(text) VALUES (@@session.lc_time_names); 89SET @@lc_time_names= 'no_NO'; 90INSERT INTO tstmt(text) VALUES (@@session.lc_time_names); 91SET @@collation_database= 'latin7_general_ci'; 92INSERT INTO tstmt(text) VALUES (@@session.collation_database); 93INSERT INTO tstmt(text) VALUES (@@session.character_set_database); 94SET @@collation_database= 'latin7_estonian_cs'; 95INSERT INTO tstmt(text) VALUES (@@session.collation_database); 96INSERT INTO tstmt(text) VALUES (@@session.character_set_database); 97SET @@timestamp= 47114711; 98INSERT INTO tstmt(text) VALUES (@@session.timestamp); 99SET @@timestamp= 47124712; 100INSERT INTO tstmt(text) VALUES (@@session.timestamp); 101SET @@last_insert_id= 1616; 102INSERT INTO tstmt(text) VALUES (@@session.last_insert_id); 103SET @@last_insert_id= 1717; 104INSERT INTO tstmt(text) VALUES (@@session.last_insert_id); 105==== Insert variables from a stored procedure ==== 106CREATE PROCEDURE proc() 107BEGIN 108SET @@pseudo_thread_id= 4712; 109INSERT INTO tproc(num) VALUES (@@session.pseudo_thread_id); 110SET @@pseudo_thread_id= 4713; 111INSERT INTO tproc(num) VALUES (@@session.pseudo_thread_id); 112SET @@foreign_key_checks= 0; 113INSERT INTO tproc(num) VALUES (@@session.foreign_key_checks); 114SET @@foreign_key_checks= 1; 115INSERT INTO tproc(num) VALUES (@@session.foreign_key_checks); 116SET @@sql_auto_is_null= 0; 117INSERT INTO tproc(num) VALUES (@@session.sql_auto_is_null); 118SET @@sql_auto_is_null= 1; 119INSERT INTO tproc(num) VALUES (@@session.sql_auto_is_null); 120SET @@unique_checks= 0; 121INSERT INTO tproc(num) VALUES (@@session.unique_checks); 122SET @@unique_checks= 1; 123INSERT INTO tproc(num) VALUES (@@session.unique_checks); 124SET @@auto_increment_increment= 11; 125INSERT INTO tproc(num) VALUES (@@session.auto_increment_increment); 126SET @@auto_increment_increment= 19; 127INSERT INTO tproc(num) VALUES (@@session.auto_increment_increment); 128SET @@auto_increment_offset= 13; 129INSERT INTO tproc(num) VALUES (@@session.auto_increment_offset); 130SET @@auto_increment_offset= 17; 131INSERT INTO tproc(num) VALUES (@@session.auto_increment_offset); 132# reset these as they affect the index column 133SET @@auto_increment_increment= 1; 134SET @@auto_increment_offset= 1; 135SET @@character_set_client= 'cp1257'; 136INSERT INTO tproc(text) VALUES (@@session.character_set_client); 137SET @@character_set_client= 'cp1256'; 138INSERT INTO tproc(text) VALUES (@@session.character_set_client); 139SET @@collation_connection= 'cp1251_ukrainian_ci'; 140INSERT INTO tproc(text) VALUES (@@session.collation_connection); 141INSERT INTO tproc(text) VALUES (@@session.character_set_connection); 142SET @@collation_connection= 'cp1251_bulgarian_ci'; 143INSERT INTO tproc(text) VALUES (@@session.collation_connection); 144INSERT INTO tproc(text) VALUES (@@session.character_set_connection); 145SET @@collation_server= 'latin7_bin'; 146INSERT INTO tproc(text) VALUES (@@session.collation_server); 147INSERT INTO tproc(text) VALUES (@@session.character_set_server); 148SET @@collation_server= 'latin7_general_cs'; 149INSERT INTO tproc(text) VALUES (@@session.collation_server); 150INSERT INTO tproc(text) VALUES (@@session.character_set_server); 151SET @@time_zone= 'Europe/Moscow'; 152INSERT INTO tproc(text) VALUES (@@session.time_zone); 153SET @@time_zone= 'Universal'; 154INSERT INTO tproc(text) VALUES (@@session.time_zone); 155SET @@lc_time_names= 'sv_FI'; 156INSERT INTO tproc(text) VALUES (@@session.lc_time_names); 157SET @@lc_time_names= 'no_NO'; 158INSERT INTO tproc(text) VALUES (@@session.lc_time_names); 159SET @@collation_database= 'latin7_general_ci'; 160INSERT INTO tproc(text) VALUES (@@session.collation_database); 161INSERT INTO tproc(text) VALUES (@@session.character_set_database); 162SET @@collation_database= 'latin7_estonian_cs'; 163INSERT INTO tproc(text) VALUES (@@session.collation_database); 164INSERT INTO tproc(text) VALUES (@@session.character_set_database); 165SET @@timestamp= 47114711; 166INSERT INTO tproc(text) VALUES (@@session.timestamp); 167SET @@timestamp= 47124712; 168INSERT INTO tproc(text) VALUES (@@session.timestamp); 169SET @@last_insert_id= 1616; 170INSERT INTO tproc(text) VALUES (@@session.last_insert_id); 171SET @@last_insert_id= 1717; 172INSERT INTO tproc(text) VALUES (@@session.last_insert_id); 173END| 174CALL proc(); 175==== Insert variables from a stored function ==== 176CREATE FUNCTION func() 177RETURNS INT 178BEGIN 179SET @@pseudo_thread_id= 4712; 180INSERT INTO tfunc(num) VALUES (@@session.pseudo_thread_id); 181SET @@pseudo_thread_id= 4713; 182INSERT INTO tfunc(num) VALUES (@@session.pseudo_thread_id); 183SET @@foreign_key_checks= 0; 184INSERT INTO tfunc(num) VALUES (@@session.foreign_key_checks); 185SET @@foreign_key_checks= 1; 186INSERT INTO tfunc(num) VALUES (@@session.foreign_key_checks); 187SET @@sql_auto_is_null= 0; 188INSERT INTO tfunc(num) VALUES (@@session.sql_auto_is_null); 189SET @@sql_auto_is_null= 1; 190INSERT INTO tfunc(num) VALUES (@@session.sql_auto_is_null); 191SET @@unique_checks= 0; 192INSERT INTO tfunc(num) VALUES (@@session.unique_checks); 193SET @@unique_checks= 1; 194INSERT INTO tfunc(num) VALUES (@@session.unique_checks); 195SET @@auto_increment_increment= 11; 196INSERT INTO tfunc(num) VALUES (@@session.auto_increment_increment); 197SET @@auto_increment_increment= 19; 198INSERT INTO tfunc(num) VALUES (@@session.auto_increment_increment); 199SET @@auto_increment_offset= 13; 200INSERT INTO tfunc(num) VALUES (@@session.auto_increment_offset); 201SET @@auto_increment_offset= 17; 202INSERT INTO tfunc(num) VALUES (@@session.auto_increment_offset); 203# reset these as they affect the index column 204SET @@auto_increment_increment= 1; 205SET @@auto_increment_offset= 1; 206SET @@character_set_client= 'cp1257'; 207INSERT INTO tfunc(text) VALUES (@@session.character_set_client); 208SET @@character_set_client= 'cp1256'; 209INSERT INTO tfunc(text) VALUES (@@session.character_set_client); 210SET @@collation_connection= 'cp1251_ukrainian_ci'; 211INSERT INTO tfunc(text) VALUES (@@session.collation_connection); 212INSERT INTO tfunc(text) VALUES (@@session.character_set_connection); 213SET @@collation_connection= 'cp1251_bulgarian_ci'; 214INSERT INTO tfunc(text) VALUES (@@session.collation_connection); 215INSERT INTO tfunc(text) VALUES (@@session.character_set_connection); 216SET @@collation_server= 'latin7_bin'; 217INSERT INTO tfunc(text) VALUES (@@session.collation_server); 218INSERT INTO tfunc(text) VALUES (@@session.character_set_server); 219SET @@collation_server= 'latin7_general_cs'; 220INSERT INTO tfunc(text) VALUES (@@session.collation_server); 221INSERT INTO tfunc(text) VALUES (@@session.character_set_server); 222SET @@time_zone= 'Europe/Moscow'; 223INSERT INTO tfunc(text) VALUES (@@session.time_zone); 224SET @@time_zone= 'Universal'; 225INSERT INTO tfunc(text) VALUES (@@session.time_zone); 226SET @@lc_time_names= 'sv_FI'; 227INSERT INTO tfunc(text) VALUES (@@session.lc_time_names); 228SET @@lc_time_names= 'no_NO'; 229INSERT INTO tfunc(text) VALUES (@@session.lc_time_names); 230SET @@collation_database= 'latin7_general_ci'; 231INSERT INTO tfunc(text) VALUES (@@session.collation_database); 232INSERT INTO tfunc(text) VALUES (@@session.character_set_database); 233SET @@collation_database= 'latin7_estonian_cs'; 234INSERT INTO tfunc(text) VALUES (@@session.collation_database); 235INSERT INTO tfunc(text) VALUES (@@session.character_set_database); 236SET @@timestamp= 47114711; 237INSERT INTO tfunc(text) VALUES (@@session.timestamp); 238SET @@timestamp= 47124712; 239INSERT INTO tfunc(text) VALUES (@@session.timestamp); 240SET @@last_insert_id= 1616; 241INSERT INTO tfunc(text) VALUES (@@session.last_insert_id); 242SET @@last_insert_id= 1717; 243INSERT INTO tfunc(text) VALUES (@@session.last_insert_id); 244RETURN 0; 245END| 246SELECT func(); 247func() 2480 249==== Insert variables from a trigger ==== 250CREATE TRIGGER trig 251BEFORE INSERT ON trigger_table 252FOR EACH ROW 253BEGIN 254SET @@pseudo_thread_id= 4712; 255INSERT INTO ttrig(num) VALUES (@@session.pseudo_thread_id); 256SET @@pseudo_thread_id= 4713; 257INSERT INTO ttrig(num) VALUES (@@session.pseudo_thread_id); 258SET @@foreign_key_checks= 0; 259INSERT INTO ttrig(num) VALUES (@@session.foreign_key_checks); 260SET @@foreign_key_checks= 1; 261INSERT INTO ttrig(num) VALUES (@@session.foreign_key_checks); 262SET @@sql_auto_is_null= 0; 263INSERT INTO ttrig(num) VALUES (@@session.sql_auto_is_null); 264SET @@sql_auto_is_null= 1; 265INSERT INTO ttrig(num) VALUES (@@session.sql_auto_is_null); 266SET @@unique_checks= 0; 267INSERT INTO ttrig(num) VALUES (@@session.unique_checks); 268SET @@unique_checks= 1; 269INSERT INTO ttrig(num) VALUES (@@session.unique_checks); 270SET @@auto_increment_increment= 11; 271INSERT INTO ttrig(num) VALUES (@@session.auto_increment_increment); 272SET @@auto_increment_increment= 19; 273INSERT INTO ttrig(num) VALUES (@@session.auto_increment_increment); 274SET @@auto_increment_offset= 13; 275INSERT INTO ttrig(num) VALUES (@@session.auto_increment_offset); 276SET @@auto_increment_offset= 17; 277INSERT INTO ttrig(num) VALUES (@@session.auto_increment_offset); 278# reset these as they affect the index column 279SET @@auto_increment_increment= 1; 280SET @@auto_increment_offset= 1; 281SET @@character_set_client= 'cp1257'; 282INSERT INTO ttrig(text) VALUES (@@session.character_set_client); 283SET @@character_set_client= 'cp1256'; 284INSERT INTO ttrig(text) VALUES (@@session.character_set_client); 285SET @@collation_connection= 'cp1251_ukrainian_ci'; 286INSERT INTO ttrig(text) VALUES (@@session.collation_connection); 287INSERT INTO ttrig(text) VALUES (@@session.character_set_connection); 288SET @@collation_connection= 'cp1251_bulgarian_ci'; 289INSERT INTO ttrig(text) VALUES (@@session.collation_connection); 290INSERT INTO ttrig(text) VALUES (@@session.character_set_connection); 291SET @@collation_server= 'latin7_bin'; 292INSERT INTO ttrig(text) VALUES (@@session.collation_server); 293INSERT INTO ttrig(text) VALUES (@@session.character_set_server); 294SET @@collation_server= 'latin7_general_cs'; 295INSERT INTO ttrig(text) VALUES (@@session.collation_server); 296INSERT INTO ttrig(text) VALUES (@@session.character_set_server); 297SET @@time_zone= 'Europe/Moscow'; 298INSERT INTO ttrig(text) VALUES (@@session.time_zone); 299SET @@time_zone= 'Universal'; 300INSERT INTO ttrig(text) VALUES (@@session.time_zone); 301SET @@lc_time_names= 'sv_FI'; 302INSERT INTO ttrig(text) VALUES (@@session.lc_time_names); 303SET @@lc_time_names= 'no_NO'; 304INSERT INTO ttrig(text) VALUES (@@session.lc_time_names); 305SET @@collation_database= 'latin7_general_ci'; 306INSERT INTO ttrig(text) VALUES (@@session.collation_database); 307INSERT INTO ttrig(text) VALUES (@@session.character_set_database); 308SET @@collation_database= 'latin7_estonian_cs'; 309INSERT INTO ttrig(text) VALUES (@@session.collation_database); 310INSERT INTO ttrig(text) VALUES (@@session.character_set_database); 311SET @@timestamp= 47114711; 312INSERT INTO ttrig(text) VALUES (@@session.timestamp); 313SET @@timestamp= 47124712; 314INSERT INTO ttrig(text) VALUES (@@session.timestamp); 315SET @@last_insert_id= 1616; 316INSERT INTO ttrig(text) VALUES (@@session.last_insert_id); 317SET @@last_insert_id= 1717; 318INSERT INTO ttrig(text) VALUES (@@session.last_insert_id); 319END| 320INSERT INTO trigger_table VALUES ('bye.'); 321==== Insert variables from a prepared statement ==== 322PREPARE p1 FROM 'SET @@pseudo_thread_id= 4712'; 323PREPARE p2 FROM 'INSERT INTO tprep(num) VALUES (@@session.pseudo_thread_id)'; 324PREPARE p3 FROM 'SET @@pseudo_thread_id= 4713'; 325PREPARE p4 FROM 'INSERT INTO tprep(num) VALUES (@@session.pseudo_thread_id)'; 326PREPARE p5 FROM 'SET @@foreign_key_checks= 0'; 327PREPARE p6 FROM 'INSERT INTO tprep(num) VALUES (@@session.foreign_key_checks)'; 328PREPARE p7 FROM 'SET @@foreign_key_checks= 1'; 329PREPARE p8 FROM 'INSERT INTO tprep(num) VALUES (@@session.foreign_key_checks)'; 330PREPARE p9 FROM 'SET @@sql_auto_is_null= 0'; 331PREPARE p10 FROM 'INSERT INTO tprep(num) VALUES (@@session.sql_auto_is_null)'; 332PREPARE p11 FROM 'SET @@sql_auto_is_null= 1'; 333PREPARE p12 FROM 'INSERT INTO tprep(num) VALUES (@@session.sql_auto_is_null)'; 334PREPARE p13 FROM 'SET @@unique_checks= 0'; 335PREPARE p14 FROM 'INSERT INTO tprep(num) VALUES (@@session.unique_checks)'; 336PREPARE p15 FROM 'SET @@unique_checks= 1'; 337PREPARE p16 FROM 'INSERT INTO tprep(num) VALUES (@@session.unique_checks)'; 338PREPARE p17 FROM 'SET @@auto_increment_increment= 11'; 339PREPARE p18 FROM 'INSERT INTO tprep(num) VALUES (@@session.auto_increment_increment)'; 340PREPARE p19 FROM 'SET @@auto_increment_increment= 19'; 341PREPARE p20 FROM 'INSERT INTO tprep(num) VALUES (@@session.auto_increment_increment)'; 342PREPARE p21 FROM 'SET @@auto_increment_offset= 13'; 343PREPARE p22 FROM 'INSERT INTO tprep(num) VALUES (@@session.auto_increment_offset)'; 344PREPARE p23 FROM 'SET @@auto_increment_offset= 17'; 345PREPARE p24 FROM 'INSERT INTO tprep(num) VALUES (@@session.auto_increment_offset)'; 346PREPARE p25 FROM 'SET @@auto_increment_increment= 1'; 347PREPARE p26 FROM 'SET @@auto_increment_offset= 1'; 348PREPARE p27 FROM 'SET @@character_set_client= \'cp1257\''; 349PREPARE p28 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_client)'; 350PREPARE p29 FROM 'SET @@character_set_client= \'cp1256\''; 351PREPARE p30 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_client)'; 352PREPARE p31 FROM 'SET @@collation_connection= \'cp1251_ukrainian_ci\''; 353PREPARE p32 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_connection)'; 354PREPARE p33 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_connection)'; 355PREPARE p34 FROM 'SET @@collation_connection= \'cp1251_bulgarian_ci\''; 356PREPARE p35 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_connection)'; 357PREPARE p36 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_connection)'; 358PREPARE p37 FROM 'SET @@collation_server= \'latin7_bin\''; 359PREPARE p38 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_server)'; 360PREPARE p39 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_server)'; 361PREPARE p40 FROM 'SET @@collation_server= \'latin7_general_cs\''; 362PREPARE p41 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_server)'; 363PREPARE p42 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_server)'; 364PREPARE p43 FROM 'SET @@time_zone= \'Europe/Moscow\''; 365PREPARE p44 FROM 'INSERT INTO tprep(text) VALUES (@@session.time_zone)'; 366PREPARE p45 FROM 'SET @@time_zone= \'Universal\''; 367PREPARE p46 FROM 'INSERT INTO tprep(text) VALUES (@@session.time_zone)'; 368PREPARE p47 FROM 'SET @@lc_time_names= \'sv_FI\''; 369PREPARE p48 FROM 'INSERT INTO tprep(text) VALUES (@@session.lc_time_names)'; 370PREPARE p49 FROM 'SET @@lc_time_names= \'no_NO\''; 371PREPARE p50 FROM 'INSERT INTO tprep(text) VALUES (@@session.lc_time_names)'; 372PREPARE p51 FROM 'SET @@collation_database= \'latin7_general_ci\''; 373PREPARE p52 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_database)'; 374PREPARE p53 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_database)'; 375PREPARE p54 FROM 'SET @@collation_database= \'latin7_estonian_cs\''; 376PREPARE p55 FROM 'INSERT INTO tprep(text) VALUES (@@session.collation_database)'; 377PREPARE p56 FROM 'INSERT INTO tprep(text) VALUES (@@session.character_set_database)'; 378PREPARE p57 FROM 'SET @@timestamp= 47114711'; 379PREPARE p58 FROM 'INSERT INTO tprep(text) VALUES (@@session.timestamp)'; 380PREPARE p59 FROM 'SET @@timestamp= 47124712'; 381PREPARE p60 FROM 'INSERT INTO tprep(text) VALUES (@@session.timestamp)'; 382PREPARE p61 FROM 'SET @@last_insert_id= 1616'; 383PREPARE p62 FROM 'INSERT INTO tprep(text) VALUES (@@session.last_insert_id)'; 384PREPARE p63 FROM 'SET @@last_insert_id= 1717'; 385PREPARE p64 FROM 'INSERT INTO tprep(text) VALUES (@@session.last_insert_id)'; 386EXECUTE p1; 387EXECUTE p2; 388EXECUTE p3; 389EXECUTE p4; 390EXECUTE p5; 391EXECUTE p6; 392EXECUTE p7; 393EXECUTE p8; 394EXECUTE p9; 395EXECUTE p10; 396EXECUTE p11; 397EXECUTE p12; 398EXECUTE p13; 399EXECUTE p14; 400EXECUTE p15; 401EXECUTE p16; 402EXECUTE p17; 403EXECUTE p18; 404EXECUTE p19; 405EXECUTE p20; 406EXECUTE p21; 407EXECUTE p22; 408EXECUTE p23; 409EXECUTE p24; 410EXECUTE p25; 411EXECUTE p26; 412EXECUTE p27; 413EXECUTE p28; 414EXECUTE p29; 415EXECUTE p30; 416EXECUTE p31; 417EXECUTE p32; 418EXECUTE p33; 419EXECUTE p34; 420EXECUTE p35; 421EXECUTE p36; 422EXECUTE p37; 423EXECUTE p38; 424EXECUTE p39; 425EXECUTE p40; 426EXECUTE p41; 427EXECUTE p42; 428EXECUTE p43; 429EXECUTE p44; 430EXECUTE p45; 431EXECUTE p46; 432EXECUTE p47; 433EXECUTE p48; 434EXECUTE p49; 435EXECUTE p50; 436EXECUTE p51; 437EXECUTE p52; 438EXECUTE p53; 439EXECUTE p54; 440EXECUTE p55; 441EXECUTE p56; 442EXECUTE p57; 443EXECUTE p58; 444EXECUTE p59; 445EXECUTE p60; 446EXECUTE p61; 447EXECUTE p62; 448EXECUTE p63; 449EXECUTE p64; 450connection slave; 451connection master; 452==== Results ==== 453SELECT * FROM tstmt ORDER BY id; 454id num text 4551 4712 NULL 4562 4713 NULL 4573 0 NULL 4584 1 NULL 4595 0 NULL 4606 1 NULL 4617 0 NULL 4628 1 NULL 46312 11 NULL 46420 19 NULL 46532 13 NULL 46636 17 NULL 46737 NULL cp1257 46838 NULL cp1256 46939 NULL cp1251_ukrainian_ci 47040 NULL cp1251 47141 NULL cp1251_bulgarian_ci 47242 NULL cp1251 47343 NULL latin7_bin 47444 NULL latin7 47545 NULL latin7_general_cs 47646 NULL latin7 47747 NULL Europe/Moscow 47848 NULL Universal 47949 NULL sv_FI 48050 NULL no_NO 48151 NULL latin7_general_ci 48252 NULL latin7 48353 NULL latin7_estonian_cs 48454 NULL latin7 48555 NULL 47114711 48656 NULL 47124712 48757 NULL 1616 48858 NULL 1717 489connection slave; 490include/diff_tables.inc [master:tstmt, master:tproc, master:tfunc, master:ttrig, master:tprep, slave:tstmt, slave:tproc, slave:tfunc, slave:ttrig, slave:tprep] 491==== Clean up ==== 492connection master; 493DROP PROCEDURE proc; 494DROP FUNCTION func; 495DROP TRIGGER trig; 496DROP TABLE tstmt, tproc, tfunc, ttrig, tprep, trigger_table; 497SET @@global.auto_increment_increment= @m_auto_increment_increment; 498SET @@global.auto_increment_offset= @m_auto_increment_offset; 499SET @@global.character_set_client= @m_character_set_client; 500SET @@global.collation_connection= @m_collation_connection; 501SET @@global.collation_server= @m_collation_server; 502SET @@global.time_zone= @m_time_zone; 503SET @@global.lc_time_names= @m_lc_time_names; 504SET @@global.collation_database= @m_collation_database; 505connection slave; 506SET @@global.auto_increment_increment= @s_auto_increment_increment; 507SET @@global.auto_increment_offset= @s_auto_increment_offset; 508SET @@global.character_set_client= @s_character_set_client; 509SET @@global.collation_connection= @s_collation_connection; 510SET @@global.collation_server= @s_collation_server; 511SET @@global.time_zone= @s_time_zone; 512SET @@global.lc_time_names= @s_lc_time_names; 513SET @@global.collation_database= @s_collation_database; 514connection master; 515connection slave; 516include/rpl_end.inc 517