← 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-12-15 21:28:47 UTC
  • mto: This revision was merged to the branch mainline in revision 1998.
  • Revision ID: brian@tangent.org-20101215212847-c52kuprsbrcm8sfk
Update name usage for user defined objects.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/session_dictionary/tests/t/user_savepoints.test
1
1
# List savepoints.
2
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;
 
3
START TRANSACTION;
 
4
SAVEPOINT foo;
 
5
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
6
RELEASE SAVEPOINT foo;
 
7
ROLLBACK;
 
8
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
9
 
 
10
START TRANSACTION;
 
11
SAVEPOINT foo;
 
12
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
13
SAVEPOINT foo2;
 
14
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
15
ROLLBACK;
 
16
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
17
 
 
18
START TRANSACTION;
 
19
SAVEPOINT foo;
 
20
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
21
SAVEPOINT foo2;
 
22
RELEASE SAVEPOINT foo;
 
23
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
24
ROLLBACK;
 
25
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
26
 
 
27
START TRANSACTION;
 
28
SAVEPOINT foo;
 
29
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
30
SAVEPOINT foo2;
 
31
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
32
RELEASE SAVEPOINT foo2;
 
33
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
34
ROLLBACK;
 
35
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
36
 
 
37
START TRANSACTION;
 
38
SAVEPOINT foo;
 
39
SAVEPOINT foo2;
 
40
SAVEPOINT foo3;
 
41
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;
 
42
COMMIT;
 
43
SELECT * from DATA_DICTIONARY.USER_DEFINED_SAVEPOINTS;