You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2023/05/18 07:22:00 UTC
[jira] [Created] (CALCITE-5708) Change SUBSTRING result if either of parameters is NULL
Evgeny Stanilovsky created CALCITE-5708:
-------------------------------------------
Summary: Change SUBSTRING result if either of parameters is NULL
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
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)