SpacetimeDB icon indicating copy to clipboard operation
SpacetimeDB copied to clipboard

SQL - `update` and `delete` queries do not return any rows

Open bfops opened this issue 9 months ago • 2 comments

When running an update or delete query in SQL, the API does not return any rows (although it does do the operation properly).

This was the root cause of https://github.com/clockworklabs/SpacetimeDB/issues/2358.

bfops avatar Mar 11 '25 17:03 bfops

Previously it returned a single header row specifying the number of rows updated/deleted.

joshua-spacetime avatar Mar 11 '25 17:03 joshua-spacetime

Is now clear that the task is recover the functionality to show the number of rows updated/deleted/inserted. Today is implemented the fix to not crash.

mamcx avatar Mar 13 '25 15:03 mamcx