[teiid-issues] [JBoss JIRA] (TEIID-5237) Issue With Matching Against MongoDB Documents With a Mixed Type (string and integer) Column

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13526306#comment-13526306 ] 

Ramesh Reddy commented on TEIID-5237:
-------------------------------------

[~shawkins] I doubt if Mongo supports $in mixed types, it would take some investigation. I believe it is a slippery slope having single type with multiple data types. Sure we can scan more records and fail at the beginning.

> Issue With Matching Against MongoDB Documents With a Mixed Type (string and integer) Column
> -------------------------------------------------------------------------------------------
>
>                 Key: TEIID-5237
>                 URL: https://issues.jboss.org/browse/TEIID-5237
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.12.3
>         Environment: TEIID Embedded Server 8.12.3
> Datasource DB - MongoDB 3.4
> Java 1.7.0_71
>            Reporter: Andriy G
>            Assignee: Steven Hawkins
>
> Issue to search for values using IN operator against MongoDB document containing field values both string and integer. Resultset simply filters out INTEGER values that stored in that field 



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)