asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yingyi Bu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (ASTERIXDB-1674) Unexpected type exception for quantifier query
Date Tue, 04 Oct 2016 22:14:21 GMT
Yingyi Bu created ASTERIXDB-1674:
------------------------------------

             Summary: 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)

Mime
View raw message