[ https://issues.jboss.org/browse/TEIID-2987?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-2987: -------------------------------- Description: Teiid will return no rows when a function which is pushed down is used in a where clause. These queries should return few rows, but the result is empty: Query: {code} SELECT intkey, stringnum FROM BQT1.SmallA WHERE concat(stringkey, stringnum) = '7-17' ORDER BY intkey {code} Generated mongo command: {code} {aggregate: "smalla", pipeline: [ { $match: { _m0: "7-17" } }, { $project: { c_0: "$INTKEY", c_1: "$STRINGNUM" } }, { $sort: { c_0: 1 } } ] } {code} Query: {code} select intKey from bqt1.smalla where intKey+intKey >20 {code} Generated mongo command: {code} {aggregate: "smalla", pipeline: [ { $match: { _m0: { $gt: 20 } } }, { $project: { _m1: "$INTKEY" } } ] } {code} was: Teiid will return no rows when a function which is pushed down is used in a where clause. These queries should return few rows, but the result is empty: Query: {code} SELECT intkey, stringnum FROM BQT1.SmallA WHERE concat(stringkey, stringnum) = '7-17' ORDER BY intkey {code} Generated mongo command: {code} {aggregate: "smalla", pipeline: [ { $match: { _m0: "7-17" } }, { $project: { c_0: "$INTKEY", c_1: "$STRINGNUM" } }, { $sort: { c_0: 1 } } ] } {code} Query: [code} select intKey from bqt1.smalla where intKey+intKey >20 {code} Generated mongo command: {code} {aggregate: "smalla", pipeline: [ { $match: { _m0: { $gt: 20 } } }, { $project: { _m1: "$INTKEY" } } ] } {code} -- This message was sent by Atlassian JIRA (v6.2.3#6260)