Just now I used the latest version ,it also don't works. the follow is the result. ID NAME CODE INTVALUE LONGVALUE FLOATVALUE DOUBLEVALUE 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 2 001 测试 3 001 测试 4 002 测试1 5 002 测试1 6 002 测试1 7 003 测试2 8 003 测试2 9 003 测试2 10 003 测试2 11 003 测试2 12 003 测试2 13 003 测试2 14 003 测试2 15 03 测试3 16 003 测试3 17 004 测试4 18 004 测试4 19 004 测试4 20 004 测试4 21 004 测试4 22 004 测试4 23 004 测试4 24 004 测试4 25 005 测试5 26 005 测试5 27 005 测试5 28 005 测试5 29 005 测试5 30 005 测试5 31 005 测试5 32 005 测试5 2 测试 001 1.23456789012346E29 10000000 388329.99 3 测试 001 1000 10000000 388329.99 4 测试1 002 1000 10000000 388329.99 5 测试1 002 1000 10000000 388329.99 6 测试1 002 1000 10000000 388329.99 7 测试2 003 1000 10000000 388329.99 8 测试2 003 1000 10000000 388329.99 9 测试2 003 1000 10000000 388329.99 10 测试2 003 1000 10000000 388329.99 11 测试2 003 1000 10000000 388329.99 12 测试2 003 1000 10000000 388329.99 13 测试2 003 1000 10000000 388329.99 14 测试2 003 1000 10000000 388329.99 15 测试3 03 1000 10000000 388329.99 16 测试3 003 1000 10000000 388329.99 17 测试4 004 1000 10000000 388329.99 18 测试4 004 1000 10000000 388329.99 19 测试4 004 1000 10000000 388329.99 20 测试4 004 1000 10000000 388329.99 21 测试4 004 1000 10000000 388329.99 22 测试4 004 1000 10000000 388329.99 23 测试4 004 1000 10000000 388329.99 24 测试4 004 1000 10000000 388329.99 25 测试5 005 1000 10000000 388329.99 26 测试5 005 1000 10000000 388329.99 27 测试5 005 1000 10000000 388329.99 28 测试5 005 1000 10000000 388329.99 29 测试5 005 1000 10000000 388329.99 30 测试5 005 1000 10000000 388329.99 31 测试5 005 1000 10000000 388329.99 32 测试5 005 1000 10000000 388329.99
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.
