← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/user_locks/tests/t/user_locks_table.test

  • Committer: Brian Aker
  • Date: 2010-12-15 21:28:47 UTC
  • mto: This revision was merged to the branch mainline in revision 1998.
  • Revision ID: brian@tangent.org-20101215212847-c52kuprsbrcm8sfk
Update name usage for user defined objects.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/user_locks/tests/t/user_locks_table.test
4
4
SELECT if ((is_used_lock("foo2") = CONNECTION_ID()), "YES", "NO");
5
5
SELECT if ((is_used_lock("foo3") = CONNECTION_ID()), "YES", "NO");
6
6
--sorted_result
7
 
SELECT USER_LOCK_NAME FROM DATA_DICTIONARY.USER_LOCKS;
 
7
SELECT USER_LOCK_NAME FROM DATA_DICTIONARY.USER_DEFINED_LOCKS;
8
8
 
9
9
SELECT release_lock("foo2");
10
10
SELECT if ((is_used_lock("foo") = CONNECTION_ID()), "YES", "NO");
11
11
SELECT if ((is_used_lock("foo2") = CONNECTION_ID()), "YES", "NO");
12
12
SELECT if ((is_used_lock("foo3") = CONNECTION_ID()), "YES", "NO");
13
13
--sorted_result
14
 
SELECT USER_LOCK_NAME FROM DATA_DICTIONARY.USER_LOCKS;
 
14
SELECT USER_LOCK_NAME FROM DATA_DICTIONARY.USER_DEFINED_LOCKS;
15
15
 
16
16
SELECT release_locks();
17
17
SELECT if ((is_used_lock("foo") = CONNECTION_ID()), "YES", "NO");
18
18
SELECT if ((is_used_lock("foo2") = CONNECTION_ID()), "YES", "NO");
19
19
SELECT if ((is_used_lock("foo3") = CONNECTION_ID()), "YES", "NO");
20
20
--sorted_result
21
 
SELECT USER_LOCK_NAME FROM DATA_DICTIONARY.USER_LOCKS;
 
21
SELECT USER_LOCK_NAME FROM DATA_DICTIONARY.USER_DEFINED_LOCKS;