PageRenderTime 4ms CodeModel.GetById 1ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/lock1.q

#
text | 29 lines | 26 code | 3 blank | 0 comment | 0 complexity | 6ad819e43c7b94e6987f3218c9897ab3 MD5 | raw file
 1drop table tstsrc;
 2create table tstsrc like src;
 3insert overwrite table tstsrc select key, value from src;
 4
 5SHOW LOCKS;
 6SHOW LOCKS tstsrc;
 7
 8LOCK TABLE tstsrc shared;
 9SHOW LOCKS;
10SHOW LOCKS tstsrc;
11SHOW LOCKS tstsrc extended;
12
13UNLOCK TABLE tstsrc;
14SHOW LOCKS;
15SHOW LOCKS extended;
16SHOW LOCKS tstsrc;
17lock TABLE tstsrc SHARED;
18SHOW LOCKS;
19SHOW LOCKS extended;
20SHOW LOCKS tstsrc;
21LOCK TABLE tstsrc SHARED;
22SHOW LOCKS;
23SHOW LOCKS extended;
24SHOW LOCKS tstsrc;
25UNLOCK TABLE tstsrc;
26SHOW LOCKS;
27SHOW LOCKS extended;
28SHOW LOCKS tstsrc;
29drop table tstsrc;