sql

All things SQL and JDBC...
jsyrjala 2020-09-17T13:25:15.391700Z

@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

jsyrjala 2020-09-17T13:25:22.391800Z

> 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.

seancorfield 2020-09-17T16:35:40.392100Z

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:

seancorfield 2020-09-17T16:35:50.392300Z

Thanks for the follow-up tho'...