[ https://issues.apache.org/jira/browse/CALCITE-5699?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723283#comment-17723283 ]
Julian Hyde commented on CALCITE-5699: -------------------------------------- Your fix, using null policy, looks good. Can you merge the several queries in {{select.iq}} into one. Also add a test similar to {{SqlOperatorTest.testLikeOperator}}; it only needs to be about 6 lines long. > 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 > Priority: Major > Labels: pull-request-available > > 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)