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)