← Back to branch summary

~skinny.moey/drizzle/innodb-replication

« back to all changes in this revision

Viewing changes to plugin/transaction_log/tests/r/transaction_log_rollback.result

  • Committer: Brian Aker
  • Date: 2010-11-08 22:35:57 UTC
  • mfrom: (1802.1.114 trunk)
  • Revision ID: brian@tangent.org-20101108223557-w3xzwp9hjjtjhtc1
Merge in trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/transaction_log/tests/r/transaction_log_rollback.result
14
14
INSERT INTO t1 VALUES (2);
15
15
ROLLBACK TO SAVEPOINT savept1;
16
16
COMMIT;
17
 
# check transaction_log
18
 
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
19
 
FILE_NAME       FILE_LENGTH     NUM_LOG_ENTRIES NUM_TRANSACTIONS        MIN_TRANSACTION_ID      MAX_TRANSACTION_ID      MIN_END_TIMESTAMP       MAX_END_TIMESTAMP       INDEX_SIZE_IN_BYTES
20
 
transaction.log 324     3       3       1       5       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
21
 
 
22
17
Check transaction_log_entries
23
 
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
24
 
ENTRY_OFFSET    ENTRY_TYPE      ENTRY_LENGTH
25
 
0       TRANSACTION     75
26
 
75      TRANSACTION     157
27
 
232     TRANSACTION     92
 
18
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
 
19
COUNT(*)
 
20
3
28
21
 
29
22
Check transaction_log_transactions
30
 
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
31
 
ENTRY_OFFSET    TRANSACTION_ID  SERVER_ID       START_TIMESTAMP END_TIMESTAMP   NUM_STATEMENTS  CHECKSUM
32
 
0       1       1       START_TIMESTAMP END_TIMESTAMP   1       0
33
 
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
34
 
232     5       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
23
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
 
24
COUNT(*)
 
25
3
35
26
Check transaction log contents
36
27
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
37
28
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
38
29
transaction_context {
39
30
  server_id: 1
40
 
  transaction_id: 5
 
31
  TRANSACTION_ID
41
32
  START_TIMESTAMP
42
33
  END_TIMESTAMP
43
34
}