← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/innobase/tests/r/innodb_replication_log.result

  • Committer: Lee Bieber
  • Date: 2011-02-11 20:30:05 UTC
  • mfrom: (2157.1.3 build)
  • Revision ID: kalebral@gmail.com-20110211203005-757o1y2yf78dxzqr
Merge Stewart - 716848: drizzleimport displays wrong program_name
Merge Stewart - update README file
Merge Andrew and Joe - Exposes the InnoDB SYS_REPLICATION_LOG to data_dictionary so that it is fast and fixes many issues we have been having

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/innobase/tests/r/innodb_replication_log.result
 
1
drop table if exists t1;
 
2
set global transaction_message_threshold=2000000;
 
3
ERROR HY000: Variable 'transaction_message_threshold' is a read only variable
 
4
create table t1 (a int primary key);
 
5
insert into t1 values (1),(2),(3);
 
6
show create table data_dictionary.INNODB_REPLICATION_LOG;
 
7
Table   Create Table
 
8
INNODB_REPLICATION_LOG  CREATE TABLE `INNODB_REPLICATION_LOG` (
 
9
  `TRANSACTION_ID` BIGINT NOT NULL,
 
10
  `TRANSACTION_SEGMENT_ID` BIGINT NOT NULL,
 
11
  `COMMIT_ID` BIGINT NOT NULL,
 
12
  `END_TIMESTAMP` BIGINT NOT NULL,
 
13
  `TRANSACTION_MESSAGE_STRING` TEXT COLLATE utf8_general_ci NOT NULL,
 
14
  `TRANSACTION_LENGTH` BIGINT NOT NULL
 
15
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
 
16
select count(*) >= 3 from data_dictionary.INNODB_REPLICATION_LOG;
 
17
count(*) >= 3
 
18
1
 
19
drop table t1;