~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-10-02 14:17:48 UTC
  • mfrom: (1.1.1 upstream)
  • mto: (2.1.17 sid)
  • mto: This revision was merged to the branch mainline in revision 3.
  • Revision ID: james.westby@ubuntu.com-20101002141748-m6vbfbfjhrw1153e
Tags: 2010.09.1802-1
* New upstream release.
* Removed pid-file argument hack.
* Updated GPL-2 address to be new address.
* Directly copy in drizzledump.1 since debian doesn't have sphinx 1.0 yet.
* Link to jquery from libjs-jquery. Add it as a depend.
* Add drizzled.8 symlink to the install files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
6
6
);
7
7
INSERT INTO t1 VALUES (1, "I love testing.");
8
8
INSERT INTO t1 VALUES (2, "I hate testing.");
 
9
DROP TABLE t1;
9
10
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
10
11
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
 
12
transaction.log X       5       5       1       5       X       X       X
12
13
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
13
14
ENTRY_OFFSET    ENTRY_TYPE      ENTRY_LENGTH
14
15
X       TRANSACTION     X
15
16
X       TRANSACTION     X
16
17
X       TRANSACTION     X
17
18
X       TRANSACTION     X
 
19
X       TRANSACTION     X
18
20
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
19
21
ENTRY_OFFSET    TRANSACTION_ID  SERVER_ID       START_TIMESTAMP END_TIMESTAMP   NUM_STATEMENTS  CHECKSUM
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
 
22
X       1       1       X       X       1       0
 
23
X       2       1       X       X       1       0
 
24
X       3       1       X       X       1       0
 
25
X       4       1       X       X       1       0
 
26
X       5       1       X       X       1       0
24
27
SET GLOBAL transaction_log_truncate_debug= true;