[
https://issues.apache.org/jira/browse/HAWQ-356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
SuperJDC updated HAWQ-356:
--------------------------
Description:
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.
Thanks!
was:
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!
> 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
>
> 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.
> Thanks!
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
