SQLCODE returns 0 in the catch block even the query failed due to invalid identifier
SQLCODE is used in Snowflake Scripting to capture the error code returned from running a certain query so the script can decide how to handle the error. Recently I have seen some users reported that the SQLCODE returned 0 even though the query failed. I was able to demonstrate the issue using the below script: […]
