← Back to branch summary

~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

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

  • Committer: Padraig O'Sullivan
  • Date: 2010-03-15 14:05:26 UTC
  • mfrom: (1237.9.99 staging)
  • Revision ID: osullivan.padraig@gmail.com-20100315140526-opbgwdwn6tfecdkq
Merge from trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/transaction_log/tests/r/information_schema.result
 
1
SET GLOBAL transaction_log_truncate_debug= true;
1
2
DROP TABLE IF EXISTS t1;
2
3
CREATE TABLE t1 (
3
4
id INT NOT NULL PRIMARY KEY
6
7
INSERT INTO t1 VALUES (1, "I love testing.");
7
8
INSERT INTO t1 VALUES (2, "I hate testing.");
8
9
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
9
 
FILE_NAME       FILE_LENGTH     NUM_LOG_ENTRIES NUM_TRANSACTIONS        MIN_TRANSACTION_ID      MAX_TRANSACTION_ID      MIN_END_TIMESTAMP       MAX_END_TIMESTAMP
10
 
transaction.log X       4       4       1       4       X       X
 
10
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
 
11
transaction.log X       4       4       X       X       X       X       X
11
12
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
12
13
ENTRY_OFFSET    ENTRY_TYPE      ENTRY_LENGTH
13
14
X       TRANSACTION     X
16
17
X       TRANSACTION     X
17
18
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
18
19
ENTRY_OFFSET    TRANSACTION_ID  SERVER_ID       START_TIMESTAMP END_TIMESTAMP   NUM_STATEMENTS  CHECKSUM
19
 
X       1       1       X       X       1       0
20
 
X       2       1       X       X       1       0
21
 
X       3       1       X       X       1       0
22
 
X       4       1       X       X       1       0
 
20
X       X       1       X       X       1       0
 
21
X       X       1       X       X       1       0
 
22
X       X       1       X       X       1       0
 
23
X       X       1       X       X       1       0
23
24
SET GLOBAL transaction_log_truncate_debug= true;