[jira] [Created] (CALCITE-5386) Add support for LIKE (ANY | SOME | ALL)

["James Kim (Jira)" <ji...@apache.org>]

James Kim created CALCITE-5386:
----------------------------------

             Summary: Add support for LIKE (ANY | SOME | ALL)
                 Key: CALCITE-5386
                 URL: https://issues.apache.org/jira/browse/CALCITE-5386
             Project: Calcite
          Issue Type: New Feature
          Components: core
            Reporter: James Kim


Currently we only support LIKE calls with a single pattern, e.g. "x LIKE (y)".

Add support for LIKE ANY, LIKE SOME, and LIKE ALL which can be called with multiple patterns or a subquery, e.g. "x LIKE ANY (y, z)".

LIKE ANY and LIKE SOME would behave the same way in that if a value is LIKE any of the given patterns, it would return true, and in the case of LIKE ALL, true only if the value is LIKE all of the patterns.

Also support the negated versions of each, e.g. NOT LIKE ANY.

In terms of implementation, we will use the ANY, SOME, and ALL functions we already have that currently work with =, <, >, etc. The goal is to add LIKE as one of the possible precursors of ANY, SOME, and ALL so that in combination it allows LIKE ANY, LIKE SOME, and LIKE ALL.



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