[jira] [Created] (ASTERIXDB-2449) Incorrect null/missing handling in string/binary concat functions and concat operator

["Dmitry Lychagin (JIRA)" <ji...@apache.org>]

Dmitry Lychagin created ASTERIXDB-2449:
------------------------------------------

             Summary: Incorrect null/missing handling in string/binary concat functions and concat operator
                 Key: ASTERIXDB-2449
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2449
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: FUN - Functions
            Reporter: Dmitry Lychagin
            Assignee: Dmitry Lychagin


There a couple of issue with null/missing handling in string_concat() and binary_concat().

1) The return type should always be inferred as unknownable string. Currently the return type is inferred as string if input cannot be null/missing. This is incorrect because these functions return null/missing not only if the input argument is null/missing, but also if an item in the input list is null/missing

2) These functions should return 'missing' in input list is [ null, missing ]. Currently they both return 'null' in this case

String concatenation operator (||) is also affected by these issues because it's rewritten into string_concat()



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)