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

[Evgeny Stanilovsky (Jira)]

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)