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

Fix problem with JOIN and LIMIT

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:

      Description

      SELECT o.deepSourceId FROM Object o, Source s WHERE qserv_areaspec_box(0.7, 1.5, 0.71, 1.51) and o.deepSourceId = s.objectId;
      ------------------

      deepSourceId

      ------------------

      4363051117580101
      4363051117580101
      4363042527641676
      4363042527641647
      4363042527641676
      4363042527641647
      4363042527641676
      4363042527641693
      4363042527641693
      4363042527641693
      4363051117580100
      4363051117580100
      4363051117580100
      4363051117580095
      4363051117580101
      4363042527641647
      4363042527641693
      4363042527641693
      4363042527641647
      4363042527641676
      4363042527641647

      ------------------
      21 rows in set (2.88 sec)

      SELECT o.deepSourceId FROM Object o, Source s WHERE qserv_areaspec_box(0.7, 1.5, 0.71, 1.51) and o.deepSourceId = s.objectId limit 10;
      ERROR 4120 (Proxy): Error executing query using qserv.

        Attachments

          Issue Links

          is triggered by

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-3364 Analyze qserv performance / KPIs

          • Done
          mentioned in

          Page Loading...

            Activity

            Hide
            Permalink
            fritzm Fritz Mueller added a comment -

            Fixed along the way some time back.

            Show
            fritzm Fritz Mueller added a comment - Fixed along the way some time back.

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              fritzm Fritz Mueller
              Watchers:
              Fritz Mueller, Gregory Dubois-Felsmann
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.