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

Index name 63 chars truncation for long table and field names

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: TBD
    • Resolution: Unresolved
    • Affects Version/s: 29.4.0
    • Fix Version/s: None
    • Template:
      Standard Bug Write-Up Format
    • Sprint:
      CP: Roadmap backlog
    • Development Team:
      Core: Platform

      Description

      PostgreSQL truncates all identifier names that exceed 63 characters. For CREATE INDEX we use an index name like ${table.tableName}_${indexes.fieldName}_idx_ft which may get truncated to 63 characters. If this results in duplicate index names one index overwrites the other causing bad performance.

      Use some truncation algorithm to ensure index name uniqueness.

      If name exceeds 63 characters use first 53 characters and append _ and the first 7 characters of the md5 sum of the non-truncated name. This leaves 2 remaining characters to append _p for the prepared replacement index (RMB-587).

        TestRail: Results

          Attachments

            Issue Links

            relates to

            Bug - A problem which impairs or prevents the functions of the product. OKAPI-1081 Reject invalid tenant ids

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

            Task - A task that needs to be done. RMB-565 review if all CQL to SQL generation code is using masking

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. RMB-587 Do not use public schema, remove it from search_path

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

            Bug - A problem which impairs or prevents the functions of the product. RMB-902 Reject tenant with invalid characters and possibly sanitize

            • TBD - To be determined
            • Blocked

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                  Dates

                  Created:
                  Updated:

                    TestRail: Runs

                      TestRail: Cases