Glenn Galvizo created ASTERIXDB-2759:
----------------------------------------
Summary: Compilation error for LOJ INLJ COUNT(*) query
Key: ASTERIXDB-2759
URL: https://issues.apache.org/jira/browse/ASTERIXDB-2759
Project: Apache AsterixDB
Issue Type: Bug
Components: IDX - Indexes
Affects Versions: 0.9.6
Reporter: Glenn Galvizo
Using the TinySocial dataset, I get an error trying to run the query:
{code:java}
SELECT COUNT(*)
FROM GleambookUsers user
LEFT OUTER JOIN GleambookMessages msg
ON msg.authorId /*+ indexnl */ = user.id;
{code}
* The issue doesn't appear when I SELECT *, but does appear when I try to
select anything else.
* The issue doesn't appear when I remove the INLJ hint.
* The issue doesn't appear when I use INNER JOIN instead.
When the error does pop up, it seems to originate in the optimizer-
specifically the SetClosedRecordConstructorsRule.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
