× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Slava Gryb
slavakiev reported 2013-08-02T18:31:36Z  · last modified 2013-08-18T09:20:54Z

COUNT() counts NULL values when DISTINCT() used


Dev
Emil Goicovici
emil.goicovici
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component MongoSQL
Version 14.0

Tested in Aqua Data Studio Aqua Data Studio 14.0.0-beta-79 Build #: 33402 on Ubuntu 12.04( Mongo DB 2.4.3) and Windows XP ( Mongo DB 2.0.9).

In the ticket 9658 Jenny states that Mogngo SQL should not count NULL values.  But still regular .count() statement counts NULL when DISTINCT is used. See next scripset:

drop collection nullcoll

go 
insert into nullcoll(a,b) values (1,1)
go
insert into nullcoll(a,b) values (null,2)
go
insert into nullcoll(b) values (3)
go

select count(distinct a) from nullcoll 

go
--  count(a)
--  2

select count(a) from nullcoll 

go
--  count(a)
--  1
select a,count(a) from nullcoll group by a having field_exists(a)
go
--  a      count(a)
--(null)   0
--    1    1
  •  
  •  
  • 1 share
  •  
All Comments (1) Change History
Sort 

Issue #9709
Closed
Fixed
Resolved 2013-08-13T14:05:18Z
 
 
Completion
No due date
Fixed Build ADS 14.0.0-beta-85 (mongo-jdbc 1.2.8)
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017