Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-49248

Option for naming database indexes explicitly

    Details

      Description

      Currently the name of an index in the database doesn't suggest which table does the index belong to.
      The Service Builder creates an index-sql and all the index_names start with IX_<number>. In case issues occur related to an index as well it is very difficult to analyze which index is missing or invisible.
      Example:
      IX_23745345 - has no information
      IX_TableXY_column2_column5 - has the information which table and columns are involved

      It would be beneficial if the 'finder' of a service entity could have a parameter, e.g. index-name, which allows to specify the index name, like in the following example :
      <finder name="Group_Template" return-type="Collection" index-name="TableXY_column2_column5">
      <finder-column name="column2" />
      <finder-column name="column5" />
      </finder>
      The parameter could be optional, keeping the current behavior if not set.

        Attachments

          Activity

            People

            • Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              laszlo.hudak Laszlo Hudak
            • Votes:
              17 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:

                Packages

                Version Package