[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3015) mysql fail generating index for index property on column tag

[Marco Oreste Pogliaghi (JIRA)]

mysql fail generating index for index property on column tag 
-------------------------------------------------------------

                 Key: HHH-3015
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3015
             Project: Hibernate3
          Issue Type: Improvement
    Affects Versions: 3.2.5
         Environment: Hibernate 3.2.5, database mysql 5.0.41
            Reporter: Marco Oreste Pogliaghi
            Priority: Minor


Having a table definition of this type:
------------------------------------
<hibernate-mapping>
    <class name="my.Table" table="mytable">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native" />
        </id>
        <property name="code" type="java.lang.String">
            <column name="code" 
            length="6"
            unique="true"
            index="mytable_code_idx" />
        </property>
</hibernate-mapping>
------------------------------

when translating index property for field code, the generated sql for mysql is:
     create index mytable_code_idx on mytable(code)

if the user has no full index privilege, this line result in an error:
     INDEX command denied to user...

translating the generation of the index as
     alter table mytable add index mytable_code_idx (code)

will succed also for user with index privileges only on the table.



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira