Uploaded image for project: 'Providence'
  1. PROV-1924

Boolean queries involving dates (and possibly other types) return incorrect results with ElasticSearch

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects versions: 1.6.3, 1.7
    • Fix versions: None
    • Components: search
    • Labels:

      Description

      http://www.collectiveaccess.org/support/forum/index.php?p=/discussion/298135/boolean-searches-in-es#latest

      (ca_objects.date:1970) OR (ca_object_labels.name:sunset)
      and
      (ca_objects.date:1970) AND (ca_object_labels.name:sunset)

      are both translated to the same query for ES, the date becomes a query filter in both cases. As a result the OR queries are incorrect.

        Attachments

          Activity

            People

            • Assignee:
              Former user (Inactive)
              Reporter:
              yelto
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: