There is a Mongo document with following JDBC schema
CREATE FOREIGN TABLE MONGO_COLUMNS (
MONGO_ID_COLUMN string(255) OPTIONS (NAMEINSOURCE '"MONGO_ID_COLUMN"', CHAR_OCTET_LENGTH 510, NATIVE_TYPE 'STRING'),
) OPTIONS (NAMEINSOURCE '"TEST"."MONGO_COLUMNS"', UPDATABLE TRUE);
Document field MONGO_ID_COLUMN in mongodb contains mixed type values - both string and integer values:
"id1", "id3" ,"id5", "id7", "id9", "11", "13", "15", "17", "19", "id21", "id23", "id25", "id27", "id29"
If such mongodb instance is deploed as TEIID VDB, then SELECT statement for this table:
SELECT g_0.MONGO_ID_COLUMN AS c_0 FROM mongodb_jdbc_ds_TEST.MONGO_COLUMNS AS g_0
return right resultset, containing all 15 values described above.
But if one issues following query
SELECT g_0.MONGO_ID_COLUMN AS c_0 FROM mongodb_jdbc_ds_TEST.MONGO_COLUMNS AS g_0 WHERE g_0.MONGO_ID_COLUMN IN ('id1', '11', '13', '15')
resultset contains only one value: "id1"
OMITTING ALL INTEGER VALUES