Hi, I thank you, too. But I'm sorry my test case is not enough.
nvl2(expr1, expr2, expr3) oracle's nvl2 function that returns expr2's datatype, if expr2's datatype is character datatype. SELECT NVL2(1, 'test', 123) FROM dual; oracle: returns 123(varchar2) h2: throws NumberFormatException I wrote a patch,again. litailang On 5月4日, 午後2:18, Thomas Mueller <[email protected]> wrote: > Hi, > > Thanks a lot! I have changed your patch a bit, but the feature is committed > now. > > Regards, > Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
h2.patch
Description: Binary data
