Details
-
Bug
-
Status: In Progress
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
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" }