DELETES not able to return # rows deleted -- tried changes() and RETURNING COUNT(*) etc

[msiddiqui24]

DELETES not able to return # rows deleted -- tried changes() and RETURNING COUNT(*) etc

[griffio]

🗞️ This is related to issue #4578
Where the rows affected is not exposed(intentionally) from the driver (jdbc) implementation - so only Unit is returned.

The changes function is built into Sqlite, so won't work for other databases

As you mentioned, Postgresql can't use Returning with an aggregate function e.g RETURNING COUNT(*)

For SqlDelight, you can use a CTE like this for your query

delete:
WITH deleted_rows AS (
    DELETE FROM MyTable RETURNING *
)
SELECT COUNT(*) FROM deleted_rows;

Generates a query that returns the rows deleted

    val count = sample.testQueries.delete().executeAsOne()

[msiddiqui24]

this did not work for me, it does not successfully delete

[griffio]

🤔 I am not sure why that doesn't work

However, I can only provide a fully working Postgresql example https://github.com/griffio/sqldelight-postgres-example

e.g https://github.com/griffio/sqldelight-postgres-example/blob/master/src/main/sqldelight/griffio/queries/City.sq

See if that helps to solve issue