You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
but this generates invalid SQL: DELETE FROM "group_members" WHERE group_id = any($1,$2). (I am not sure why it doesn't support arrays when Dapper does, but that is not the point of this issue).
This generates a different invalid query: DELETE FROM "group_members" WHERE group_id = any(array"@p0,@p1")
I don't understand why this happens. Why is [square brackets] being changed to "quotation marks"? The documentation seems to say square brackets is column syntax in SQL Server, so I tried adding a ForPostgreSql to specify the SQL dialect i'm writing in, but that didn't change the result.
The text was updated successfully, but these errors were encountered:
I have the following SQL (postgres) query in Dapper:
in SqlKata I tried to write it like this:
but this generates invalid SQL:
DELETE FROM "group_members" WHERE group_id = any($1,$2)
. (I am not sure why it doesn't support arrays when Dapper does, but that is not the point of this issue).I tried rewriting the SqlKata query like this:
This generates a different invalid query:
DELETE FROM "group_members" WHERE group_id = any(array"@p0,@p1")
I don't understand why this happens. Why is
[square brackets]
being changed to"quotation marks"
? The documentation seems to say square brackets is column syntax in SQL Server, so I tried adding aForPostgreSql
to specify the SQL dialect i'm writing in, but that didn't change the result.The text was updated successfully, but these errors were encountered: