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.
Attachments
Activity
John Gates
created issue -
| Field | Original Value | New Value |
|---|---|---|
| Remote Link | This issue links to "Page (Confluence)" [ 23017 ] |
| Remote Link | This issue links to "Page (Confluence)" [ 23090 ] |
John Gates: do we know if this is still an issue? From 2016 – probably KPM10 or KPM20 dataset? We might try this form of query again against Stripe82 on the NCSA cluster?
| Remote Link | This issue links to "Page (Confluence)" [ 40579 ] |
| Component/s | Qserv [ 10722 ] |
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.