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
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | MongoSQL |
| Version | Future - .9 |
Tested Aqua Data Studio Aqua Data Studio 14.0.0-rc-8 Build #: 33812 on Ubuntu 12.04( Mongo DB 2.4.3)
When an alias is used for COUNT, null is returned even if the field is not an array.
insert into issue9904(a,b) values(1,1)
go
insert into issue9904(a,b) values(1,1)
go
insert into issue9904(a,b) values(null,2)
go
insert into issue9904(a,b) values(null,2)
go
insert into issue9904(b) values(3)
go
insert into issue9904(b) values(3)
go
select count(distinct a) as cnt from issue9904
go
cnt
------
(null)
1 record(s) selected [Fetch MetaData: 0ms] [Fetch Data: 0ms]
select count(distinct a) from issue9904
go
count(distinct a)
--------------------
1
1 record(s) selected [Fetch MetaData: 0ms] [Fetch Data: 0ms]
When an alias is used for COUNT, null is returned even if the field is not an array.
This has been fixed on the mongo-jdbc 1.3.3 drop.
When an alias is used for COUNT, null is returned even if the field is not an array.
This has been fixed on the mongo-jdbc 1.3.3 drop.
Issue #9904 |
| Closed |
Completion |
| No due date |
| No fixed build |
| No time estimate |
1 issue link |
relates to #9971
Issue #9971Test of COUNT() performance |
When an alias is used for COUNT, null is returned even if the field is not an array.
insert into issue9904(a,b) values(1,1) go insert into issue9904(a,b) values(1,1) go insert into issue9904(a,b) values(null,2) go insert into issue9904(a,b) values(null,2) go insert into issue9904(b) values(3) go insert into issue9904(b) values(3) go select count(distinct a) as cnt from issue9904 go cnt ------ (null) 1 record(s) selected [Fetch MetaData: 0ms] [Fetch Data: 0ms] select count(distinct a) from issue9904 go count(distinct a) -------------------- 1 1 record(s) selected [Fetch MetaData: 0ms] [Fetch Data: 0ms]