Alter Table Add Duplicate Column Returns Success Not Error


When you attempt to alter a table to add a column name of an existing column in the same table, an error is not returned, even though a column has not been added. Since ALTER TABLE is documented that ADD is also used for "CHANGING" attributes, the vendor does not return an error unless the ADD alters the storage requirements.