Gift Sinthong created ASTERIXDB-2705:
----------------------------------------
Summary: Selection after an inner join throws an error
Key: ASTERIXDB-2705
URL: https://issues.apache.org/jira/browse/ASTERIXDB-2705
Project: Apache AsterixDB
Issue Type: Bug
Affects Versions: 0.9.5
Reporter: Gift Sinthong
I use the GleambookUsers and GleambookMessages datasets from the AsterixDB
tutorial. The first query uses left outer join returns correct results but the
second query which uses inner join throws an internal out-of-memory error.
{code:java}
USE TinySocial;
SELECT VALUE t
FROM (SELECT u.*, m.*
FROM GleambookUsers u
LEFT OUTER JOIN GleambookMessages m
ON u.id=m.authorId) t
WHERE t.authorId = 2;
SELECT VALUE t
FROM (SELECT u.*, m.*
FROM GleambookUsers u
INNER JOIN GleambookMessages m
ON u.id=m.authorId) t
WHERE t.authorId = 2;
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
