justinmclean commented on issue #8307:
URL: https://github.com/apache/gravitino/issues/8307#issuecomment-3230577885
Sorry, there's an issue there, but I did not describe it correctly.
PostgreSQL does not directly support the LIMIT clause within UPDATE or DELETE
statements in the same way it does for SELECT statements. To do this, you would
need to add an IN clause like:
```
+ " WHERE id IN (SELECT id FROM "
+ POLICY_VERSION_TABLE_NAME
+ " WHERE policy_id = #{policyId} AND version <
#{versionRetentionLine}"
+ " AND deleted_at = 0 LIMIT #{limit})";
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
