jaybird icon indicating copy to clipboard operation
jaybird copied to clipboard

Inserts through updatable result sets should report generated values (ids, default values, etc)

Open mrotteveel opened this issue 8 months ago • 0 comments

Currently, inserts through updatable result sets simply store the row value sent to the server to report when the result set requests that row. This can mean it does not have generated values (ids, default values, etc.), and instead reports null for those columns.

To be able to get the generated values, we'd need to use the generated-keys facility and/or explicitly use RETURNING to populate (or complete) the row with the server-side values.

mrotteveel avatar Apr 16 '25 12:04 mrotteveel