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

Reject queries involving qserv_areaSpec_box on non-partitioned tables

    XMLWordPrintable

    Details

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

      Description

      sql> select * from DeepForcedSource where qserv_areaSpec_box(0.4,0.9,0.6,1.1) LIMIT 3000
      [2015-02-10 16:12:14] [42S02][1051] Unknown table 'result_4492663598'
      [2015-02-10 16:12:14] [Proxy][4120] Error during execution:
      -1 Ref=1 Resource(/chk/LSST/7140): 20150210-16:12:01, Error merging result, 1470, [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'QST_1_.,0.4,0.9,0.6,1.1)=1 LIMIT 3 (-1)

        Attachments

          Issue Links

            Activity

            Hide
            fritzm Fritz Mueller added a comment -

            qserv_area_spec is deprecated.  The proposed/supported alternative, direct use of scisql_s2PtIn*, already works correctly for well-formulated queries on any sort of table.

            Show
            fritzm Fritz Mueller added a comment - qserv_area_spec  is deprecated.  The proposed/supported alternative, direct use of  scisql_s2PtIn* , already works correctly for well-formulated queries on any sort of table.

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              jammes Fabrice Jammes
              Watchers:
              Fabrice Jammes, Fritz Mueller, Jacek Becla, Tatiana Goldina
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.