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.
- 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_