~dshrews/drizzle/bug673105

« 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-16 03:55:56 UTC
  • mfrom: (1996.1.2 build-n-staging)
  • Revision ID: brian@tangent.org-20101216035556-dwkzlwvs45lhdnqe
1) Rename of tables to meet common naming.
2) moved "crash" to be in a debug plugin.

Show diffs side-by-side

added added

removed removed

Lines of Context:
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;