[
https://issues.apache.org/jira/browse/CALCITE-782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jess Balint updated CALCITE-782:
--------------------------------
Description:
If you do something like:
{code:sql}
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";
{code}
registeredYear isn't added to the $project: clause and so isn't returned by
mongo.
was:
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.
> 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
> Priority: Major
> Fix For: next
>
>
> If you do something like:
> {code:sql}
> 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";
> {code}
> registeredYear isn't added to the $project: clause and so isn't returned by
> mongo.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
