Timo Walther created FLINK-12874: ------------------------------------ Summary: Improve the semantics of zero length character strings Key: FLINK-12874 URL: https://issues.apache.org/jira/browse/FLINK-12874 Project: Flink Issue Type: Sub-task Components: Table SQL / API Reporter: Timo Walther Assignee: Timo Walther
Zero-length character strings need special treatment as the SQL standard forbids to declare those type of character strings. For the type inference (e.g. determine the return type of a \{{TRIM('')}}) it should be possible to return zero-lengths VARCHAR types. In any case, those type should not have a serializable string representation. Similar behavior is done in the Oracle system: \{{SELECT DUMP(TRIM('')) AS tt FROM dual;}} returns \{{NULL}}. -- This message was sent by Atlassian JIRA (v7.6.3#76005)