Re: [hibernate-dev] envers + classic QueryTranslator failing test

This test was originally added for https://hibernate.atlassian.net/browse/HHH-8497 I guess my first thought is to question is why this test exists at all. It's really a question of whether we consider the classic HQL translator "supported". Stuff like this "parameter expected type" was developed specifically as part of the Antlr translator. The classic translator simply does not know this information. For what its worth, my $.02 to that question is that we should not support the classic translator. However... But then I dug a little deeper. Unless I missed it, you did not say exactly which test (method) fails. But I do not see a place where the user is executing any HQL. So that tells me this is potentially a problem specifically in how envers builds a query internally somewhere. And that, if true, is something we should address. So which test method specifically fails? On Thu, Sep 17, 2015 at 6:09 AM andrea boriero <andrea(a)hibernate.org&gt; wrote: > I'm working on https://hibernate.atlassian.net/browse/HHH-9996 > and I stumbled across the following test: > > > org.hibernate.envers.test.integration.basic.ClassicQueryTranslatorFactoryTest > > I run the test not only with Derby but also with PostgreSQL and the test > fails for both. > > The query: > select e__ from org.hibernate.envers.test.entities.IntTestEntity_AUD e__ > where e__.originalId.REV.id = (select max(e2__.originalId.REV.id) from > org.hibernate.envers.test.entities.IntTestEntity_AUD e2__ where e2__. > originalId.REV.id <= :revision and e__.originalId.id = > e2__.originalId.id) > and e__.REVTYPE <> :_p0 and e__.originalId.id = :_p1 > > causes the error java.sql.SQLException: An attempt was made to put a data > value of type 'byte[]' into a data value of type 'SMALLINT'. in Derby > > while in PostgreSQL the error is org.postgresql.util.PSQLException: ERROR: > operator does not exist: smallint <> bytea Hint: No operator matches the > given name and argument type(s). > > The problem is related with > > org.hibernate.hql.internal.classic.QueryTranslatorImpl$ParameterTranslations#getNamedParameterExpectedType(String > name) returning null for the _p0 parameter (while the correct return type > should be ReivsionTyptType) this cause the wrong sql bind.. > > Any help is more than welcome? > > Thanks > > Andrea > _______________________________________________ > hibernate-dev mailing list > hibernate-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/hibernate-dev >