[CALCITE-5708] SUBSTRING validation error if any parameter is a NULL literal

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.34.0
• Fix Version/s: 1.35.0
• Component/s: core
• Labels: patch-available pull-request-available
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 18/May/23 07:21
• Updated: 27/Jul/23 10:22
• Resolved: 05/Jul/23 14:15

Description

According to standard:

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.

calcite not follow this rule for now.

Issue Links

• fixes: IGNITE-19341 SQL: SUBSTRING function does not support NULL values (try 2)
• links to: GitHub Pull Request #3211
• links to: GitHub Pull Request #3211