Message Title

As I said, I actually tried executing the manually DDL statement which would have been produced when I would have followed your instructions:

 
                                                                CREATE TABLE `testentity_strings_aud` (
  `revision` int(11) NOT NULL,
  `TestEntity_id` bigint(20) NOT NULL,
  `strings` varchar(1024) NOT NULL, -- Now 1024 characters
  `action` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`revision`,`TestEntity_id`,`strings`),
  CONSTRAINT `FKadlc041c3dxra6fmfxsku0fuh` FOREIGN KEY (`revision`) REFERENCES `revinfo` (`REV`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
                                                            

which leads to

 
                                                                08:06:09 CREATE TABLE `testentity_strings_aud` (   `revision` int(11) NOT NULL,   `TestEntity_id` bigint(20) NOT NULL,   `strings` varchar(1024) NOT NULL,   `action` tinyint(4) DEFAULT NULL,   PRIMARY KEY (`revision`,`TestEntity_id`,`strings`),   CONSTRAINT `FKadlc041c3dxra6fmfxsku0fuh` FOREIGN KEY (`revision`) REFERENCES `revinfo` (`REV`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 Error Code: 1071. Specified key was too long; max key length is 3072 bytes 0.000 sec

And yes, I am using MySQL Server 5.7.

Add Comment

This message was sent by Atlassian JIRA