Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-6946

Strange results with near neighbor queries.

    Details

    • Type: Bug
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Templates:
    • 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

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jgates John Gates
                Watchers:
                Fritz Mueller, Gabriele Comoretto, John Gates
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Summary Panel