Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-3068

in MySQL, BLOBS should specify a length/number of bytes for fields in index

    XMLWordPrintable

Details

    • Release Notes
    • Workaround Exists
    • Hide

      Currently the workaround is write the DDL yourself if Enum type property has to be mapped as @Id.

      Show
      Currently the workaround is write the DDL yourself if Enum type property has to be mapped as @Id.

    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.

      http://dev.mysql.com/doc/refman/5.0/en/create-index.html

      Attachments

        Activity

          People

            shaozliu Strong Liu(刘少壮) (Inactive)
            jpkroehling@redhat.com Juraci Paixão Kröhling (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: