Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-6236

Lucene date range query skipped some records

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: 3.4
    • Fix Version/s: 4.1.2
    • Labels:
      None
    • Environment:
      Alfresco Version: Community - v3.4.0 (d 3370)

      settings:
      d_dictionary.datatype.d_datetime.analyzer=org.alfresco.repo.search.impl.lucene.analysis.DateTimeAnalyser
    • Bug Priority:
      Category 2

      Description

      I do a query in node browser

      [Query 1]
      +PATH:"/app:company_home/cm:SomeFolder/*" +@cm\:modified:[2012-05-08T17:49:22.000+08:00 TO 2012-05-09T18:59:24.001+08:00]
      example records return : 100

      [Query 2]
      +PATH:"/app:company_home/cm:SomeFolder/*" +@cm\:modified:[2012-05-08T17:49:22.001+08:00 TO 2012-05-09T18:59:24.001+08:00]
      example records return : 125

      [Analysis]
      Query 1 and 2 has differences in milliseconds, Query 1 have 22.000, Query 2 have 22.001
      Query 1 use earlier date, but returned less result than Query 2

      I suspect it skipped the records that have 22.zzz (zzz is the milliseconds)

        Attachments

          Activity

            People

            • Assignee:
              closedbugs Closed Bugs
              Reporter:
              silenr0c cornelis (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: