You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Igor Kryvenko (JIRA)" <ji...@apache.org> on 2018/06/02 14:03:00 UTC

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

Igor Kryvenko created CALCITE-2351:
--------------------------------------

             Summary: 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


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