Using activityId(..) and processInstanceBusinessKey(.., true) on Execution-query causes SQL-exception

Description

See: http://forums.activiti.org/content/have-query-process-instance-business-key-and-then-execution-1

That's indeed a bug, what using activityId and processInstanceBusinessKey(..., true) together. The IS_ACTIVE_ is no longer unique, since the process-definition is joined in, having both the ACT_RU_EXECUTION and ACT_RE_PROCDEF IS_ACTIVE_ columns in the query scope.

Environment

None

Assignee

Frederik Heremans

Reporter

Frederik Heremans

Labels

None

Fix versions

Affects versions

Priority

Major
Configure