← Back to branch summary

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

« back to all changes in this revision

Viewing changes to plugin/transaction_log/tests/r/ddl_transaction_id.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:
plugin/transaction_log/tests/r/ddl_transaction_id.result
 
1
SET GLOBAL transaction_log_truncate_debug= true;
 
2
DROP TABLE IF EXISTS t1;
 
3
CREATE TABLE t1 (
 
4
id INT NOT NULL PRIMARY KEY
 
5
, padding VARCHAR(200) NOT NULL
 
6
);
 
7
INSERT INTO t1 VALUES (1, "I love testing.");
 
8
INSERT INTO t1 VALUES (2, "I hate testing.");
 
9
SELECT * FROM t1;
 
10
id      padding
 
11
1       I love testing.
 
12
2       I hate testing.
 
13
ALTER TABLE t1 CHANGE COLUMN padding less_padding VARCHAR(180) NOT NULL;
 
14
SELECT * FROM t1 WHERE id = 3;
 
15
id      less_padding
 
16
DROP TABLE t1;
 
17
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
 
18
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
 
19
transaction.log X       6       6       1       6       X       X       X
 
20
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
 
21
ENTRY_OFFSET    ENTRY_TYPE      ENTRY_LENGTH
 
22
X       TRANSACTION     X
 
23
X       TRANSACTION     X
 
24
X       TRANSACTION     X
 
25
X       TRANSACTION     X
 
26
X       TRANSACTION     X
 
27
X       TRANSACTION     X
 
28
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
 
29
ENTRY_OFFSET    TRANSACTION_ID  SERVER_ID       START_TIMESTAMP END_TIMESTAMP   NUM_STATEMENTS  CHECKSUM
 
30
X       1       1       X       X       1       0
 
31
X       2       1       X       X       1       0
 
32
X       3       1       X       X       1       0
 
33
X       4       1       X       X       1       0
 
34
X       5       1       X       X       1       0
 
35
X       6       1       X       X       1       0
 
36
SET GLOBAL transaction_log_truncate_debug= true;