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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-5237:
---------------------------------------

[~rareddy] I don't see anything in the translator logic that looks like it would handle this scenario - it seems straight forward that a $in is being built with string values.  There's no support for convert nor does there seem to be an alternative name in source that would allow this.  Do you think we should just add a doc note about the searchability workaround?  On the import side it looks like scanning stops at the first document instance, so the logic won't detect type conflicts there currently.  There is some accounting of this in the couchbase translator that we could do here as well.

> 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)