[TORQUE-251] fix SQL errors in the test project

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0
• Component/s: Test Project
• Assignee: Thomas Fox
• Reporter: Greg Monroe
• Created: 10/Jan/13 21:34
• Updated: 03/Mar/13 20:39
• Resolved: 01/Feb/13 21:32

Description

• Running Test project against MySQL 5.1 produces errors in the
  sql:execute phase: Problem sql files are:

• bookstore-schema ( ALTER TABLE / FOREIGN KEY statements)
• databaseMapInit-schema.sql (mostly creating date field defaults
  and some alter table/foreign key statements )
• pk-schema.sql (Table exists error)
• test-schema.sql (ALTER TABLE / FOREIGN KEY statements)
• pk-schema-idtable-init.sql (Insert failed because of duplicate key)

Note: Some of errors get hidden during second run with tables created.

• Running Test project against MS SQL 2005 produces errors in the
  sql:execute phase. Problem sql files are:

• bookstore-schema.sql ( ALTER TABLE / DROP CONSTRAINT statments and
  DROP VIEW statement)
• default-value-schema.sql ( mostly creating date field defaults
  and some alter table drop constraint key statements )
• pk-schema.sql (Table exists error)
• qualified-table-name-schema.sql (Schema exists on 2nd run)
• save-method-in-peer-schema.sql (ALTER TABLE / DROP CONSTRAINT stmts)
• test-schema.sql (ALTER TABLE/DROP CONSTRAINT and CREATE BASE table)
• pk-schema-idtable-init.sql (Insert failed because of duplicate key)