Red Hat Bugzilla – Bug 1266556
TaskQueryBuilder tests failing - not a group by expression
Last modified: 2016-09-20 01:13:17 EDT
Description of problem:
Test TaskQueryBuilderLocalTest.testGetTasksByVariousFieldsWithUserGroupCallback(), which is located in module jbpm-human-task fails when executed on supported production DB systems. Exception thrown on Oracle 11gR2 is here: .
When tested with hibernate.show_sql=true property, it fails on this SQL statement: .
The problem is related to group by expression. All columns should be in this case part of group by expression or as @mriet noted, DISTINCT should be used instead. Problematic method that adds group by clause is TaskQueryCriteriaUtil.groupTaskIdWhenLefOuterJoinsPresent.
Version-Release number of selected component (if applicable): 6.2.0.ER3
Execute TaskQueryBuilderLocalTest.testGetTasksByVariousFieldsWithUserGroupCallback() on one of supported production database systems.
These commits were also part of the fix:
Verified in 6.2.0.ER5 by running community test suite on supported DB systems. All tests that were failing pass now.