[jira] [Commented] (PHOENIX-1386) ANY function only works with absolute value and doesn't work with other parameters

["Kevin Liew (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-1386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15788224#comment-15788224 ] 

Kevin Liew commented on PHOENIX-1386:
-------------------------------------

{quote}
James Taylor added a comment - 14/Mar/16 16:51
Interesting - didn't know about that syntax. Will we get that for free when we move to Calcite for parsing/planning, Julian Hyde?

Julian Hyde added a comment - 14/Mar/16 16:54
Yes, I think so.
{quote}

[~jamestaylor] we may want to change the targeted fix version if this depends on Calcite.

> ANY function only works with absolute value and doesn't work with other parameters  
> ------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-1386
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1386
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.2.0
>            Reporter: Mohammadreza
>            Assignee: ramkrishna.s.vasudevan
>              Labels: features, verify
>             Fix For: 4.10.0
>
>
> By this query phoenix doesn't work:
> SELECT *  FROM ac join mat  on  mat.mid=Any(ac.mt);
> ac.mt is an array.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)