~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/session_dictionary/tests/r/user_savepoints.result

  • 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:
 
1
start transaction;
 
2
savepoint foo;
 
3
select * from data_dictionary.user_savepoints;
 
4
SAVEPOINT_NAME
 
5
foo
 
6
release savepoint foo;
 
7
rollback;
 
8
select * from data_dictionary.user_savepoints;
 
9
SAVEPOINT_NAME
 
10
start transaction;
 
11
savepoint foo;
 
12
select * from data_dictionary.user_savepoints;
 
13
SAVEPOINT_NAME
 
14
foo
 
15
savepoint foo2;
 
16
select * from data_dictionary.user_savepoints;
 
17
SAVEPOINT_NAME
 
18
foo2
 
19
foo
 
20
rollback;
 
21
select * from data_dictionary.user_savepoints;
 
22
SAVEPOINT_NAME
 
23
start transaction;
 
24
savepoint foo;
 
25
select * from data_dictionary.user_savepoints;
 
26
SAVEPOINT_NAME
 
27
foo
 
28
savepoint foo2;
 
29
release savepoint foo;
 
30
select * from data_dictionary.user_savepoints;
 
31
SAVEPOINT_NAME
 
32
foo2
 
33
rollback;
 
34
select * from data_dictionary.user_savepoints;
 
35
SAVEPOINT_NAME
 
36
start transaction;
 
37
savepoint foo;
 
38
select * from data_dictionary.user_savepoints;
 
39
SAVEPOINT_NAME
 
40
foo
 
41
savepoint foo2;
 
42
select * from data_dictionary.user_savepoints;
 
43
SAVEPOINT_NAME
 
44
foo2
 
45
foo
 
46
release savepoint foo2;
 
47
select * from data_dictionary.user_savepoints;
 
48
SAVEPOINT_NAME
 
49
foo
 
50
rollback;
 
51
select * from data_dictionary.user_savepoints;
 
52
SAVEPOINT_NAME
 
53
start transaction;
 
54
savepoint foo;
 
55
savepoint foo2;
 
56
savepoint foo3;
 
57
select * from data_dictionary.user_savepoints;
 
58
SAVEPOINT_NAME
 
59
foo3
 
60
foo2
 
61
foo
 
62
commit;
 
63
select * from data_dictionary.user_savepoints;
 
64
SAVEPOINT_NAME