[CALCITE-3120] MongoAdapterTest.testGroupByAvgSumCount fails due the order of sort query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.21.0
• Component/s: mongodb-adapter
• Assignee: Stamatis Zampetakis
• Reporter: Stamatis Zampetakis
• Created: 07/Jun/19 15:53
• Updated: 10/Sep/19 21:36
• Resolved: 29/Jun/19 19:44

Description

The MongoAdapterTest.testGroupByAvgSumCount fails because $sort operator does not appear at the middle of the query but in the end.

org.junit.ComparisonFailure:
expected and actual Mongo queries (pipelines) do not match expected:<...$project" : {
    "[POP" : "$pop",
    "STATE" : "$state"
  }
}
{
  "$group" : {
    "_id" : "$STATE",
    "_1" : {
      "$sum" : "$POP"
    },
    "_2" : {
      "$sum" : {
        "$cond" : [{
            "$eq" : ["POP", null]
          }, 0, 1]
      }
    }
  }
}
{
  "$project" : {
    "STATE" : "$_id",
    "_1" : "$_1",
    "_2" : "$_2"
  }
}
{
  "$sort" : {
    "STATE" : 1
  }
}
{
  "$project" : {
    "STATE" : 1,
    "A" : {
      "$divide" : [{
          "$cond" : [{
              "$eq" : ["$_2", {
                  "$literal" : 0
                }]
            }, null, "$_1"]
        }, "$_2"]
    },
    "S" : {
      "$cond" : [{
          "$eq" : ["$_2", {
              "$literal" : 0
            }]
        }, null, "$_1"]
    },
    "C" : "$_2"]
  }
}> but was:<...$project" : {
    "[STATE" : "$state",
    "POP" : "$pop"
  }
}
{
  "$group" : {
    "_id" : "$STATE",
    "_1" : {
      "$sum" : "$POP"
    },
    "_2" : {
      "$sum" : {
        "$cond" : [{
            "$eq" : ["POP", null]
          }, 0, 1]
      }
    }
  }
}
{
  "$project" : {
    "STATE" : "$_id",
    "_1" : "$_1",
    "_2" : "$_2"
  }
}
{
  "$project" : {
    "STATE" : 1,
    "A" : {
      "$divide" : [{
          "$cond" : [{
              "$eq" : ["$_2", {
                  "$literal" : 0
                }]
            }, null, "$_1"]
        }, "$_2"]
    },
    "S" : {
      "$cond" : [{
          "$eq" : ["$_2", {
              "$literal" : 0
            }]
        }, null, "$_1"]
    },
    "C" : "$_2"
  }
}
{
  "$sort" : {
    "STATE" : 1]
  }
}>

Issue Links

• Is contained by: CALCITE-3156 Replace fongo with mongo java server for test