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.
