← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-12-21 16:39:40 UTC
  • mfrom: (1.2.4 upstream)
  • Revision ID: james.westby@ubuntu.com-20101221163940-c1pfo1jjvx7909xq
Tags: 2010.12.06-0ubuntu1
* New upstream release.
* Added libaio-dev build depend for InnoDB.
* Removed libpcre patch - applied upstream.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/user_locks/tests/t/create_barrier.test
1
1
SELECT create_barrier("foo");
2
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
2
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
3
3
SELECT release_barrier("foo");
4
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
4
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
5
5
 
6
6
SELECT create_barrier("foo1");
7
7
SELECT create_barrier("foo2");
8
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
8
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
9
9
SELECT release_barrier("foo2");
10
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
10
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
11
11
SELECT release_barrier("foo1");
12
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
12
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
13
13
 
14
14
# This should complain about a non-existant barrier
15
15
--error 1707
16
16
SELECT release_barrier("foo2");
17
17
 
18
18
# foo2 does not exist, so we should not wait for it
19
 
SELECT * FROM DATA_DICTIONARY.USER_BARRIERS ORDER BY USER_BARRIER_NAME;
 
19
SELECT * FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS ORDER BY USER_BARRIER_NAME;
20
20
--error 1707
21
21
SELECT wait("foo2");
22
22
 
30
30
# Test creating a barrier with a number
31
31
set @count_barrier= "count_barrier";
32
32
SELECT create_barrier(@count_barrier, 4);
33
 
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), GENERATION, WAITER_LIMIT from DATA_DICTIONARY.USER_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;
 
33
SELECT if ((SESSION_ID = CONNECTION_ID()), "YES", "NO"), GENERATION, WAITER_LIMIT from DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@count_barrier;