Details
-
Bug
-
Resolution: Done
-
Major
-
8.4.1
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:
SELECT intkey, stringnum FROM BQT1.SmallA WHERE concat(stringkey, stringnum) = '7-17' ORDER BY intkey
Generated mongo command:
{aggregate: "smalla", pipeline: [ { $match: { _m0: "7-17" } }, { $project: { c_0: "$INTKEY", c_1: "$STRINGNUM" } }, { $sort: { c_0: 1 } } ] }
Query:
select intKey from bqt1.smalla where intKey+intKey >20
Generated mongo command:
{aggregate: "smalla", pipeline: [ { $match: { _m0: { $gt: 20 } } }, { $project: { _m1: "$INTKEY" } } ] }