~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

• browse files at revision 1841.1.7
• compare with another revision
• compare with revision 2165.1.3
• download diff
• download tarball
• view history from revision 1841.1.7

Show diffs side-by-side

added

removed

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

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1