[jira] [Comment Edited] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL literal

["Evgeny Stanilovsky (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17730498#comment-17730498 ] 

Evgeny Stanilovsky edited comment on CALCITE-5708 at 6/8/23 10:36 AM:
----------------------------------------------------------------------

[~Runking] As i can see mentioned functions _not using untyped NULL_ in tests, but without cast (pure null literals) they work exactly the same as with cast besides SUBSTRING. Or you want additional tests (with cast) will be appended?


was (Author: zstan):
As i can see mentioned functions _not using untyped NULL_ in tests, but without cast (pure null literals) they work exactly the same as with cast besides SUBSTRING. Or you want additional tests (with cast) will be appended?

> Change SUBSTRING result if either of parameters is NULL literal
> ---------------------------------------------------------------
>
>                 Key: CALCITE-5708
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5708
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.34.0
>            Reporter: Evgeny Stanilovsky
>            Assignee: Evgeny Stanilovsky
>            Priority: Major
>              Labels: patch-available, pull-request-available
>             Fix For: 1.35.0
>
>
> According to standard:
> {noformat}
> 6.18 <string value function>
> ...
> 3)If <character substring function> is specified, then:
> ...
> c) If either C, S, or L is the null value, then the result of the <character substring function> is
> the null value.
> {noformat}
> calcite not follow this rule for now.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)