Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-139

Indices for sorting: Only index first part of JSON array properties

    XMLWordPrintable

Details

    • CP: sprint 79
    • Core: Platform

    Description

      Array properties are potentially very long, causing issues for the database when attempting to index them. It's the b-tree indices – used for sorting – that can fail on long arrays.

      It's suggested that we only index the first part - say the first hundred characters of any array property, since indexing beyond that provides no added value when sorting.

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Umbrella - FOLIO-2402 platform-related features and fixes for mod-inv-stor 18.2.1

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            is blocked by

            Bug - A problem which impairs or prevents the functions of the product. RMB-498 Truncate b-tree string for 2712 index row size

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            is duplicated by

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-379 Reindex of contributors fails with maximum 2712 'index row size exceeded' error

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-390 Adding an Instance with a longer title throws "Values larger than 1/3 of a buffer page cannot be indexed"

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Activity

              People

                julianladisch Julian Ladisch
                nielserik Niels Erik Gilvad Nielsen
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases