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

Prevent use of secondary index for SQL predicate "objectId op val" if op is not '='

    XMLWordPrintable

    Details

    • Type: Story
    • Status: In Progress
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Queries that involve secondary index but use "!=", ">=", "<=", '<', '>' instead of "=", or "IN" work incorrectly. Example "select * from Object where objectId > 123" will be treated as "select * from Object where objectId = 123".

        Attachments

          Issue Links

          is contained by

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-23053 Create a branch of qserv to test Redis-based spatial index

          • To Do
          relates to

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. DM-4105 Update user documentation

          • Done
          mentioned in

          Page Loading...

            Activity

            Hide
            Permalink
            jammes Fabrice Jammes added a comment -

            Update also UserManual.md

            Show
            jammes Fabrice Jammes added a comment - Update also UserManual.md

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              jammes Fabrice Jammes
              Reviewers:
              Andy Salnikov, Jacek Becla
              Watchers:
              Fabrice Jammes, Jacek Becla, Serge Monkewitz
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Jenkins

                  No builds found.