SNOW-558109: QueryStatus Enum indicates "blocked" status is both running and an error

[taylor-dv]

When a statement is waiting for a lock, the query status may be "BLOCKED".

The two QueryStatus enum helper methods to determine if a query is still running or resulted in an error indicate that "BLOCKED" is both "RUNNING" and an "ERROR".

It does not make sense for "BLOCKED" to be both "RUNNING" and an "ERROR" when no other existing status is grouped liked this.

It seems like "BLOCKED" should be categorized the same as "QUEUED". Neither state are a result of some error in the query itself but rather the state of warehouse.

I'd like to propose "BLOCKED" be removed from the "ERROR" category. Alternatively query statues could be distinguished between waiting, running, and completed states.

[sfc-gh-igarish]

To clean up and re-prioritize more pressing bugs and feature requests we are closing all issues older than 6 months as of March 1, 2023. If there are any issues or feature requests that you would like us to address, please create them according to the new templates we have created. For urgent issues, opening a support case with this link Snowflake Community is the fastest way to get a response.

[bpodgursky]

bruh

[sfc-gh-igarish]

@sfc-gh-ext-simba-ti Our apps team (Josh Zana) interested in this fix.

[sfc-gh-dszmolka]

fixed in #1579 and released with 3.14.5