diff options
author | Jon Olav Hauglid <jon.hauglid@sun.com> | 2010-06-25 09:07:18 +0200 |
---|---|---|
committer | Jon Olav Hauglid <jon.hauglid@sun.com> | 2010-06-25 09:07:18 +0200 |
commit | 9b5d1d98da9c3d1e216e43849ac05527852ec410 (patch) | |
tree | 269cb4227730a6c31ca7b28b6f7682c326f6bf86 /mysql-test/r/innodb_mysql_sync.result | |
parent | a1c6a39a1320ec2cb1ec816543873513a97ee0a5 (diff) | |
download | mariadb-git-9b5d1d98da9c3d1e216e43849ac05527852ec410.tar.gz |
Bug #53757 assert in mysql_truncate_by_delete
The assert was triggered if a connection executing TRUNCATE
on a InnoDB table was killed during open_tables.
This bug was fixed in the scope of Bug #45643
"InnoDB does not support replication of TRUNCATE TABLE".
This patch adds test coverage to innodb_mysql_sync.test.
Diffstat (limited to 'mysql-test/r/innodb_mysql_sync.result')
-rw-r--r-- | mysql-test/r/innodb_mysql_sync.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/innodb_mysql_sync.result b/mysql-test/r/innodb_mysql_sync.result index 0e75e62b13a..43a98829d4e 100644 --- a/mysql-test/r/innodb_mysql_sync.result +++ b/mysql-test/r/innodb_mysql_sync.result @@ -48,3 +48,21 @@ Warnings: Error 1146 Table 'test.t1' doesn't exist # Connection default SET DEBUG_SYNC= "RESET"; +# +# Bug#53757 assert in mysql_truncate_by_delete +# +DROP TABLE IF EXISTS t1, t2; +CREATE TABLE t1(a INT) Engine=InnoDB; +CREATE TABLE t2(id INT); +INSERT INTO t1 VALUES (1), (2); +INSERT INTO t2 VALUES(connection_id()); +SET DEBUG_SYNC= "open_and_process_table SIGNAL opening WAIT_FOR killed"; +# Sending: (not reaped since connection is killed later) +TRUNCATE t1; +SET DEBUG_SYNC= "now WAIT_FOR opening"; +SELECT ((@id := id) - id) FROM t2; +((@id := id) - id) +0 +KILL @id; +SET DEBUG_SYNC= "now SIGNAL killed"; +DROP TABLE t1, t2; |