I am using version 1.3.165 On Wednesday, August 28, 2013 8:17:31 PM UTC+8, Noel Grandin wrote: > > > 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.
