[hibernate-issues] [Hibernate-JIRA] Issue Comment Edited: (HHH-7313) DiscriminatorFormulaTest in Hibernate envers Testsuite fails on Sybase(15.7)

[ https://hibernate.onjira.com/browse/HHH-7313?page=com.atlassian.jira.plug... ] Lukasz Antoniak edited comment on HHH-7313 at 5/12/12 5:46 AM: --------------------------------------------------------------- Madhumita, could you please attach the complete console output of this test (http://ci.jboss.org/jenkins/view/hibernate/ temporarily unavailable)? I cannot reproduce this issue on up-to-date (12 May 2012) master branch running local Sybase 15.7 database. The following query is executed without any issues: {code:sql} 12:42:37,000 DEBUG SQL:104 - select childentit0_.id as id12_, childentit0_.REV as REV12_, childentit0_.REVTYPE as REVTYPE12_, childentit0_.REVEND as REVEND12_, childentit0_.data as data12_, childentit0_.typeId as typeId12_, childentit0_.specificData as specificData12_ from ParentEntity_AUD childentit0_ where ( SELECT c.type FROM ClassTypeEntity c WHERE c.id = childentit0_.typeId )='Child' and childentit0_.id=? and ( childentit0_.REVEND is null ) for update {code} Query runs correctly from Interactive SQL tool as well (see attachment). I am using {{org.hibernate.dialect.SybaseASE157Dialect}} dialect and {{com.sybase.jdbc4.jdbc.SybDriver}} driver class. Sybase JDBC driver details: {code} Implementation-Vendor: Sybase, an SAP Company Implementation-Title: com.sybase.jdbc4.utils Implementation-Version: JDK 1.6/jdbcmain/Tue Dec 20 04:41:18 PST 2011 Specification-Vendor: Sybase, an SAP Company Built-By: nnishant Created-By: 1.6.0_03 (Sun Microsystems Inc.) Specification-Title: jConnect (TM) for JDBC(TM) Specification-Version: jConnect (TM) for JDBC(TM)/7.07 GA(Build 26686) /P/EBF19793/JDK 1.6.0/jdbcmain/Tue Dec 20 04:39:14 PST 2011 Main-Class: com.sybase.jdbc4.utils.SybVersion {code} was (Author: lukasz.antoniak): Madhumita, could you please attach the complete console output of this test (http://ci.jboss.org/jenkins/view/hibernate/ temporarily unavailable)? I cannot reproduce this issue on up-to-date (12 May 2012) master branch running local Sybase 15.7 database. The following query is executed without any issues: {code:sql} 12:42:37,000 DEBUG SQL:104 - select childentit0_.id as id12_, childentit0_.REV as REV12_, childentit0_.REVTYPE as REVTYPE12_, childentit0_.REVEND as REVEND12_, childentit0_.data as data12_, childentit0_.typeId as typeId12_, childentit0_.specificData as specificData12_ from ParentEntity_AUD childentit0_ where ( SELECT c.type FROM ClassTypeEntity c WHERE c.id = childentit0_.typeId )='Child' and childentit0_.id=? and ( childentit0_.REVEND is null ) for update {code} Query runs correctly from Interactive SQL tool as well (see attachment). I am using {{org.hibernate.dialect.SybaseASE157Dialect}} dialect and {{com.sybase.jdbc4.jdbc.SybDriver}} driver class. Sybase JDBC driver details: Implementation-Vendor: Sybase, an SAP Company Implementation-Title: com.sybase.jdbc4.utils Implementation-Version: JDK 1.6/jdbcmain/Tue Dec 20 04:41:18 PST 2011 Specification-Vendor: Sybase, an SAP Company Built-By: nnishant Created-By: 1.6.0_03 (Sun Microsystems Inc.) Specification-Title: jConnect (TM) for JDBC(TM) Specification-Version: jConnect (TM) for JDBC(TM)/7.07 GA(Build 26686) /P/EBF19793/JDK 1.6.0/jdbcmain/Tue Dec 20 04:39:14 PST 2011 Main-Class: com.sybase.jdbc4.utils.SybVersion -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira