Changeset 1407

Timestamp:

Jan 18, 2011, 1:43:11 PM (12 years ago)

Author:

work@…

Message:

• fixes an issue with database upgrade script

File:

• trunk/grails-app/conf/DatabaseUpgrade.groovy (modified) (3 diffs)

trunk/grails-app/conf/DatabaseUpgrade.groovy

@@ -29 +29 @@
 
                 // execute per-change check and upgrade code
-                changeStudyDescription(sql, db)                 // r1245 / r1246
-                changeStudyDescriptionToText(sql, db)   // r1327
-                changeTemplateTextFieldSignatures(sql, db) // prevent Grails issue, see http://jira.codehaus.org/browse/GRAILS-6754
+                changeStudyDescription(sql, db)                         // r1245 / r1246
+                changeStudyDescriptionToText(sql, db)           // r1327
+                changeTemplateTextFieldSignatures(sql, db)      // prevent Grails issue, see http://jira.codehaus.org/browse/GRAILS-6754
         }
 
@@ -107 +107 @@
         /**
          * it appears that some TEXT template fields are not of type 'text'
-         * which results in the '255' character issue
+         * due to an issue in how Grails' GORM works with domain inheritance
+         * (see http://jira.codehaus.org/browse/GRAILS-6754)
          * @param sql
          * @param db
@@ -119 +120 @@
                                 try {
                                         // change the datatype of text fields to text
-                                        sql.execute("ALTER TABLE ${row.tablename.toString()} ALTER COLUMN template_text_fields_elt TYPE text")
-                                        sql.execute("ALTER TABLE ${row.tablename.toString()} ALTER COLUMN template_text_fields_string TYPE text")
+                                        sql.execute(sprintf("ALTER TABLE %s ALTER COLUMN template_text_fields_elt TYPE text", row.tablename))
+                                        sql.execute(sprintf("ALTER TABLE %s ALTER COLUMN template_text_fields_string TYPE text", row.tablename))
 
                                 } catch (Exception e) {