clockworklabs / SpacetimeDB

Multiplayer at the speed of light
https://spacetimedb.com
Other
4.12k stars 100 forks source link

Clients receive a subscription update when a custom SQL query is run from the CLI #1179

Open cloutiertyler opened 2 weeks ago

cloutiertyler commented 2 weeks ago

The BitCraft team ran into a situation where someone posted a chat message and they wanted to delete the row from ChatMessage. When they deleted the chat message using a DELETE FROM ChatMessage WHERE user_id=x they were able to delete the row but it didn't make the message disappear for clients. It appears that we don't send clients transaction updates after we are done processing a transaction which was started from a CLI SQL query.