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: [1]. When tested with hibernate.show_sql=true property, it fails on this SQL statement: [2]. 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. [1] http://pastebin.com/nmtjaZbC [2] http://pastebin.com/8nHdB4vK Version-Release number of selected component (if applicable): 6.2.0.ER3 How reproducible: Execute TaskQueryBuilderLocalTest.testGetTasksByVariousFieldsWithUserGroupCallback() on one of supported production database systems.
Fixed. Commits: 6.3.x: https://github.com/droolsjbpm/jbpm/commit/4b9cf010 master; https://github.com/droolsjbpm/jbpm/commit/0987f956
These commits were also part of the fix: 6.3.x: https://github.com/droolsjbpm/droolsjbpm-integration/commit/30b35244 master: https://github.com/droolsjbpm/droolsjbpm-integration/commit/df5e8743
Verified in 6.2.0.ER5 by running community test suite on supported DB systems. All tests that were failing pass now.