[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4732) Update Teradata Dialect for Teradata 13.0

Update Teradata Dialect for Teradata 13.0 ----------------------------------------- Key: HHH-4732 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4732 Project: Hibernate Core Issue Type: Improvement Components: core Affects Versions: 3.3.2 Environment: Hibernate 3.3.2/ Teradata JDBC Driver 13.0, Teradata Database 13.0 Reporter: David Repshas Assignee: Strong Liu Attachments: teradata.zip, teradataDiff.zip, testsuiteMods.zip Would like to update Teradata Dialect to work with Teradata Database 13.0. I've include the following files with changes as noted: org.hibernate.dialect.dialect.java - added include of java.sql.statement - added code to support the removal of temporary files created when using referential integrity The three new methods are: public boolean supportsDropPreProcess() public String performDropPreProcess(Statement stmt, String dropSql) throws SQLException public void performDropPostProcess(Statement stmt, String dropSql) throws SQLException ================================== org.hibernate.dialect.TeradataDialect.java - added new include files - modified registerFunction calls for "current_time" and "current_date" - put registerKeyword list in alphabetical order and added keywords: column,map,password,summary, type, value and year - changed "getAddColumnString()" to return "Add" - added new methods: public ViolatedConstraintNameExtracter getViolatedConstraintNameExtracter() public String extractConstraintName(SQLException sqlex) public boolean supportsNotNullUnique() public boolean supportsExpectedLobUsagePattern() public boolean supportsUnboundedLobLocatorMaterialization() public boolean supportsDropPreProcess() public String performDropPreProcess(Statement stmt, String dropSql) throws SQLException public void performDropPostProcess(Statement stmt, String dropSql) throws SQLException ================================== org.hibernate.tool.hbm2ddl.SchemaExport - added hooks for new methods: supportsDropPreProcess,performDropPreProcess and performDropPostProcess ================================== Also made some changes to some of the files in testsuite: ============================================= test/hql/astParserLoadingTest.java - Add instance check of TeradataDialect to get correct behavior ============================================= test/legacy/foobartest.java - Add instance check of TeradataDialect to get correct behavior - modified SQL: Teradata requires "<>" rather than "!=" ============================================= test/typeParameters\typeparametertest.java -needed to disable these tests as Teradata locking was causing a deadlock situation when they run =============================================