DaveBirdsall opened a new pull request #1846: [TRAFODION-3314] Avoid generating redundant DDL in OSIM for unique constraints URL: https://github.com/apache/trafodion/pull/1846 The problem: When a table has a unique constraint, OSIM generates both the ALTER TABLE statement to create the constraint and the CREATE INDEX statement for the system-generated index into CREATE_TABLES_DDL.txt. When we then do OSIM LOAD, the CREATE INDEX is executed, then the ALTER TABLE. The ALTER TABLE fails because the index already exists. The fix: Don't write the CREATE INDEX to the CREATE_TABLES_DDL.txt file.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
