[ASTERIXDB-2759] Compilation error for LOJ INLJ COUNT(*) query

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.6
• Component/s: IDX - Indexes
• Assignee: Dmitry Lychagin
• Reporter: Glenn Justo Galvizo
• Created: 10/Jul/20 09:03
• Updated: 16/Jul/20 00:02

Description

Using the TinySocial dataset, I get an error trying to run the query:

SELECT COUNT(*)
FROM GleambookUsers user
LEFT OUTER JOIN GleambookMessages msg
ON msg.authorId /*+ indexnl */ = user.id;

• 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]