~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Joseph Daly
  • Date: 2010-10-29 02:01:29 UTC
  • mto: This revision was merged to the branch mainline in revision 1900.
  • Revision ID: skinny.moey@gmail.com-20101029020129-a981fu3ia5aaeppr
code cleanup, test fixes

Show diffs side-by-side

added added

removed removed

Lines of Context:
42
42
CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a));
43
43
CREATE TABLE t2 LIKE t1;
44
44
CREATE TABLE t3 LIKE t2;
45
 
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES ;
46
 
ENTRY_OFFSET    ENTRY_TYPE      ENTRY_LENGTH
47
 
0       TRANSACTION     76
48
 
76      TRANSACTION     76
49
 
152     TRANSACTION     76
50
 
228     TRANSACTION     201
51
 
429     TRANSACTION     203
52
 
632     TRANSACTION     203
53
45
DROP TABLE t1, t2, t3;
54
46
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log', entry_offset) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS ORDER BY TRANSACTION_ID DESC LIMIT 3;
55
47
PRINT_TRANSACTION_MESSAGE('transaction.log', entry_offset)