Details
-
Task
-
Resolution: Fixed
-
L3 - Default
-
7.3.1
-
Camunda BPM 7.3.X
WebSphere
DB2
Description
The job acquisition query selects only active jobs. For reasons of backwards compatibility, an active job has SUSPENSION_STATE_ = 1 or SUSPENSION_STATE_ is null. This additional null check makes the acquisition query more complex, posing problems on some databases for index usage.
AT:
- the SUSPENSION_STATE_ column is declared NOT NULL and has a default value 1 (active)
- the job acquisition query no longer performs a null check for SUSPENSION_STATE_