[BUGFIX] Limit maximum key length on sys_refindex 28/51828/2
authorClaus Due <claus@namelesscoder.net>
Fri, 24 Feb 2017 12:55:48 +0000 (13:55 +0100)
committerChristian Kuhn <lolli@schwarzbu.ch>
Sun, 26 Feb 2017 19:29:50 +0000 (20:29 +0100)
Prevents issues if key length exceeds maximum key
lengt for the SQL server. Keys are now kept below a
255 byte limit.

Change-Id: I8e0c2a167f94695dd728c777368fac9e779678d8
Resolves: #79993
Releases: master
Reviewed-on: https://review.typo3.org/51828
Tested-by: TYPO3com <no-reply@typo3.com>
Reviewed-by: Thomas Hohn <thomas@hohn.dk>
Tested-by: Thomas Hohn <thomas@hohn.dk>
Reviewed-by: Anders Kostending <aha@systime.dk>
Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch>
Tested-by: Christian Kuhn <lolli@schwarzbu.ch>
typo3/sysext/core/ext_tables.sql

index 2c902b5..8319c9b 100644 (file)
@@ -583,9 +583,9 @@ CREATE TABLE sys_refindex (
        ref_string varchar(1024) DEFAULT '' NOT NULL,
 
        PRIMARY KEY (hash),
-       KEY lookup_rec (tablename,recuid),
-       KEY lookup_uid (ref_table,ref_uid),
-       KEY lookup_string (ref_string)
+       KEY lookup_rec (tablename(240),recuid),
+       KEY lookup_uid (ref_table(240),ref_uid),
+       KEY lookup_string (ref_string(255))
 );
 
 #