Fork me on GitHub
#sql
<
2020-09-17
>
jsyrjala13:09:15

@seancorfield Snowflake support’s response about the getGeneratedKeys() returning an empty result set that has null for metadata. Related to discussion a couple weeks ago

jsyrjala13:09:22

> Engineering and I have reviewed it and in our perspective, it is an expected behaviour. The reason behind getMetadata() returning null for an empty result set is because no metadata exists for type EmptyResultSet. So, technically we do implement the getGeneratedKeys() function; there are just never any keys.

seancorfield16:09:40

Well, I'd say they're categorically wrong based on the JDBC spec but, hey, next.jdbc "supports" their weird behavior now so... 🤷:skin-tone-2:

seancorfield16:09:50

Thanks for the follow-up tho'...