[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15159419#comment-15159419
]
Julian Hyde commented on PHOENIX-2646:
--------------------------------------
I'd only expect ANY and ALL to work for a small set of built-in operators. As
you've noticed it's extra work to get them to work for each new operator.
'= ANY (array)' is not standard; '= ANY (query)' is standard. Calcite doesn't
implement either. For the latter, we recommend that people manually rewrite to
EXISTS. Not sure whether EXISTS would work on an array.
> Extend VARCHAR matching with ~ regex syntax
> -------------------------------------------
>
> Key: PHOENIX-2646
> URL: https://issues.apache.org/jira/browse/PHOENIX-2646
> Project: Phoenix
> Issue Type: New Feature
> Reporter: Nick Dimiduk
>
> We already support {{REGEXP}} functions for string manipulation. Let's add
> full regex matching support as well. For example, Postgres has the {{~}}
> operator for [POSIX regular expression
> matching|http://www.postgresql.org/docs/9.3/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP].
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
