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

["Evgeny Stanilovsky (Jira)" <ji...@apache.org>]

Evgeny Stanilovsky created CALCITE-5699:
-------------------------------------------

             Summary: Posix regex expressions failed while NOT operator is executed with null literals.
                 Key: CALCITE-5699
                 URL: https://issues.apache.org/jira/browse/CALCITE-5699
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.34.0
            Reporter: Evgeny Stanilovsky
            Assignee: Evgeny Stanilovsky


Operations like :
{noformat}
SELECT null !~ 'ab[cd]'
SELECT 'abcd' !~ null
SELECT null !~ null
SELECT null !~* 'ab[cd]'
SELECT 'abcd' !~* null
SELECT null !~* null{noformat}
is not possible for now, NPE is raised :
{noformat}
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){noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)