use test;

-- source include/have_ndb.inc

--disable_warnings
eval drop table if exists t1_ndb, t1_myisam ;
--enable_warnings
create table t1_ndb
( a int not null, b varchar(30), c varchar(10), primary key(a)) engine = ndb;
create table t1_myisam
( a int not null, b varchar(30), c varchar(10), primary key(a)) engine = myisam;
insert into t1_ndb    values (1,'one','one');
insert into t1_myisam values (1,'one','one');
commit ;

insert into t1_ndb    set a= 1, b='eins'
on duplicate key update a=a + 1, b=concat(b,'modified') ;
insert into t1_myisam set a= 1, b='eins'
on duplicate key update a=a + 1, b=concat(b,'modified') ;

select * from t1_ndb ;
select * from t1_myisam ;