Details
-
Type:
Bug
-
Status: To Do
-
Resolution: Unresolved
-
Fix Version/s: None
-
Component/s: Qserv
-
Labels:None
-
Team:Data Access and Database
Description
Queries similar to following give strange results.
- SELECT COUNT
FROM Object o1, Object o2 WHERE qserv_areaspec_box(...) AND scisql_angSep(o1.ra, o1.decl, o2.ra, o2.decl) < 0.015; returns about 76 million
- SELECT COUNT
FROM Object o1, Object o2 WHERE scisql_angSep(o1.ra, o1.decl, o2.ra, o2.decl) < 0.015; returns about 52 million
The second query should return many more results than the first as it should not be limited to a particular region of the sky, so something is not right. Also, it is important that distinct works properly with these queries.
This issue has been escalated to the DMCCB since it seems no work has been done for a long time.
Is it still a valid issue?
Please address with a comment or a change of status.