[CALCITE-5699] Posix regex expressions failed while NOT operator is executed with null literals.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.34.0
• Fix Version/s: 1.35.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Evgeny Stanilovsky
• Reporter: Evgeny Stanilovsky
• Created: 11/May/23 12:32
• Updated: 27/Jul/23 10:22
• Resolved: 24/May/23 00:19

Description

Operations like :

SELECT null !~ 'ab[cd]'
SELECT 'abcd' !~ null
SELECT null !~ null
SELECT null !~* 'ab[cd]'
SELECT 'abcd' !~* null
SELECT null !~* null

is not possible for now, NPE is raised :

Caused by: java.lang.NullPointerException
     at java.base/java.util.regex.Matcher.getTextLength(Matcher.java:1770)
     at java.base/java.util.regex.Matcher.reset(Matcher.java:416)
     at java.base/java.util.regex.Matcher.<init>(Matcher.java:253)
     at java.base/java.util.regex.Pattern.matcher(Pattern.java:1134)
     at org.apache.calcite.runtime.SqlFunctions.posixRegex(SqlFunctions.java:864)

Issue Links

• is related to: CALCITE-3063 Babel parse should parse PostgreSQL posix regular expressions
• links to: GitHub Pull Request #3197