Thomas Fox created TORQUE-251:
---------------------------------
Summary: fix SQL errors in the test project
Key: TORQUE-251
URL: https://issues.apache.org/jira/browse/TORQUE-251
Project: Torque
Issue Type: Bug
Components: Test Project
Reporter: Greg Monroe
- 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)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
