← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/r/lock_sync.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/lock_sync.result
629
629
drop procedure p2;
630
630
drop table t1, t2, t3, t4, t5, te;
631
631
set @@global.concurrent_insert= @old_concurrent_insert;
 
632
#
 
633
# Bug#11763784 56541: ASSERTION TABLE->DB_STAT FAILED IN
 
634
#                     SQL_BASE.CC::OPEN_TABLE() DURING I_S Q
 
635
#
 
636
DROP TABLE IF EXISTS t1;
 
637
CREATE TABLE t1(a int);
 
638
INSERT INTO t1 VALUES (1), (2);
 
639
CREATE TRIGGER t1_bi BEFORE INSERT ON t1 FOR EACH ROW BEGIN END;
 
640
# Connection con2
 
641
SET DEBUG_SYNC= 'before_open_in_get_all_tables SIGNAL is_waits WAIT_FOR is_cont';
 
642
# Sending:
 
643
SELECT * FROM information_schema.table_constraints JOIN t1 ON table_name = a;
 
644
# Connection con1
 
645
SET DEBUG_SYNC= 'now WAIT_FOR is_waits';
 
646
# Sending:
 
647
DROP TRIGGER t1_bi;
 
648
# Connection default
 
649
# Wait until DROP TRIGGER is blocked, waiting for t1
 
650
SET DEBUG_SYNC= 'now SIGNAL is_cont';
 
651
# Connection con2
 
652
# Reaping SELECT * FROM information_schema.table_constraints JOIN t1...
 
653
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_SCHEMA    TABLE_NAME      CONSTRAINT_TYPE a
 
654
# Connection con1
 
655
# Reaping DROP TRIGGER t1_bi
 
656
# Connection default
 
657
DROP TABLE t1;
 
658
SET DEBUG_SYNC= 'RESET';