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

[sfc-gh-dszmolka]

unfortunately this question was left unanswered for a long time, and in the meanwhile many driver versions were released. Can I please ask you to file an Issue in this repo, if you're facing any unexpected behaviour with this or any other parts of the driver? Thank you in advance!

Going to close this now.