[hibernate-dev] envers + classic QueryTranslator failing test

[Steve Ebersole]

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 at hibernate.org> 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 at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>