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

[Ivan Chan (JIRA)]

Ivan Chan created TEIID-2736:
--------------------------------

             Summary: MongoBD:  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: Steven Hawkins


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