[
https://issues.apache.org/jira/browse/ASTERIXDB-2759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Glenn Galvizo updated ASTERIXDB-2759:
-------------------------------------
Description:
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.
was:
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.
> 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
> 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
