Ticket #231 (closed defect: wontfix)

Opened 7 months ago

Last modified 16 hours ago

midgard-schema doesn't rename columns properly

Reported by: flack Assigned to: piotras
Priority: major Milestone: 8.09 Ragnaroek
Component: Midgard Core Version: 1.8 Thor
Keywords: Cc:

Description

When you edit a schema XML file and change the name of a property like this: 

old:
    <property name="wieght" type="float" dbtype="double" />
new:
    <property name="weight" type="float" dbtype="double" />

and run midgard-schema, it will produce a new column and keep the old one, so if you change the name of the property five times, you will end up with five unused columns in the database.

tested with 1.8.7

Change History

09/30/08 14:48:51 changed by bergie

  • milestone set to 1.8 Thor.

10/07/08 16:09:35 changed by bergie

  • milestone changed from 1.8 Thor to 8.09 Ragnaroek.

Reassigning to Ragnaroek as that is now the stable branch.

10/07/08 16:25:07 changed by piotras

  • status changed from new to closed.
  • resolution set to wontfix.

It's impossible to fix without table names versioning. Or it's possible with clear rule: "delete everything what's in table and not defined in schema".