Mihai Budiu created CALCITE-5884:
------------------------------------
Summary: Nullability of of ARRAY_TO_STRING result does not depend
on third argument nullability
Key: CALCITE-5884
URL: https://issues.apache.org/jira/browse/CALCITE-5884
Project: Calcite
Issue Type: Improvement
Components: core
Affects Versions: 1.35.0
Reporter: Mihai Budiu
This is the current definition of the function ARRAY_TO_STRING in
SqlLibraryOperators:
{code:java}
/** The "ARRAY_TO_STRING(array, delimiter [, nullText ])" function. */
@LibraryOperator(libraries = {BIG_QUERY})
public static final SqlFunction ARRAY_TO_STRING =
SqlBasicFunction.create(SqlKind.ARRAY_TO_STRING,
ReturnTypes.VARCHAR_NULLABLE,
OperandTypes.STRING_ARRAY_CHARACTER_OPTIONAL_CHARACTER);
{code}
So the result is nullable if any of the arguments is nullable. However, the
nullability of the last argument does not influence the result nullabillity: a
NULL value for the third optional argument will not cause a NULL value to be
output.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
