[jira] [Commented] (CALCITE-2351) MongoDB integration test failures

["Michael Mior (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-2351?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16499084#comment-16499084 ] 

Michael Mior commented on CALCITE-2351:
---------------------------------------

[~ikryvenko], did your query really have WI in the where clause? I see this both in sqlline and the Mongo shell but the query is returning records with the state WV.

> MongoDB integration test failures 
> ----------------------------------
>
>                 Key: CALCITE-2351
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2351
>             Project: Calcite
>          Issue Type: Bug
>          Components: mongodb
>            Reporter: Igor Kryvenko
>            Assignee: Julian Hyde
>            Priority: Major
>
> {{MongoAdapterIT#testFilterReversed}} fails with command
> {code}
> mvn clean test -Dtest=MongoAdapterIT#testFilterReversed
> {code}
> *Output:*
> {code}
> Expected: is "STATE=WV; CITY=BLUEWELL\nSTATE=WV; CITY=ATHENS\n"
>      but: was "STATE=WV; CITY=BLUEWELL\nSTATE=WV; CITY=HERNDON\n"
>         at org.apache.calcite.test.MongoAdapterIT.testFilterReversed(MongoAdapterIT.java:712)
> {code}
> *{{sqlline}} output:*
> {code}
> 0: jdbc:calcite:model=mongodb/target/test-cla> select state, city from zips where 'WI' < state LIMIT 2;
> 2018-06-02 16:58:07,546 [main] INFO  - Opened connection [connectionId{localValue:2, serverValue:353}] to localhost:27017
> +-------+----------------------+
> | STATE |         CITY         |
> +-------+----------------------+
> | WV    | BLUEWELL             |
> | WV    | HERNDON              |
> +-------+----------------------+
> 2 rows selected (0.759 seconds)
> {code}
> *Mongo shell:*
> {code}
> > db.zips.find({"state": { $gt :'WI'}}).limit(2);
> { "_id" : "24701", "city" : "BLUEWELL", "loc" : [ -81.229023, 37.279788 ], "pop" : 22561, "state" : "WV" }
> { "_id" : "24726", "city" : "HERNDON", "loc" : [ -81.346777, 37.526431 ], "pop" : 2220, "state" : "WV" }
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)