[teiid-issues] [JBoss JIRA] (TEIID-2736) MongoDB: failed to translate to mongo query with boolean value expression

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy resolved TEIID-2736.
---------------------------------

        Labels: Beta2 teiid  (was: teiid)
    Resolution: Done


Added support for "$cond" operator in the "$projection" pipeline statement, to handle expressions in the select statement. One issue I saw is MongoDB's $cond syntax was little different compared to $match for comparison operators. Now code will handle both.
                
> MongoDB:  failed to translate to mongo query with boolean value expression
> --------------------------------------------------------------------------
>
>                 Key: TEIID-2736
>                 URL: https://issues.jboss.org/browse/TEIID-2736
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.6
>         Environment: Teiid 8.6 beta with mongoDB 
>            Reporter: Ivan Chan
>            Assignee: Ramesh Reddy
>              Labels: teiid, Beta2
>             Fix For: 8.6
>
>
> Fail to translate the following SQL to mongo query:
> select "grade",
> "name",
> "score",
> "state",
> "grade" as "test",
> ("name" = "state") as "name2"
> from "mongoDBDS"."grades"
> where "grade" = 'B'
> However, it works with the query contains group by and boolean value expression:
> elect "grade" as "test",
> "grade",
> ("name" = "state") as "name2",
> sum("score") as "sum_score"
> from "mongoDBDS"."grades"
> where "grade" = 'B'
> group by "grade", "grade", ("name" = "state")
> order by "grade", "test", "name2"

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira