← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/merge-big.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/merge-big.result
1
 
drop table if exists t1,t2,t3,t4,t5,t6;
2
 
#
3
 
# Bug#26379 - Combination of FLUSH TABLE and REPAIR TABLE
4
 
#             corrupts a MERGE table
5
 
# Problem #3
6
 
#
7
 
CREATE TABLE t1 (c1 INT) ENGINE= MyISAM;
8
 
LOCK TABLE t1 WRITE;
9
 
# connection con1
10
 
SET SESSION debug="+d,sleep_open_and_lock_after_open";
11
 
INSERT INTO t1 VALUES (1);
12
 
# connection default
13
 
# Let INSERT go into thr_multi_lock().
14
 
# Kick INSERT out of thr_multi_lock().
15
 
FLUSH TABLES;
16
 
# Let INSERT go through open_tables() where it sleeps.
17
 
# Unlock and close table and wait for con1 to close too.
18
 
FLUSH TABLES;
19
 
# This should give no result.
20
 
SELECT * FROM t1;
21
 
c1
22
 
UNLOCK TABLES;
23
 
# connection con1
24
 
SET SESSION debug="-d,sleep_open_and_lock_after_open";
25
 
# connection default
26
 
DROP TABLE t1;