You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Timo Walther (JIRA)" <ji...@apache.org> on 2019/06/19 08:17:00 UTC

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

     [ 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)