You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@calcite.apache.org by GitBox <gi...@apache.org> on 2021/06/08 06:20:56 UTC

[GitHub] [calcite] amandeep-sharma commented on pull request #2407: [CALCITE-4592] Populate correlation context for Join in RelToSqlConve…

amandeep-sharma commented on pull request #2407:
URL: https://github.com/apache/calcite/pull/2407#issuecomment-856483105


   > Good day!
   > Found out that this query produces same exception (`java.lang.NullPointerException: variable $cor0 is not found`)
   > query:
   > `SELECT t.id, (select b.id FROM tbl2 AS b WHERE b.id = t.id) FROM tbl1 as t`
   > it parsed/validated successfully, but can't be converted back to sql.
   > Can it be fixed in this pr or it is another issue?
   
   @FDoKE It seems that your use case is correlating the sub-query with `Project`. It is different from the PR use-case which is correlating the sub-query with `Join`.
   Correlating the sub-query is supported only with `Correlate`, `LogicalFilter` and `Join`, as of now. Support for correlating`Project` is doable, but I would prefer to make those changes in a separate PR.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org