summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/flush_table.result
blob: c56d63bd84933c37f3f61912cf269cb7ef97518c (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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
drop table if exists t1,t2;
create table t1 (a int not null auto_increment primary key);
insert into t1 values(0);
lock table t1 read;
flush table t1;
ERROR HY000: Table 't1' was locked with a READ lock and can't be updated
unlock tables;
lock table t1 write;
flush table t1;
check table t1;
Table	Op	Msg_type	Msg_text
test.t1	check	status	OK
unlock tables;
lock table t1 write;
connect  locker,localhost,root,,test;
connection locker;
lock table t1 read;
connection default;
flush table t1;
select * from t1;
a
1
unlock tables;
connection locker;
unlock tables;
connection default;
lock table t1 write;
connection locker;
lock table t1 write;
connection default;
flush table t1;
select * from t1;
a
1
unlock tables;
connection locker;
unlock tables;
select * from t1;
a
1
connection default;
drop table t1;
disconnect locker;
create table t1(table_id char(20) primary key);
create table t2(table_id char(20) primary key);
insert into t1 values ('test.t1');
insert into t1 values ('');
insert into t2 values ('test.t2');
insert into t2 values ('');
handler t1 open as a1;
handler t1 open as a2;
handler t2 open;
handler a1 read first limit 9;
table_id
test.t1

handler a2 read first limit 9;
table_id
test.t1

handler t2 read first limit 9;
table_id
test.t2

flush tables;
handler a1 read first limit 9;
table_id
test.t1

handler a2 read first limit 9;
table_id
test.t1

handler t2 read first limit 9;
table_id
test.t2

handler t1 open as a1;
ERROR 42000: Not unique table/alias: 'a1'
handler t1 open as a2;
ERROR 42000: Not unique table/alias: 'a2'
handler t2 open;
ERROR 42000: Not unique table/alias: 't2'
handler a1 read first limit 9;
table_id
test.t1

handler a2 read first limit 9;
table_id
test.t1

handler t2 read first limit 9;
table_id
test.t2

flush table t1;
handler a1 read first limit 9;
table_id
test.t1

handler a2 read first limit 9;
table_id
test.t1

handler t2 read first limit 9;
table_id
test.t2

flush table t2;
handler t2 close;
drop table t1;
drop table t2;
create table t1(table_id char(20) primary key);
insert into t1 values ('Record-01');
insert into t1 values ('Record-02');
insert into t1 values ('Record-03');
insert into t1 values ('Record-04');
insert into t1 values ('Record-05');
handler t1 open;
handler t1 read first limit 1;
table_id
Record-01
handler t1 read next limit 1;
table_id
Record-02
handler t1 read next limit 1;
table_id
Record-03
flush table t1;
handler t1 read next limit 1;
table_id
Record-01
handler t1 read next limit 1;
table_id
Record-02
handler t1 close;
drop table t1;
FLUSH TABLES WITH READ LOCK ;
FLUSH TABLES WITH READ LOCK ;
UNLOCK TABLES;