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

        Greg Monroe created issue -
        Thomas Fox made changes -
        Field Original Value New Value
        Assignee Thomas Fox [ tfischer ]
        Hide
        Thomas Fox added a comment -

        The test project now fails by default if the generated sql cannot be executed.
        This behaviour can be changed by adding -DonSqlError=continute in the maven command line.
        Checked against MySql 5.5, MSSQL 2012, Oracle 11g Express, Postgresql 9.1, Hsqldb 2.2.8 and Derby 10.8.2.2 that the test project runs without problems.

        Show
        Thomas Fox added a comment - The test project now fails by default if the generated sql cannot be executed. This behaviour can be changed by adding -DonSqlError=continute in the maven command line. Checked against MySql 5.5, MSSQL 2012, Oracle 11g Express, Postgresql 9.1, Hsqldb 2.2.8 and Derby 10.8.2.2 that the test project runs without problems.
        Thomas Fox made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 4.0 [ 12323291 ]
        Resolution Fixed [ 1 ]
        Thomas Fox made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Resolved Resolved
        21d 23h 57m 1 Thomas Fox 01/Feb/13 21:32
        Resolved Resolved Closed Closed
        29d 23h 6m 1 Thomas Fox 03/Mar/13 20:39

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development