diff options
author | Michael Widenius <monty@mariadb.org> | 2018-03-09 14:05:35 +0200 |
---|---|---|
committer | Monty <monty@mariadb.org> | 2018-03-29 13:59:44 +0300 |
commit | a7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch) | |
tree | 70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/main/truncate_coverage.result | |
parent | ab1941266c59a19703a74b5593cf3f508a5752d7 (diff) | |
download | mariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz |
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/main/truncate_coverage.result')
-rw-r--r-- | mysql-test/main/truncate_coverage.result | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/mysql-test/main/truncate_coverage.result b/mysql-test/main/truncate_coverage.result new file mode 100644 index 00000000000..078de1ef3ab --- /dev/null +++ b/mysql-test/main/truncate_coverage.result @@ -0,0 +1,56 @@ +SET DEBUG_SYNC='RESET'; +DROP TABLE IF EXISTS t1; +# +# Bug#20667 - Truncate table fails for a write locked table +# +CREATE TABLE t1 (c1 INT); +INSERT INTO t1 VALUES (1); +connect con1, localhost, root,,; +START TRANSACTION; +INSERT INTO t1 VALUES (2); +connection default; +SET DEBUG_SYNC='mdl_acquire_lock_wait SIGNAL waiting'; +TRUNCATE TABLE t1; +connection con1; +SET DEBUG_SYNC='now WAIT_FOR waiting'; +KILL QUERY @id; +connection default; +ERROR 70100: Query execution was interrupted +connection con1; +# Release SW lock by committing transaction. +COMMIT; +disconnect con1; +connection default; +UNLOCK TABLES; +DROP TABLE t1; +SET DEBUG_SYNC='RESET'; +# +# Bug#57659 Segfault in Query_cache::invalidate_data for TRUNCATE TABLE +# +# Note that this test case only reproduces the problem +# when it is run with valgrind. +DROP TABLE IF EXISTS t1, m1; +CREATE TABLE t1(a INT) engine=memory; +CREATE TABLE m1(a INT) engine=merge UNION(t1); +connect con2, localhost, root; +connect con1, localhost, root; +SET DEBUG_SYNC= 'open_tables_after_open_and_process_table SIGNAL opened WAIT_FOR dropped'; +# Sending: +TRUNCATE TABLE m1; +connection con2; +SET DEBUG_SYNC= 'now WAIT_FOR opened'; +# Sending: +FLUSH TABLES; +connection default; +# Waiting for FLUSH TABLES to be blocked. +SET DEBUG_SYNC= 'now SIGNAL dropped'; +connection con1; +# Reaping: TRUNCATE TABLE m1 +ERROR HY000: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist +disconnect con1; +connection con2; +# Reaping: FLUSH TABLES +disconnect con2; +connection default; +SET DEBUG_SYNC= 'RESET'; +DROP TABLE m1, t1; |