[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5056) Criteria API with ProjectionList and Unique result

Criteria API with ProjectionList and Unique result -------------------------------------------------- Key: HHH-5056 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5056 Project: Hibernate Core Issue Type: Bug Components: query-criteria Affects Versions: 3.5.0-CR-2 Environment: Hibernate 3.3.2, Oracel 11g Reporter: Ahmed Ali Elsayed Ali Soliman Assignee: Gail Badner Priority: Critical Attachments: Beans & Mappings.rar, DistinctFieldsResultTransformer.java, HibernateTest.rar when you make a select statement with Criteria API & use ProjectionList to retrieve some columns then use the unique result make at least 2 projection list (2 columns or more) ProjectionList projectionList = Projections.projectionList() .add(Projections.property("ColumnA")) .add(Projections.property("ColumnB")); criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY); the result must be retrieved in 2 dimensional array of Object(Object[][]) but the result are one dimensional array with one column only. Note:- when you remove the unique result it works fine but when you add it, it make this behavior.