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

Fix problem with JOIN and LIMIT

    XMLWordPrintable

Details

    • Bug
    • Status: Done
    • Resolution: Done
    • None
    • Qserv

    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

          Activity

            Fixed along the way some time back.

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

            People

              Unassigned Unassigned
              fritzm Fritz Mueller
              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.