← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/storage_engine_api_tester/tests/t/transaction.test

  • Committer: Brian Aker
  • Date: 2011-01-13 07:03:39 UTC
  • mfrom: (2077.1.3 drizzle)
  • Revision ID: brian@gir-3-20110113070339-bnfp4yvngb6frhru
Merge in all of the fixes for definition to instance.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/storage_engine_api_tester/tests/t/transaction.test
4
4
# 2. Correct commit and rollback behaviour
5
5
# 3. XA protocol communication and recovery
6
6
 
7
 
select seapitester_clear_engine_state_history();
8
 
 
9
 
 
10
7
--disable_warnings
11
8
DROP TABLE IF EXISTS t1_trx, t1_non_trx;
12
9
--enable_warnings
35
32
 
36
33
ROLLBACK;
37
34
 
38
 
select * from data_dictionary.seapitester_engine_state_history;
39
 
select seapitester_clear_engine_state_history();
40
 
 
41
35
--echo Expected warning about non-trx data changes not being rolled back
42
36
 
43
37
SELECT * FROM t1_trx;
44
38
SELECT * FROM t1_non_trx;
45
39
 
46
 
select * from data_dictionary.seapitester_engine_state_history;
47
 
select seapitester_clear_engine_state_history();
48
 
 
49
40
START TRANSACTION;
50
41
 
51
42
INSERT INTO t1_trx VALUES ('key1','value1');
56
47
INNER JOIN t1_non_trx ON t1_trx.k = t1_non_trx.k;
57
48
 
58
49
ROLLBACK;
59
 
select * from data_dictionary.seapitester_engine_state_history;
60
 
select seapitester_clear_engine_state_history();
61
50
 
62
51
SELECT t1_trx.k, t1_trx.v
63
52
FROM t1_trx
65
54
 
66
55
DROP TABLE t1_trx;
67
56
DROP TABLE t1_non_trx;
68
 
 
69
 
select * from data_dictionary.seapitester_engine_state_history;
70
 
select seapitester_clear_engine_state_history();
71