[jira] [Created] (HAWQ-356) varchar concat problem: || with NULL.

[SuperJDC (JIRA)]

SuperJDC created HAWQ-356:
-----------------------------

             Summary: varchar concat problem: || with NULL.
                 Key: HAWQ-356
                 URL: https://issues.apache.org/jira/browse/HAWQ-356
             Project: Apache HAWQ
          Issue Type: Bug
            Reporter: SuperJDC
            Assignee: Lei Chang


SELECT 'a' || 'a' || 'a';
result:
aaa

SELECT 'a' || NULL || 'a';
result:
NULL

It seems that using || joint varchars would be NULL (result) if one of the 
varchars is NULL.

Thanks!



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)