You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Evgeny Stanilovsky (Jira)" <ji...@apache.org> on 2023/05/11 12:33:00 UTC
[jira] [Created] (CALCITE-5699) Posix regex expressions failed while NOT operator is executed with null literals.
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)