← Back to branch summary

~skinny.moey/drizzle/innodb-replication

« back to all changes in this revision

Viewing changes to plugin/user_locks/tests/r/get_locks.result

  • Committer: Brian Aker
  • Date: 2010-11-08 22:35:57 UTC
  • mfrom: (1802.1.114 trunk)
  • Revision ID: brian@tangent.org-20101108223557-w3xzwp9hjjtjhtc1
Merge in trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/user_locks/tests/r/get_locks.result
 
1
SELECT get_locks("foo", "foo2", "foo3");
 
2
get_locks("foo", "foo2", "foo3")
 
3
1
 
4
SELECT if ((is_used_lock("foo") = CONNECTION_ID()), "YES", "NO");
 
5
if ((is_used_lock("foo") = CONNECTION_ID()), "YES", "NO")
 
6
YES
 
7
SELECT if ((is_used_lock("foo2") = CONNECTION_ID()), "YES", "NO");
 
8
if ((is_used_lock("foo2") = CONNECTION_ID()), "YES", "NO")
 
9
YES
 
10
SELECT if ((is_used_lock("foo3") = CONNECTION_ID()), "YES", "NO");
 
11
if ((is_used_lock("foo3") = CONNECTION_ID()), "YES", "NO")
 
12
YES
 
13
SELECT release_lock("foo2");
 
14
release_lock("foo2")
 
15
1
 
16
SELECT if ((is_used_lock("foo") = CONNECTION_ID()), "YES", "NO");
 
17
if ((is_used_lock("foo") = CONNECTION_ID()), "YES", "NO")
 
18
YES
 
19
SELECT if ((is_used_lock("foo2") = CONNECTION_ID()), "YES", "NO");
 
20
if ((is_used_lock("foo2") = CONNECTION_ID()), "YES", "NO")
 
21
NO
 
22
SELECT if ((is_used_lock("foo3") = CONNECTION_ID()), "YES", "NO");
 
23
if ((is_used_lock("foo3") = CONNECTION_ID()), "YES", "NO")
 
24
YES
 
25
SELECT release_locks();
 
26
release_locks()
 
27
2
 
28
SELECT if ((is_used_lock("foo") = CONNECTION_ID()), "YES", "NO");
 
29
if ((is_used_lock("foo") = CONNECTION_ID()), "YES", "NO")
 
30
NO
 
31
SELECT if ((is_used_lock("foo2") = CONNECTION_ID()), "YES", "NO");
 
32
if ((is_used_lock("foo2") = CONNECTION_ID()), "YES", "NO")
 
33
NO
 
34
SELECT if ((is_used_lock("foo3") = CONNECTION_ID()), "YES", "NO");
 
35
if ((is_used_lock("foo3") = CONNECTION_ID()), "YES", "NO")
 
36
NO