Details
-
Bug
-
Resolution: Done
-
Major
-
4.2.0.GA_CP08, 4.3.0.GA_CP07
-
None
-
Release Notes
-
Workaround Exists
-
Description
The test EnumIdTest.testEnumAsId fails with the following message, when creating the tables:
create table PlanetCheatSheet (planet tinyblob not null, mass double precision not null, numberOfInhabitants bigint not null, radius double precision not null, primary key (planet)) ENGINE=InnoDB
Unsuccessful: create table PlanetCheatSheet (planet tinyblob not null, mass double precision not null, numberOfInhabitants bigint not null, radius double precision not null, primary key (planet)) ENGINE=InnoDB
BLOB/TEXT column 'planet' used in key specification without a key length
Relevant MySQL documentation:
#BLOB and TEXT columns also can be indexed, but a prefix length must be given.