False positives with Postgres RETURNING queries

[acim]

Postgres queries have options to return values in INSERT and UPDATE queries. It is false positive to replace Query or QueryRow with Execute in such cases.

[1uf3]

MySQL add RETURNING v8.0.21
https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-R

RETURNING; added in 8.0.21 (nonreserved)

[bconway]

I have run into the same false positive with Postgres. Not sure what MySQL versioning has to do with it?

[acim]

Well, I would say @lufeee means that may be the MySQL problem as well. However, I think this is deeper problem than this because if the first argument of a query is function, this static check always shows falls positive. I would recommend that if test is not absolutely sure, better to show negative.

[1uf3]

@acim you mean if you use the golangci-lint, execinquery is always enable. so you should do disable. to @bconway right?

[acim]

I did so but just wanted to report the bug. Thank you.

[1uf3]

OK Thanks for reporting!