#9809: ORDER BY works wrong in UNION if column has MinKey(), MaxKey() values

slavakiev reported 2013-08-20T20:17:27Z · JennyNishimura last modified 2013-08-20T20:38:14Z

Dev	JennyNishimura
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	MongoSQL
Version	Future - .9

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

ORDER BY works wrong in UNION if column has MinKey(), MaxKey() values:

drop collection ordcoll

insert into ordcoll(a,b) values(6,'Z')

insert into ordcoll(a,b) values(5,null)

insert into ordcoll(a,b) values(4,'A')

insert into ordcoll(a,b) values(3,MaxKey())

insert into ordcoll(a,b) values(2,MinKey())

insert into ordcoll(a) values(1)

select b from ordcoll

union

select b from ordcoll

order by b

--wrong order

--b

---

--(null)

--MaxKey

--MinKey

--(null)

--A

--Z

All Comments (0) Change History