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

Handle "where objectId between"

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
    • Templates:
    • Story Points:
      6
    • Sprint:
      DB_W16_10
    • Team:
      Data Access and Database

      Description

      Query in a form:

      select objectId 
      from Object 
      where objectId between 386942193651347 and 386942193651349
      

      currently fails with

      ERROR 4120 (Proxy): Error during execution:
      -1 Ref=1 Resource(/chk/qservTest_case01_qserv/6630): 20150602-20:41:43, Complete (success), 0, 
      Ref=2 Resource(/chk/qservTest_case01_qserv/6631): 20150602-20:41:43, State error (unrecognized), 0, 
      Ref=3 Resource(/chk/qservTest_case01_qserv/6800): 20150602-20 (-1)
      

      We already documented that such queries are not advised, but nethertheless qserv should handle it better, e.g., return a message "not supported"

        Attachments

          Container Issues

            Issue Links

              Activity

                People

                • Assignee:
                  jammes Fabrice Jammes
                  Reporter:
                  fritzm Fritz Mueller
                  Reviewers:
                  Andy Salnikov
                  Watchers:
                  Andy Salnikov, Fabrice Jammes, Jacek Becla
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Summary Panel