[ https://issues.apache.org/jira/browse/CALCITE-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738262#comment-17738262 ]
Julian Hyde commented on CALCITE-5708: -------------------------------------- [~Runking] and [~zstan], This is marked 'fixVersion = 1.35.0' and the release is rapidly approaching. In the next 24 hours, can we agree criteria so that this can be finished? > 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)