← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-11-12 12:26:01 UTC
  • mfrom: (1.1.1 upstream)
  • mto: This revision was merged to the branch mainline in revision 3.
  • Revision ID: james.westby@ubuntu.com-20101112122601-myppfj3tfmlkccuq
Tags: upstream-2010.11.03
Import upstream version 2010.11.03

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/user_locks/tests/r/get_lock.result
 
1
SELECT get_lock("foo");
 
2
get_lock("foo")
 
3
1
 
4
SELECT release_lock("foo");
 
5
release_lock("foo")
 
6
1
 
7
SELECT get_lock("foo", 1);
 
8
get_lock("foo", 1)
 
9
1
 
10
SELECT release_lock("foo");
 
11
release_lock("foo")
 
12
1
 
13
SELECT get_lock("foo", 10);
 
14
get_lock("foo", 10)
 
15
1
 
16
SELECT release_lock("foo");
 
17
release_lock("foo")
 
18
1
 
19
set @lock_name= "new_name";
 
20
SELECT get_lock(@lock_name);
 
21
get_lock(@lock_name)
 
22
1
 
23
SELECT if ((is_used_lock(@lock_name) = CONNECTION_ID()), "YES", "NO");
 
24
if ((is_used_lock(@lock_name) = CONNECTION_ID()), "YES", "NO")
 
25
YES
 
26
SELECT release_lock(@lock_name);
 
27
release_lock(@lock_name)
 
28
1