← 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: Brian Aker
  • Date: 2010-11-16 22:52:43 UTC
  • mto: (1934.1.1 build) (1939.1.1 quick)
  • mto: This revision was merged to the branch mainline in revision 1935.
  • Revision ID: brian@tangent.org-20101116225243-0aevw4h95ct5w6ru
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;