[
https://issues.apache.org/jira/browse/HAWQ-356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
SuperJDC updated HAWQ-356:
--------------------------
Summary: varchar concat problem: one item is null || result would be NULL.
(was: varchar concat problem: || with NULL.)
> varchar concat problem: one item is null || result would be NULL.
> -----------------------------------------------------------------
>
> Key: HAWQ-356
> URL: https://issues.apache.org/jira/browse/HAWQ-356
> Project: Apache HAWQ
> Issue Type: Bug
> Reporter: SuperJDC
> Assignee: Lei Chang
>
> Firstly, my hawq download from official website:
> https://network.pivotal.io/products/pivotal-hdb, a released stable version.
> 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.
> I followed the document steps and successfully integrated with the ambari.
> All of hawq configurations are the default.
> Thanks!
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
