Uploaded image for project: 'Torque'
  1. Torque
  2. TORQUE-251

fix SQL errors in the test project

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0
    • Component/s: Test Project
    • Labels:
      None

      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)

        Attachments

          Activity

            People

            • Assignee:
              tfischer Thomas Fox
              Reporter:
              greg.monroe@dukece.com Greg Monroe
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: