Torque
  1. Torque
  2. TORQUE-251

fix SQL errors in the test project

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major 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)

        Activity

        Thomas Fox made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Thomas Fox made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 4.0 [ 12323291 ]
        Resolution Fixed [ 1 ]
        Thomas Fox made changes -
        Field Original Value New Value
        Assignee Thomas Fox [ tfischer ]
        Greg Monroe created issue -

          People

          • Assignee:
            Thomas Fox
            Reporter:
            Greg Monroe
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development