connect 'jdbc:derby:memory:foo;create=true';

create table a (id integer not null);

create table b (id integer not null, foo varchar(255));

select nullif(0,0) from a
union all
select foo from b;