Uploaded image for project: 'PUBLIC - Liferay Portal Enterprise Edition'
  1. PUBLIC - Liferay Portal Enterprise Edition
  2. LPE-15788

Fix ServiceBuilder MySQL 5.6 indexes generation compatibility issue

    Details

    • Fix Pack Status:
      Scheduled

      Description

      Fix ServiceBuilder MySQL 5.6 indexes generation compatibility issue.

      Solution Notes

      • Make ServiceBuilder to keep the String type columns' length info inside the generated generic indexes sql file, in order to provide context info to BaseDB and all its sub-classes to do proper index length restriction.
      • Turn on mysql String type column index length restriction, set length to 255 according to MySQL 5.6's doc http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html
      • New property:
            #
            # Set the max length for string type of index.
            #
            database.string.index.max.length[mysql]=255
        
      • After the fix, indexes.sql files will contain a placeholder like [$COLUMN_LENGTH:75$ which will be replaced to the actual max length (configured in portal properties) run time.
      • After removing this fix, your custom plugin's service layer has to be regenerated.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              michael.prigge Michael Prigge
              Reporter:
              tibor.lipusz Tibor Lipusz
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Packages

                  Version Package
                  6.2.X EE
                  7.0 DE (7.0.10)