-- source include/have_ndb.inc
-- source include/not_embedded.inc

--disable_warnings
DROP TABLE IF EXISTS t1,t2;
drop database if exists mysqltest;
--enable_warnings

CREATE TABLE t1 (a tinyint(3) unsigned NOT NULL auto_increment,
		 PRIMARY KEY (a));

CREATE TABLE t2(a varchar(21) NOT NULL default 1,
		b tinyint(3) unsigned NOT NULL default 0,
		UNIQUE KEY a (a,b)
) ENGINE=ndbcluster;

delimiter |;
CREATE TRIGGER trigtest AFTER INSERT ON t1
FOR EACH ROW BEGIN
	declare rc int;
	set rc=(select count(*) from t2);
	if rc=0 then insert into t2 values('1111',New.a);
	else update t2 set b=b+New.a;
	end if;
END|
delimiter ;|

insert into t1 values(default);

select * from t2;

alter table t1 engine=ndb;
insert into t1 values(default);
show warnings;           
select * from t2;