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.

Reply via email to