~drizzle-trunk/drizzle/development

#

# misc binlogging tests that do not require a slave running

#

-- source include/have_log_bin.inc

-- source include/not_embedded.inc

-- source include/have_innodb.inc

-- source include/have_debug.inc

--disable_warnings

drop table if exists t1, t2;

--enable_warnings

reset master;

create table t1 (a int) engine=innodb;

create table t2 (a int) engine=innodb;

begin;

insert t1 values (5);

commit;

begin;

insert t2 values (5);

commit;

# first COMMIT must be Query_log_event, second - Xid_log_event

source include/show_binlog_events.inc;

drop table t1,t2;

#

# binlog rotation after one big transaction

#

reset master;

let $1=100;

create table t1 (n int) engine=innodb;

begin;

--disable_query_log

while ($1)

{

 eval insert into t1 values($1 + 4);

 dec $1;

}

--enable_query_log

commit;

drop table t1;

--replace_column 2 # 5 #

--replace_regex /table_id: [0-9]+/table_id: #/ /\/\* xid=.* \*\//\/* xid= *\//

show binlog events in 'master-bin.000001' from 107;

--replace_column 2 # 5 #

--replace_regex /table_id: [0-9]+/table_id: #/ /\/\* xid=.* \*\//\/* xid= *\//

show binlog events in 'master-bin.000002' from 107;

#

# Bug#22540 - Incorrect value in column End_log_pos of

# SHOW BINLOG EVENTS using InnoDB

#

# the following tests will show that certain queries now return

# absolute offsets (from binlog start, rather than relative to

# the beginning of the current transaction).  under what

# conditions it should be allowed / is sensible to put the

# slider into the middle of a transaction is not our concern

# here; we just guarantee that if and when it's done, the

# user has valid offsets to use.  if the setter function still

# wants to throw a "positioning into middle of transaction"

# warning, that's its prerogative and handled elsewhere.

set @ac = @@autocommit;

# first show this to work for SHOW BINLOG EVENTS

set autocommit= 0;

reset master;

create table t1(n int) engine=innodb;

begin;

insert into t1 values (1);

insert into t1 values (2);

insert into t1 values (3);

commit;

drop table t1;

--replace_regex /\/\* xid=.* \*\//\/* XID *\// /table_id: [0-9]+/table_id: #/ /Server ver: [^,]*,/Server version,/

show binlog events from 0;

# now show that nothing breaks if we need to read from the cache more

# than once, resulting in split event-headers

set @bcs = @@binlog_cache_size;

set global binlog_cache_size=4096;

reset master;

create table t1 (a int) engine=innodb;

let $1=400;

disable_query_log;

begin;

while ($1)

{

 eval insert into t1 values( $1 );

 dec $1;

}

commit;

enable_query_log;

--replace_regex /\/\* xid=.* \*\//\/* XID *\// /table_id: [0-9]+/table_id: #/ /Server ver: [^,]*,/Server version,/

show binlog events from 0;

drop table t1;

set global binlog_cache_size=@bcs;

set session autocommit = @ac;

#

# Bug#33798: prepared statements improperly handle large unsigned ints

#

--disable_warnings

drop table if exists t1;

--enable_warnings

reset master;

create table t1 (a bigint unsigned, b bigint(20) unsigned);

prepare stmt from "insert into t1 values (?,?)";

set @a= 9999999999999999;

set @b= 14632475938453979136;

execute stmt using @a, @b;

deallocate prepare stmt;

drop table t1;

--replace_regex /\/\* xid=.* \*\//\/* XID *\// /table_id: [0-9]+/table_id: #/ /Server ver: [^,]*,/Server version,/

show binlog events from 0;

--echo End of 5.0 tests

# Test of a too big SET INSERT_ID: see if the truncated value goes

# into binlog (right), or the too big value (wrong); we look at the

# binlog further down with SHOW BINLOG EVENTS.

reset master;

create table t1 (id tinyint auto_increment primary key);

set insert_id=128;

insert into t1 values(null);

select * from t1;

drop table t1;

# bug#22027 

create table t1 (a int);

create table if not exists t2 select * from t1;

# bug#22762

create temporary table tt1 (a int);

create table if not exists t3 like tt1;

# BUG#25091 (A DELETE statement to mysql database is not logged with

# ROW mode format): Checking that some basic operations on tables in

# the mysql database is replicated even when the current database is

# 'mysql'.

--disable_warnings

USE mysql;

INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test');

UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@';

DELETE FROM user WHERE host='localhost' AND user='@#@';

--enable_warnings

use test;

source include/show_binlog_events.inc;

drop table t1,t2,t3,tt1;

-- source extra/binlog_tests/binlog_insert_delayed.test

#Bug #26079 max_binlog_size + innodb = not make new binlog and hang server

# server should not hang, binlog must rotate in the end

reset master;

--disable_warnings

drop table if exists t3;

--enable_warnings

create table t3 (a int(11) NOT NULL AUTO_INCREMENT, b text, PRIMARY KEY (a) ) engine=innodb;

show master status;

let $it=4;

while ($it)

{

insert into t3(b) values ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');

dec $it;

}

show master status /* must show new binlog index after rotating */;

drop table t3;