summaryrefslogtreecommitdiff
path: root/storage/spider/mysql-test/spider/bugfix/r/self_reference.result
blob: 7017ca39e0698a47058fb92ab9d8e13ad6048d6d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
for master_1
for child2
for child3
connection master_1;
set @old_spider_internal_lock_wait_timeout= @@spider_internal_lock_wait_timeout;
set global spider_internal_lock_wait_timeout= 0;

this test is for MDEV-6268

drop and create databases
connection master_1;
CREATE DATABASE auto_test_local;
USE auto_test_local;

create table
connection master_1;
CREATE TABLE tbl_a (
pkey int NOT NULL,
PRIMARY KEY (pkey)
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1

select test 1
connection master_1;
SELECT pkey FROM tbl_a;
ERROR HY000: Internal lock wait timeout when getting a table status information

deinit
connection master_1;
DROP DATABASE IF EXISTS auto_test_local;
connection master_1;
set global spider_internal_lock_wait_timeout= @old_spider_internal_lock_wait_timeout;
for master_1
for child2
for child3

end of test