project_key: JBPAPP6 Created : https://hibernate.onjira.com/browse/HHH-7281 Quite a few tests started failing asking for explicit typecasts after upgrade of dialect in postgresql https://hudson.qa.jboss.com/hudson/view/EAP6/view/EAP6-Hibernate/job/eap6-hibernate-core-master-testsuite/database=postgresql91,jdk=java16_default,label=hibernate/lastCompletedBuild/testReport/ Exception which varies in failing tests but core reason is same:(for eg) org.hibernate.exception.SQLGrammarException: ERROR: operator does not exist: integer = boolean Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 427 Stacktrace org.hibernate.exception.SQLGrammarException: ERROR: operator does not exist: integer = boolean Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. Position: 427 at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122) at I found this issue in previous version of the product which was fixed by skipping some queries in the test specific to dialect and i think the new dialect should be added similarly. Referring older issues https://issues.jboss.org/browse/JBPAPP-2716 https://hibernate.onjira.com/browse/HHH-4115
alright, just change the dialect back to _org.hibernate.dialect.PostgreSQLDialect_ we have this code {quote} @Deprecated public class PostgreSQLDialect extends PostgreSQL82Dialect { } {quote} so, change it back won't missing anything wrt testing, these are just caused by the bad test for example, the _org.hibernate.test.bidi.AuctionTest.testLazy_, it seems this @SkipForDialect won't skip if a parent class is used here. {quote} @Test @SuppressWarnings( {"unchecked"}) @SkipForDialect( value = PostgreSQLDialect.class, comment = "doesn't like boolean=1" ) public void testLazy() {quote}
reassigning to myself to revert the change in dialect,Strong please resolve the hibernate jira we dont need to revert the dialect as it has been fixed in code...reassigning to Strong for update
this will be included into next eap build, meanwhile, for the QA testing of ER6, it is still needed to use _PostgreSQLDialect_
Link: Added: This issue is related to JBPAPP-8827
Link: Removed: This issue is related to JBPAPP-8827
Link: Added: This issue is a dependency of JBPAPP-8827
Strong, I still see test failures with ER7 on postgre with the new dialect https://hudson.qa.jboss.com/hudson/view/EAP6/view/EAP6-Hibernate/job/eap6-hibernate-core-master-testsuite/186/database=postgresql91,jdk=java16_default,label=hibernate/ this is only test issue but i am reopening the jira.
https://hibernate.onjira.com/browse/HHH-7346
test only issue, will be included in EAP 6.0.1
Link: Added: This issue is a dependency of JBPAPP-9292
Link: Removed: This issue is a dependency of JBPAPP-8827
Verified.
Docs QE Status: Removed: NEW