hi ,is there anybody ? i have follow sentences: *select temp13636650632.ID as ID,* * null as NAME,* * temp13636650632.CODE as CODE,* * temp13636650632.INTVALUE as INTVALUE,* * temp13636650632.LONGVALUE as LONGVALUE,* * temp13636650632.FLOATVALUE as FLOATVALUE,* * temp13636650632.DOUBLEVALUE as DOUBLEVALUE* * from temp13636650632* *union all* *select temp13636650631.ID as ID,* * temp13636650631.CODE as NAME,* * temp13636650631.NAME as CODE,* * null as INTVALUE,* * null as LONGVALUE,* * null as FLOATVALUE,* * null as DOUBLEVALUE* * from temp13636650631* *union all* *select temp13636650630.ID as ID,* * temp13636650630.NAME as NAME,* * temp13636650630.CODE as CODE,* * temp13636650630.INTVALUE as INTVALUE,* * temp13636650630.LONGVALUE as LONGVALUE,* * temp13636650630.FLOATVALUE as FLOATVALUE,* * temp13636650630.DOUBLEVALUE as DOUBLEVALUE* * from temp13636650630* please notice the line 2 . when the NAME be setted null ,the after column also be null no matter if it's really hava value. can somebody help me ? is this a bug? my english is very bad. if you can't understand what i talk ,I am so sorry.
-- 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.
