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