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

              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