[jira] [Commented] (OPTIQ-400) RelField Trimmer needs to handle cross Joins

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/OPTIQ-400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14122211#comment-14122211 ] 

Julian Hyde commented on OPTIQ-400:
-----------------------------------

{{JdbcTest.testCountStar}} seems to test for this exact case. I added it in https://github.com/apache/incubator-optiq/commit/e60fa76e207f7a9d8c7bdaf0a5dea951f9b561a5 as part of the fix for OPTIQ-393 and it succeeds in every commit since then. What case are you running into that isn't handled by this code?

> RelField Trimmer needs to handle cross Joins
> --------------------------------------------
>
>                 Key: OPTIQ-400
>                 URL: https://issues.apache.org/jira/browse/OPTIQ-400
>             Project: Optiq
>          Issue Type: Bug
>            Reporter: Laljo John Pullokkaran
>            Assignee: Laljo John Pullokkaran
>         Attachments: optiq-400.patch
>
>
> select R1.key from R1 Join R2 would result in field trimmer asking for nothing from R2. This is obviously wrong:
> It should either add a constant or get any one field so that cardinality of join is maintained.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)