[jira] [Created] (CALCITE-782) Mongo Groups missing values

[Tom Barber (JIRA)]

Tom Barber created CALCITE-782:
----------------------------------

             Summary: Mongo Groups missing values
                 Key: CALCITE-782
                 URL: https://issues.apache.org/jira/browse/CALCITE-782
             Project: Calcite
          Issue Type: Bug
    Affects Versions: 1.4.0-incubating
            Reporter: Tom Barber
            Assignee: Julian Hyde


If you do something like:

select count("collection"."_id") as "m0" , "collection"."registeredYear" as 
"c0", "collection"."registeredQuarter" as "c1" from "collection" as 
"collection" where "collection"."registeredYear" = 2015 group by 
"collection"."registeredQuarter", "collection"."registeredYear";

registeredYear isn't added to the $project: clause and so isn't returned by 
mongo.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)