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

Julian Hyde commented on CALCITE-1697:
--------------------------------------

I just tried your PR 
https://github.com/apache/calcite/pull/588/commits/38133722246a4a943c26aebfb76e4367d303927a
 (yes, it includes a fix for CALCITE-2109) against [latest 
calcite-test-dataset|https://github.com/vlsi/calcite-test-dataset/commit/9aaa8e2eddd96073a18bd40011d785d8880594fc].
 I ran {noformat}mvn -pl mongodb -Pit test integration-test{noformat} and I got 
the following errors {noformat}Failed tests: 
  MongoAdapterIT.testDistinctCount:686 expected MongoDB query not found 
expected:<...', STATE: '$state'}}[
{$group: {_id: {CITY: '$CITY', STATE: '$STATE'}}}
{$project: {_id: 0, CITY: '$_id.CITY', STATE: '$_id.STATE'}}
{$group: {_id: '$STATE', CDC: {$sum: {$cond: [ {$eq: ['CITY', null]}, 0, 1]}}}}
{$project: {STATE: '$_id', CDC: '$CDC'}}
{$sort: {STATE: 1}}]> but was:<...', STATE: '$state'}}[]>
  MongoAdapterIT.testProject:738 expected MongoDB query not found 
expected:<{$project: {[CITY: '$city', STATE: '$state'}}
{$sort: {STATE: 1, CITY: 1}}
{$project: {STATE: 1, CITY: 1, ZERO: {$literal: 0}]}}> but was:<{$project: 
{[STATE: '$state', CITY: '$city', ZERO: {$literal: 0}}}
{$sort: {STATE: 1, CITY: 1]}}>
Tests in error: 
  MongoAdapterIT.testAndLiteralPlan:440 ยป Runtime exception while executing 
[sel...

Tests run: 34, Failures: 2, Errors: 1, Skipped: 4
{noformat}

Are these 2 failures and 1 error expected? If they're OK then let's either 
disable the tests or fix the expected output.

> Update Mongo driver version
> ---------------------------
>
>                 Key: CALCITE-1697
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1697
>             Project: Calcite
>          Issue Type: Improvement
>          Components: mongodb
>    Affects Versions: 1.11.0
>            Reporter: Michael Mior
>            Assignee: Michael Mior
>             Fix For: 1.16.0
>
>
> The current version of the Mongo driver is quite outdated. This causes issues 
> such as getCollectionNames returning empty on newer versions of the Mongo 
> server. This effectively makes the driver unusable since Calcite will never 
> see any tables in the schema.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to