3.3.0 GA with MySQL 5.0 throws table validation exception
---------------------------------------------------------

          Key: HHH-3440
          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3440
        Project: Hibernate3
      Issue Type: Bug
      Components: core
  Affects Versions: 3.3.0.GA
     Environment: Hibernate 3.3.0 GA
MySQL 5.0
JBoss 4.2.2
       Reporter: Carlo Luib-Finetti


Hibernate immediately throws an exception at application startup, when it does the schema validation.

org.hibernate.HibernateException: Wrong column type in dpjw.assessment for column NOTES. Found: text, expected: longtext


Comparing the sources of 3.2.0 with 3.3.0 I can see that someone set two java statements into comment. The 3.2 version of MySQLDialect.java looks like this:

 protected void registerVarcharTypes() {
   registerColumnType( Types.VARCHAR, "longtext" );
   registerColumnType( Types.VARCHAR, 16777215, "mediumtext" );
   registerColumnType( Types.VARCHAR, 65535, "text" );
   registerColumnType( Types.VARCHAR, 255, "varchar($l)" );
 }


while the new 3.3.0 version is this:

 protected void registerVarcharTypes() {
   registerColumnType( Types.VARCHAR, "longtext" );
//    registerColumnType( Types.VARCHAR, 16777215, "mediumtext" );
//    registerColumnType( Types.VARCHAR, 65535, "text" );
   registerColumnType( Types.VARCHAR, 255, "varchar($l)" );
 }

If I uncomment these (and others in the same Java file!), the validation process is ok.

Is there any reason why these statements (and others!) were commented out???

--
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

   
_______________________________________________
hibernate-issues mailing list
hibernate-issues@(protected)
https://lists.jboss.org/mailman/listinfo/hibernate-issues