Verified Bug in MySQL Updates (20-MAR-2012 Nightly Build)

I created a simple "Concrete table inheritance" relationship as described here:

http://www.mindscapehq.com/blog/index.php/2009/03/01/getting-started-with-inheritance-in-lightspeed/

My base, abstract class (TrackableEntity) has Track Create/Update Time set to true and has both Created and Updated By string properties.

I saved these changes to the MySQL DB and got exactly the tables I expected in the way of actual tables. However, I noticed that the string fields were max character size, which was silly for my application.

I modified the model to set the Validate Length of the CreatedBy and ModifiedBy fields on the abstract base class to <= 256 and I saved and again updated the MySQL database.

The MySQL updates failed, because the DDL generated tried to alter a table named after the abstract base class, not the actual concrete class tables. For example:

Given an abstract base class of TrackableEntity (pluralization is on) and concrete classes of Book & Achievement, I would have expected the Book and Achievement tables to be altered. However, the following was produced instead:

-- Change column CreatedBy maximum length from 65535 to 256
ALTER TABLE `TrackableEntities` MODIFY `CreatedBy` VARCHAR(256) NULL;
/* ERROR:
Achievement: Change column CreatedBy maximum length from 65535 to 256
  - Table '482254_ReadingFeat_Dev.TrackableEntities' doesn't exist
*/;
-- Change column UpdatedBy maximum length from 65535 to 256
ALTER TABLE `TrackableEntities` MODIFY `UpdatedBy` VARCHAR(256) NULL;
/* ERROR:
Achievement: Change column UpdatedBy maximum length from 65535 to 256
  - Table '482254_ReadingFeat_Dev.TrackableEntities' doesn't exist
*/;
-- Change column CreatedBy maximum length from 65535 to 256
ALTER TABLE `TrackableEntities` MODIFY `CreatedBy` VARCHAR(256) NULL;
/* ERROR:
Book: Change column CreatedBy maximum length from 65535 to 256
  - Table '482254_ReadingFeat_Dev.TrackableEntities' doesn't exist
*/;
-- Change column UpdatedBy maximum length from 65535 to 256
ALTER TABLE `TrackableEntities` MODIFY `UpdatedBy` VARCHAR(256) NULL;
/* ERROR:
Book: Change column UpdatedBy maximum length from 65535 to 256
  - Table '482254_ReadingFeat_Dev.TrackableEntities' doesn't exist
*/;

Thanks for alerting us to this issue. It will be fixed in the next nightly build.

Glad I could help. Excellent, fast response. :-)