You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Yingyi Bu (JIRA)" <ji...@apache.org> on 2016/10/05 17:23:20 UTC

[jira] [Closed] (ASTERIXDB-1674) Unexpected type exception for quantifier query

     [ https://issues.apache.org/jira/browse/ASTERIXDB-1674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yingyi Bu closed ASTERIXDB-1674.
--------------------------------
    Resolution: Fixed

Fixed with regression tests.

> Unexpected type exception for quantifier query
> ----------------------------------------------
>
>                 Key: ASTERIXDB-1674
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1674
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: Optimizer
>            Reporter: Yingyi Bu
>            Assignee: Yingyi Bu
>
> Query:
> {noformat}
> USE TinySocial;
> WITH nested_msgs AS
> (
>   SELECT fu.name name,
>          (
>            SELECT fu.name name, fm.message msg
>            FROM FacebookMessages fm
>            WHERE fm.`author-id` = fu.id
>          ) AS msgs
>   FROM FacebookUsers fu
> )
> SELECT VALUE nm
> FROM nested_msgs nm
> WHERE (SOME msg IN nm.msgs SATISFIES msg.name LIKE '%Giesen%')
> LIMIT 2;
> {noformat}
> Exception:
> {noformat}
> Unsupported type: STRING
> {noformat}



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