TASK_HISTORY Table Function (Information Schema): Consistent Values for Failed and Auto-suspended Tasks in ERROR_ONLY Output

Attention

This behavior change is in the 2023_03 bundle.

For the current status of the bundle, refer to Bundle History.

Auto suspended tasks which fail will be in state FAILED_AND_AUTO_SUSPENDED across all calls of the INFORMATION_SCHEMA.TASK_HISTORY table function:

Previously:

Calling TASK_HISTORY with ERROR_ONLY = true with auto-suspended tasks returns state = FAILED.

Currently:

Calling TASK_HISTORY with ERROR_ONLY = true with auto-suspended tasks returns state = FAILED_AND_AUTO_SUSPENDED.

Ref: 990