~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Lee Bieber
  • Date: 2010-11-14 05:18:07 UTC
  • mfrom: (1921.4.12 catalogs)
  • Revision ID: kalebral@gmail.com-20101114051807-p69h40jbsn1byf84
Merge Brian - add execute with no return

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
SELECT GET_LOCK("mine");
 
2
GET_LOCK("mine")
 
3
1
 
4
SELECT USER_NAME, USER_LOCK_NAME FROM DATA_DICTIONARY.USER_LOCKS;
 
5
USER_NAME       USER_LOCK_NAME
 
6
root    mine
 
7
CREATE TABLE lock_state (a int);
 
8
EXECUTE "INSERT INTO lock_state SELECT GET_LOCK(\"mine\", 20)" CONCURRENT;
 
9
SELECT RELEASE_LOCK(@LOCK);
 
10
RELEASE_LOCK(@LOCK)
 
11
NULL
 
12
DROP TABLE lock_state;