Message Title

Andrea Boriero created an issue

HHH-10141

Issue Type:	Bug
Affects Versions:	5.0.1
Assignee:	Andrea Boriero
Components:	hibernate-envers
Created:	28/Sep/2015 07:30 AM
Environment:	Apache Derby
Fix Versions:	5.0.2
Priority:	Major
Reporter:	Andrea Boriero

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

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..

The test

 
                                                    ClassicQueryTranslatorFactoryTest#testHistoryOfId1()

fails

Add Comment

This message was sent by Atlassian JIRA