[
https://issues.apache.org/jira/browse/FLINK-12874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Timo Walther closed FLINK-12874.
--------------------------------
Resolution: Fixed
Fix Version/s: 1.9.0
Fixed in 1.9.0: 2a3ac580abf5b32c341fe921c1eacbb395b27f25
> 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
> Fix For: 1.9.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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)
