Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Tested Aqua Data Studio Aqua Data Studio 14.0.0-beta-68 Build #: 33238 on Ubuntu 12.04( Mongo DB 2.4.3) and Windows XP ( Mongo DB 2.0.9).
In the ticket 9654 Jenny states that Mogngo SQL should not count NULL values in GROUP BY as other RDBMS do this. But we have situation that NULL values counted when regular .count() statement used. See next scripset:
drop collection nullcoll
select count(a) from nullcoll
So without group by count=2 but with group by 0+1=1
If using GROUP BY doesn't count NULL values, then when GROUP BY is not specified, it shouldn't count NULL values either.
Emil, let's make both cases consistent.
Issue #9658 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 14.0.0-beta-76 (mongo-jdbc 1.2.6) |
| No time estimate |
2 issue links |
relates to #9709
Issue #9709COUNT() counts NULL values when DISTINCT() used |
relates to #9654
Issue #9654COUNT() in realization for aggregate framework does not count NULL values |
If using GROUP BY doesn't count NULL values, then when GROUP BY is not specified, it shouldn't count NULL values either.
Emil, let's make both cases consistent.