[
https://issues.apache.org/jira/browse/ASTERIXDB-2759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michael J. Carey reassigned ASTERIXDB-2759:
-------------------------------------------
Assignee: Dmitry Lychagin
> 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
> Assignee: Dmitry Lychagin
> Priority: Major
>
> 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.
> * The issue doesn't appear when the index is open.
> When the error does pop up, it seems to originate in the optimizer-
> specifically the SetClosedRecordConstructorsRule.
>
> The error:
> ASX1079: Compilation error: Could not infer type for variable '$$49'. (in
> line 124, at column 11) [CompilationException]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
