#10046: Functions do not work when stand in GROUP BY

slavakiev reported 2013-09-18T09:37:27Z · last modified 2013-10-27T16:47:08Z

Functions do not work when stand in GROUP BY

Dev	emil.goicovici
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	MongoSQL
Version	14.0

Tested in Aqua Data Studio 14.0.0-rc-20 Build #: 33993 on Ubuntu 12.04( Mongo DB 2.4.3)

drop collection orddate

insert into orddate(dates,funds) values(isoDate('2012-12-12T19:18:12.977Z'),10)

insert into orddate(dates,funds) values(isoDate('2012-12-13T19:18:12.977Z'),11)

insert into orddate(dates,funds) values(isoDate('2012-10-14T19:18:12.977Z'),1)

insert into orddate(dates,funds) values(isoDate('2012-10-2T19:18:12.977Z'),5)

SELECT min(dates) FROM orddate group by min(dates)

--Invalid GROUP BY item: CALL

SELECT min(dates) as mn FROM orddate group by mn

--'10/2/2012'

SELECT month(dates) FROM orddate group by month(dates)

--Invalid GROUP BY item: CALL

SELECT month(dates) as mn FROM orddate group by mn

--Invalid GROUP BY item: CALL

All Comments (5) Change History

slavakiev 2013-09-23T13:10:01Z

Tested in Aqua Data Studio 14.0.0-rc-27 Build #: 34104 on Ubuntu 12.04( Mongo DB 2.4.3)

select month(dates) mn from orddate group by month(dates)

--empty result set

select month(dates) mn from orddate where month(dates) in (1,12) group by month(dates)

-- Exception occurred during aggregation: exception: can't convert from BSON type EOO to Date

Same error: "can't convert from BSON type EOO to Date" was reported as done in ticket 9942. I do not reopen it but make link here.

slavakiev 2013-10-02T18:07:39Z

Tested in Aqua Data Studio 14.0.0-rc-39 Build #: 34238 on Ubuntu 12.04( Mongo DB 2.4.3)

SELECT month(dates) FROM orddate GROUP BY max(dates)

-- Exception occurred during aggregation: exception: can't convert from BSON type EOO to Date

JennyNishimura 2013-10-03T15:51:00Z

Emil, please investigate and let us know what the problem is.

emil.goicovici 2013-10-07T15:16:46Z

This exception occurs when a date conversion operator ( $month, $year etc) tries to perform the operation on a field that is not available. On this scenario, the dates field from month(dates) is not available after aggregation. Thus, the following exception is now thrown:

SELECT month(dates) FROM orddate GROUP BY max(dates)

-- The 'dates' argument of the month() function is available only if it also occurs under the GROUP BY clause.

tariqrahiman 2013-10-10T00:21:51Z

Verified in 14.0.1

Search Tips

Aqua Data Studio / nhilam

Functions do not work when stand in GROUP BY

Issue #10046

Completion

1 issue link

Issue #9942

Search Tips

Aqua Data Studio / nhilam

Title

Functions do not work when stand in GROUP BY

Issue #10046

Completion

1 issue link

Issue #9942