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

Unable to create b-tree index more than 49 symbols length

    XMLWordPrintable

Details

    • CP: Non-roadmap backlog
    • Core: Platform

    Description

      Overview:

      We need to create a b-tree index for loan agedToLostDelayedBilling.dateLostItemShouldBeBilled property, however it got rejected with Maximum fieldName length is 49: agedToLostDelayedBilling.dateLostItemShouldBeBilled.

      Steps to Reproduce:

      1. Declare a b-tree index (index) for a field where the field name length exceeds 49 symbols.
      2. Run tenant initialization;

      Expected Results:
      B-tree index is created successfully.
      Actual Results:
      Error thrown com.fasterxml.jackson.databind.JsonMappingException: Maximum fieldName length is 49: agedToLostDelayedBilling.dateLostItemShouldBeBilled.

      Task:
      Extend schema.json to allow to set a shorter custom index name. RMB needs a unique index name to handle index creation, index recreation and index deletion. PostgreSQL truncates identifier names that are too long, this may result in a name clash.

      Workaround:
      Use a snippetPath .sql file to manually create a custom index name, see example in the comments.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Unassigned Unassigned
                bohdan-suprun Bohdan Suprun
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:

                  TestRail: Runs

                    TestRail: Cases