532
532
ROLLBACK /* added by mysqlbinlog */;
533
533
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
535
# Test if the 'BEGIN', 'ROLLBACK' and 'COMMIT' are output if the database specified is not exist
535
# Test if the 'BEGIN', 'ROLLBACK' and 'COMMIT' are output if the database specified does not exist
536
536
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
537
537
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
565
565
# End of log file
566
566
ROLLBACK /* added by mysqlbinlog */;
567
567
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
569
# Test if the 'SAVEPOINT', 'ROLLBACK TO' are output if the database specified exists
570
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
571
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
573
SET TIMESTAMP=1266652094/*!*/;
574
SET @@session.pseudo_thread_id=999999999/*!*/;
575
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
576
SET @@session.sql_mode=0/*!*/;
577
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
578
/*!\C latin1 *//*!*/;
579
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
580
SET @@session.lc_time_names=0/*!*/;
581
SET @@session.collation_database=DEFAULT/*!*/;
585
SET TIMESTAMP=1266652094/*!*/;
586
SavePoint mixed_cases
589
SET TIMESTAMP=1266652094/*!*/;
590
INSERT INTO db1.t2 VALUES("in savepoint mixed_cases")
592
SET TIMESTAMP=1266652094/*!*/;
593
INSERT INTO db1.t1 VALUES(40)
596
SET TIMESTAMP=1266652094/*!*/;
597
ROLLBACK TO mixed_cases
600
SET TIMESTAMP=1266652094/*!*/;
601
INSERT INTO db1.t2 VALUES("after rollback to")
603
SET TIMESTAMP=1266652094/*!*/;
604
INSERT INTO db1.t1 VALUES(50)
609
ROLLBACK /* added by mysqlbinlog */;
610
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
612
# Test if the 'SAVEPOINT', 'ROLLBACK TO' are output if the database specified does not exist
613
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
614
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
616
SET TIMESTAMP=1266652094/*!*/;
617
SET @@session.pseudo_thread_id=999999999/*!*/;
618
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
619
SET @@session.sql_mode=0/*!*/;
620
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
621
/*!\C latin1 *//*!*/;
622
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
623
SET @@session.lc_time_names=0/*!*/;
624
SET @@session.collation_database=DEFAULT/*!*/;
628
SET TIMESTAMP=1266652094/*!*/;
629
SavePoint mixed_cases
631
SET TIMESTAMP=1266652094/*!*/;
632
ROLLBACK TO mixed_cases
637
ROLLBACK /* added by mysqlbinlog */;
638
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;