MySQL Lists: internals: bk commit into 5.0 tree (guilhem:1.1978)

List:	Internals	« Previous Message Next Message »
From:	guilhem	Date:	November 17 2005 2:41pm
Subject:	bk commit into 5.0 tree (guilhem:1.1978)
View as plain text
Below is the list of changes that have just been committed into a local
5.0 repository of guilhem. When guilhem does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet
  1.1978 05/11/17 14:41:08 guilhem@stripped +4 -0
  WL#1012 (row-based replication): a new test just to see if replication (statement- or
row-based) from any two engines of MyISAM, MEMORY and InnoDB works.

  mysql-test/t/rpl_multi_engine.test
    1.1 05/11/17 14:41:03 guilhem@stripped +99 -0
    A new test just to see if replication (statement or row-based) from any two engines of
MyISAM, MEMORY and InnoDB works

  mysql-test/t/rpl_multi_engine-slave.opt
    1.1 05/11/17 14:41:03 guilhem@stripped +1 -0
    need innodb in slave for this test

  mysql-test/r/rpl_multi_engine.result
    1.1 05/11/17 14:41:03 guilhem@stripped +365 -0
    result for new test

  mysql-test/include/rpl_multi_engine.inc
    1.1 05/11/17 14:41:03 guilhem@stripped +16 -0
    include file to be used several times by rpl_multi_engine.test

  mysql-test/t/rpl_multi_engine.test
    1.0 05/11/17 14:41:03 guilhem@stripped +0 -0
    BitKeeper file /home/mysql_src/mysql-5.0-wl1012/mysql-test/t/rpl_multi_engine.test

  mysql-test/t/rpl_multi_engine-slave.opt
    1.0 05/11/17 14:41:03 guilhem@stripped +0 -0
    BitKeeper file
/home/mysql_src/mysql-5.0-wl1012/mysql-test/t/rpl_multi_engine-slave.opt

  mysql-test/r/rpl_multi_engine.result
    1.0 05/11/17 14:41:03 guilhem@stripped +0 -0
    BitKeeper file /home/mysql_src/mysql-5.0-wl1012/mysql-test/r/rpl_multi_engine.result

  mysql-test/include/rpl_multi_engine.inc
    1.0 05/11/17 14:41:03 guilhem@stripped +0 -0
    BitKeeper file
/home/mysql_src/mysql-5.0-wl1012/mysql-test/include/rpl_multi_engine.inc

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	guilhem
# Host:	gbichot3.local
# Root:	/home/mysql_src/mysql-5.0-wl1012
--- New file ---
+++ mysql-test/include/rpl_multi_engine.inc	05/11/17 14:41:03
connection master;
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free
for the customer',654321.4321,15.21,0,1965,"2005-11-14");
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
sync_slave_with_master;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
connection master;
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
sync_slave_with_master;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
connection master;
DELETE FROM mysqltest1.t1 WHERE id = 42;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
sync_slave_with_master;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
connection master;

--- New file ---
+++ mysql-test/r/rpl_multi_engine.result	05/11/17 14:41:03
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
create database if not exists mysqltest1;
use mysqltest1;
drop table if exists t1;
CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc
VARCHAR(255), bc CHAR(255), d DECIMAL(10,4) DEFAULT 0, f FLOAT DEFAULT
0, total BIGINT UNSIGNED, y YEAR, t TIMESTAMP,PRIMARY KEY(id));
use mysqltest1;
alter table t1 engine=myisam;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
alter table t1 engine=myisam;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free
for the customer',654321.4321,15.21,0,1965,"2005-11-14");
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
DELETE FROM mysqltest1.t1 WHERE id = 42;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
alter table t1 engine=innodb;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free
for the customer',654321.4321,15.21,0,1965,"2005-11-14");
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
DELETE FROM mysqltest1.t1 WHERE id = 42;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
alter table t1 engine=memory;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free
for the customer',654321.4321,15.21,0,1965,"2005-11-14");
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
DELETE FROM mysqltest1.t1 WHERE id = 42;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
alter table t1 engine=memory;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1
alter table t1 engine=myisam;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free
for the customer',654321.4321,15.21,0,1965,"2005-11-14");
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
DELETE FROM mysqltest1.t1 WHERE id = 42;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
alter table t1 engine=innodb;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free
for the customer',654321.4321,15.21,0,1965,"2005-11-14");
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
DELETE FROM mysqltest1.t1 WHERE id = 42;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
alter table t1 engine=memory;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free
for the customer',654321.4321,15.21,0,1965,"2005-11-14");
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
DELETE FROM mysqltest1.t1 WHERE id = 42;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
alter table t1 engine=innodb;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
alter table t1 engine=myisam;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free
for the customer',654321.4321,15.21,0,1965,"2005-11-14");
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
DELETE FROM mysqltest1.t1 WHERE id = 42;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
alter table t1 engine=innodb;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free
for the customer',654321.4321,15.21,0,1965,"2005-11-14");
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
DELETE FROM mysqltest1.t1 WHERE id = 42;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
alter table t1 engine=memory;
show create table t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) default NULL,
  `vc` varchar(255) default NULL,
  `bc` char(255) default NULL,
  `d` decimal(10,4) default '0.0000',
  `f` float default '0',
  `total` bigint(20) unsigned default NULL,
  `y` year(4) default NULL,
  `t` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1
INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ', 'Must make it bug free
for the customer',654321.4321,15.21,0,1965,"2005-11-14");
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	1	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-11-14 00:00:00
UPDATE t1 SET b1 = 0, t="2005-09-09" WHERE b1 = 1;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
42	0	Testing MySQL databases is a cool 	Must make it bug free for the
customer	654321.4321	15.21	0	1965	2005-09-09 00:00:00
DELETE FROM mysqltest1.t1 WHERE id = 42;
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
select id,hex(b1),vc,bc,d,f,total,y,t from t1 order by id;
id	hex(b1)	vc	bc	d	f	total	y	t
DROP TABLE t1;

--- New file ---
+++ mysql-test/t/rpl_multi_engine-slave.opt	05/11/17 14:41:03
--innodb

--- New file ---
+++ mysql-test/t/rpl_multi_engine.test	05/11/17 14:41:03
# See if replication between MyISAM, MEMORY and InnoDB works.

-- source include/master-slave.inc

connection slave;
-- source include/have_innodb.inc

connection master;
-- source include/have_innodb.inc
--disable_warnings
create database if not exists mysqltest1;
use mysqltest1;
drop table if exists t1;

CREATE TABLE t1 (id MEDIUMINT NOT NULL, b1 BIT(8), vc
VARCHAR(255), bc CHAR(255), d DECIMAL(10,4) DEFAULT 0, f FLOAT DEFAULT
0, total BIGINT UNSIGNED, y YEAR, t TIMESTAMP,PRIMARY KEY(id));

sync_slave_with_master;
use mysqltest1;

# MyISAM to MyISAM then InnoDB then MEMORY

connection master;
alter table t1 engine=myisam;
show create table t1;

connection slave;
alter table t1 engine=myisam;
show create table t1;

--source include/rpl_multi_engine.inc

connection slave;
alter table t1 engine=innodb;
show create table t1;

--source include/rpl_multi_engine.inc

connection slave;
alter table t1 engine=memory;
show create table t1;

--source include/rpl_multi_engine.inc

# MEMORY to ...

connection master;
alter table t1 engine=memory;
show create table t1;

connection slave;
alter table t1 engine=myisam;
show create table t1;

--source include/rpl_multi_engine.inc

connection slave;
alter table t1 engine=innodb;
show create table t1;

--source include/rpl_multi_engine.inc

connection slave;
alter table t1 engine=memory;
show create table t1;

--source include/rpl_multi_engine.inc

# InnoDB to ...

connection master;
alter table t1 engine=innodb;
show create table t1;

connection slave;
alter table t1 engine=myisam;
show create table t1;

--source include/rpl_multi_engine.inc

connection slave;
alter table t1 engine=innodb;
show create table t1;

--source include/rpl_multi_engine.inc

connection slave;
alter table t1 engine=memory;
show create table t1;

--source include/rpl_multi_engine.inc

# cleanup
connection master;
DROP TABLE t1;
sync_slave_with_master;

# End of 5.1 test case
Thread
• bk commit into 5.0 tree (guilhem:1.1978)	guilhem	17 Nov