Revisit SQL with `in('...')` queries

[ghillert]

trafficstars

As Oracle only permits 1000 elements in in('...') queries, we should test that behavior:

• Create test data that creates the breaking behavior
• Document the breaking point
• See if there are any issues with non-Oracle RDBMS
• As needed improve the queries e.g. by:
  • batching multiple SQL queries or by
  • creating multiple concatenated in('...') statements

[blueaadvark]

Hi,

I've updated DefaultTaskDeleteService to work with large deletes - tested against an Oracle DB. #4723 only partially fixed this, large deletion of Job and Step Executions were still failing.

Should I submit the change against this issue or create a new one?

thanks

[cppwfs]

Create a new issue. And link to this issue.