Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-486

Use indexed id fields in foreign tables: holdingsRecords.permanentLocationId==abc*

    XMLWordPrintable

Details

    • CP: sprint 75, CP: sprint 76, CP: sprint 77
    • 5
    • Core: Platform

    Description

      The CQL query holdingsRecords.permanentLocationId==53cf956f-c1df-410b-8bea-27f712cca7c0 run against the instance endpoint results in
      lower(f_unaccent(holdings_record.jsonb->>'permanentLocationId')) LIKE lower(f_unaccent('53cf956f-c1df-410b-8bea-27f712cca7c0'))
      It should use the indexed id field (UUID data type) for best performance:
      holdings_record.permanentLocationId = '53cf956f-c1df-410b-8bea-27f712cca7c0'

      Extend cql2pg parser to also use id fields in foreign tables. Currently it only works when the id field is in the same table, for example permanentLocationId==53cf956f-c1df-410b-8bea-27f712cca7c0 running against the holdings records endpoint.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                julianladisch Julian Ladisch
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases