[jira] [Updated] (FLINK-12874) Improve the semantics of zero length character strings

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-12874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

ASF GitHub Bot updated FLINK-12874:
-----------------------------------
    Labels: pull-request-available  (was: )

> 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
>            Priority: Major
>              Labels: pull-request-available
>
> 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)