Duplicate Column name error message when importing patches

  • 7011076
  • 20-Jul-2011
  • 19-Oct-2012


You may see an error message while importing a cumulative database patch script such as the following:

ERROR 1060 (42S21) at line 11: Duplicate column name 'decision_certification_id'

In most cases these error messages are benign during the import of DB patch scripts on top of existing patches.

If your database version does not automatically ignore errors during the execution of ddl scripts you will need to add an option to the command line to force the entire DDL file to be interpreted.

For example in MySQL this is:   mysql --force < iiq-patch.ddl