What version you using?
Because the following test case works for me:
create table test(id int, name varchar, code varchar, intvalue int,
longvalue long, floatvalue float, doublevalue double);
insert into test values(1, '1', '1', 1, 1, 1, 1);
select test.ID as ID,
null as NAME,
test.CODE as CODE,
test.INTVALUE as INTVALUE,
test.LONGVALUE as LONGVALUE,
test.FLOATVALUE as FLOATVALUE,
test.DOUBLEVALUE as DOUBLEVALUE
from test
union all
select test.ID as ID,
test.CODE as NAME,
test.NAME as CODE,
null as INTVALUE,
null as LONGVALUE,
null as FLOATVALUE,
null as DOUBLEVALUE
from test
union all
select test.ID as ID,
test.NAME as NAME,
test.CODE as CODE,
test.INTVALUE as INTVALUE,
test.LONGVALUE as LONGVALUE,
test.FLOATVALUE as FLOATVALUE,
test.DOUBLEVALUE as DOUBLEVALUE
from test;
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
