Hi Thomas Thanks for the clarification. I was running some test on BI software when I discovered this behavior. I don't think it is a major concern as long the correct column is being picked.
Rgds, jay On Tuesday, November 4, 2014 1:24:46 AM UTC+8, Thomas Mueller wrote: > > Hi, > > Currently, operations that involve char and varchar result in char. That's > why the result of coalesce(char, varchar) is char. > > I wonder, why do you use "char" and not "varchar"? > > Regards, > Thomas > > > > On Mon, Nov 3, 2014 at 11:57 AM, Jiunn Jye Ng <[email protected]> wrote: > >> Hi All, >> >> Let's say >> white space = ' ' >> empty string = '' >> coalesce should return the first non null value. >> >> Test Case: >> create table testCoalesce ( colvarchar varchar, colchar char); >> insert into testCoalesce (colvarchar, colchar) values (' ', ' '); >> >> select coalesce(colvarchar, colchar), length(coalesce(colvarchar, >> colchar)) from testCoalesce >> return an empty string '' >> >> I understand that char does not store the trailing spaces. That explain >> where the empty string come from. But the result should have been the white >> space ' '. >> >> This can be simulated on h2 version 1.4.182. >> >> Thank you. >> >> Rgds, >> jay >> >> -- >> 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/d/optout. >> > > -- 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/d/optout.
