search

snowflakedb / snowflake-jdbc

Snowflake JDBC Driver
Apache License 2.0
176 stars 167 forks source link

SNOW-622919: Column not found: value #1083

Closed kassak closed 1 year ago

kassak commented 2 years ago

Hi! I have an exception:

java.sql.SQLException: Column not found: value
    at net.snowflake.client.jdbc.SnowflakeBaseResultSet.findColumn(SnowflakeBaseResultSet.java:295)
    at net.snowflake.client.jdbc.SnowflakeBaseResultSet.getString(SnowflakeBaseResultSet.java:141)
    at net.snowflake.client.jdbc.SnowflakeDatabaseMetaData.getProcedureColumns(SnowflakeDatabaseMetaData.java:1137)

Looks like the problem is here: https://github.com/snowflakedb/snowflake-jdbc/blob/152dd60f0a8bba65c4887c6a7a3232a576c7d532/src/main/java/net/snowflake/client/jdbc/SnowflakeDatabaseMetaData.java#L1159

There is no check for empty resultset (for because of the failed query: executeAndReturnEmptyResultIfNotFound) I think the query fails because of ASSOCIATE_SEMANTIC_CATEGORY_TAGS lurking everywhere

sfc-gh-wshangguan commented 1 year ago

https://github.com/snowflakedb/snowflake-jdbc/pull/1317 will be included in next release.