[CALCITE-2351] MongoDB integration test failures

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Component/s: mongodb-adapter
• Assignee: Igor Kryvenko
• Reporter: Igor Kryvenko
• Created: 02/Jun/18 14:02
• Updated: 07/Jun/18 13:48

Description

MongoAdapterIT#testFilterReversed fails with command

mvn clean test -Dtest=MongoAdapterIT#testFilterReversed

Output:

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)

sqlline output:

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)

Mongo shell:

> 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" }