← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: lbieber
  • Date: 2010-10-06 02:01:43 UTC
  • mfrom: (1814.1.1 build)
  • Revision ID: lbieber@orisndriz08-20101006020143-gho0wsmd346m02f9
Merge Brian - fix bug 654905 - DATA_DICTIONARY.TABLE.TYPE not returning BASE or VIEW (it reports the port type).

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/transaction_log/tests/r/transaction_log_large_blob.result
5
5
# check transaction_log
6
6
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
7
7
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
8
 
transaction.log 100356  3       3       1       3       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
 
8
transaction.log 100398  3       3       1       3       START_TIMESTAMP END_TIMESTAMP   INDEX_SIZE
9
9
 
10
10
Check transaction_log_entries
11
11
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
12
12
ENTRY_OFFSET    ENTRY_TYPE      ENTRY_LENGTH
13
13
0       TRANSACTION     75
14
 
75      TRANSACTION     185
15
 
260     TRANSACTION     100096
 
14
75      TRANSACTION     227
 
15
302     TRANSACTION     100096
16
16
 
17
17
Check transaction_log_transactions
18
18
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
19
19
ENTRY_OFFSET    TRANSACTION_ID  SERVER_ID       START_TIMESTAMP END_TIMESTAMP   NUM_STATEMENTS  CHECKSUM
20
20
0       1       1       START_TIMESTAMP END_TIMESTAMP   1       0
21
21
75      2       1       START_TIMESTAMP END_TIMESTAMP   1       0
22
 
260     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
 
22
302     3       1       START_TIMESTAMP END_TIMESTAMP   1       0
23
23
Check transaction log contents
24
24
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
25
25
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))