Are queries still running or in an error status for RESTARTED and BLOCKED?

[hota911]

Hi,

We are using Snowflake-jdbc to get the result of queries.

        val resultSet = connection.unwrap(SnowflakeConnection::class.java).createResultSet(queryId)
        val queryStatus = resultSet.unwrap(SnowflakeResultSet::class.java).status

        var result: String
        if (queryStatus == QueryStatus.SUCCESS) {
            result = "success"
        } else if (QueryStatus.isStillRunning(queryStatus)) {
            result = "running"
        } else if (QueryStatus.isAnError(queryStatus)) {
            result = "failed"
        } else {
            result = "unknown"
        }

1. The RESTARTED status is "unknown" because isStillRunning returns false and isAnError returns false, but I guess it "is still running". Should isStillRunning return true?
2. The BLOCKED status is "running" because isStillRunning returns true. However, isAnError also returns true. I think isAnError should return false for any status that isStillRunning returns true because, well, is still running. So isAnError should return false for BLOCKED?

https://github.com/snowflakedb/snowflake-jdbc/blob/v3.13.32/src/main/java/net/snowflake/client/core/QueryStatus.java

Thank you,
Hiroyuki