#10700: Issues with ORDER BY when DISTINCT in the WHAT for the record type

slavakiev reported 2013-11-06T19:43:57Z · last modified 2014-12-04T00:54:31Z

Dev	emil.goicovici
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	MongoSQL
Version	16.0

Tested in Aqua Data Studio 14.0.3-14 Build #: 34647 on Ubuntu 12.04

It is link to the closed ticket 10474. Order BY still works wrong for the record type.

insert into bs values({managerName:{'first':'Bruce','last':'Willis'}})

insert into bs values({managerName:{'first':'Adam','last':'Zimmer'}})

insert into bs values({managerName:{'first':'Greg','last':'Belamy'}})

select distinct managerName from bs

order by managerName desc

select distinct managerName from bs

order by managerName asc

Result of DESC same as ASC

All Comments (2) Change History

ranarohitp(*) 2014-11-13T04:21:20Z

Verified in ADS 16.0.0-dev-34.

tariqrahiman 2014-12-04T00:54:31Z

Verified in ADS v16.0.0-dev-60