← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/session_dictionary/tests/t/user_savepoints.test

  • Committer: Lee Bieber
  • Date: 2010-11-17 06:06:24 UTC
  • mfrom: (1934.1.2 build)
  • Revision ID: kalebral@gmail.com-20101117060624-ne1hgr0j67io7g67
Merge Brian - Add user_savepoints table function.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/session_dictionary/tests/t/user_savepoints.test
 
1
# List savepoints.
 
2
 
 
3
start transaction;
 
4
savepoint foo;
 
5
select * from data_dictionary.user_savepoints;
 
6
release savepoint foo;
 
7
rollback;
 
8
select * from data_dictionary.user_savepoints;
 
9
 
 
10
start transaction;
 
11
savepoint foo;
 
12
select * from data_dictionary.user_savepoints;
 
13
savepoint foo2;
 
14
select * from data_dictionary.user_savepoints;
 
15
rollback;
 
16
select * from data_dictionary.user_savepoints;
 
17
 
 
18
start transaction;
 
19
savepoint foo;
 
20
select * from data_dictionary.user_savepoints;
 
21
savepoint foo2;
 
22
release savepoint foo;
 
23
select * from data_dictionary.user_savepoints;
 
24
rollback;
 
25
select * from data_dictionary.user_savepoints;
 
26
 
 
27
start transaction;
 
28
savepoint foo;
 
29
select * from data_dictionary.user_savepoints;
 
30
savepoint foo2;
 
31
select * from data_dictionary.user_savepoints;
 
32
release savepoint foo2;
 
33
select * from data_dictionary.user_savepoints;
 
34
rollback;
 
35
select * from data_dictionary.user_savepoints;
 
36
 
 
37
start transaction;
 
38
savepoint foo;
 
39
savepoint foo2;
 
40
savepoint foo3;
 
41
select * from data_dictionary.user_savepoints;
 
42
commit;
 
43
select * from data_dictionary.user_savepoints;