~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-11-23 09:35:51 UTC
  • mfrom: (1933.2.13 catalogs)
  • Revision ID: brian@tangent.org-20101123093551-l5m7zhz3m5c4wmlk
Merge in changes for barriers (update for kill, etc).

Show diffs side-by-side

added added

removed removed

Lines of Context:
5
5
SELECT USER_NAME, USER_LOCK_NAME FROM DATA_DICTIONARY.USER_LOCKS ORDER BY USER_LOCK_NAME, USER_NAME;
6
6
CREATE TABLE lock_state (a int);
7
7
EXECUTE "INSERT INTO lock_state SELECT GET_LOCK(\"mine\", 20)" CONCURRENT;
8
 
#SELECT USER  FROM DATA_DICTIONARY.PROCESSLIST;
9
 
# This should have zero rows in it
10
 
#SELECT count(*) FROM lock_state;
11
8
SELECT RELEASE_LOCK(@LOCK);
12
9
DROP TABLE lock_state;