(gravitino) branch branch-1.0 updated: [#9031] fix(policy): fix deletePolicyAndVersionMetasByLegacyTimeline error (#9033)

[roryqi]

This is an automated email from the ASF dual-hosted git repository.

roryqi pushed a commit to branch branch-1.0
in repository https://gitbox.apache.org/repos/asf/gravitino.git


The following commit(s) were added to refs/heads/branch-1.0 by this push:
     new dde677efb4 [#9031] fix(policy): fix 
deletePolicyAndVersionMetasByLegacyTimeline error (#9033)
dde677efb4 is described below

commit dde677efb45f0c0fea6ec6ed90d4e3f580f67cba
Author: github-actions[bot] 
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Nov 7 14:06:35 2025 +0800

    [#9031] fix(policy): fix deletePolicyAndVersionMetasByLegacyTimeline error 
(#9033)
    
    ### What changes were proposed in this pull request?
    
    fix deletePolicyAndVersionMetasByLegacyTimeline error
    
    ### Why are the changes needed?
    
    
    Fix: #9031
    
    ### Does this PR introduce _any_ user-facing change?
    
    no
    
    ### How was this patch tested?
    
    by eyes
    
    Co-authored-by: mchades <liminghu...@datastrato.com>
---
 .../mapper/provider/postgresql/PolicyMetaPostgreSQLProvider.java        | 2 +-
 .../mapper/provider/postgresql/PolicyVersionPostgreSQLProvider.java     | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git 
a/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/postgresql/PolicyMetaPostgreSQLProvider.java
 
b/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/postgresql/PolicyMetaPostgreSQLProvider.java
index 1b6ec91b74..f785934f6f 100644
--- 
a/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/postgresql/PolicyMetaPostgreSQLProvider.java
+++ 
b/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/postgresql/PolicyMetaPostgreSQLProvider.java
@@ -51,7 +51,7 @@ public class PolicyMetaPostgreSQLProvider extends 
PolicyMetaBaseSQLProvider {
         + POLICY_META_TABLE_NAME
         + " WHERE policy_id IN (SELECT policy_id FROM "
         + POLICY_META_TABLE_NAME
-        + " WHERE deleted_at = 0 AND legacy_timeline < #{legacyTimeline} LIMIT 
#{limit})";
+        + " WHERE deleted_at > 0 AND deleted_at < #{legacyTimeline} LIMIT 
#{limit})";
   }
 
   @Override
diff --git 
a/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/postgresql/PolicyVersionPostgreSQLProvider.java
 
b/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/postgresql/PolicyVersionPostgreSQLProvider.java
index 610ee08587..85b4a79d75 100644
--- 
a/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/postgresql/PolicyVersionPostgreSQLProvider.java
+++ 
b/core/src/main/java/org/apache/gravitino/storage/relational/mapper/provider/postgresql/PolicyVersionPostgreSQLProvider.java
@@ -48,7 +48,7 @@ public class PolicyVersionPostgreSQLProvider extends 
PolicyVersionBaseSQLProvide
         + POLICY_VERSION_TABLE_NAME
         + " WHERE id IN (SELECT id FROM "
         + POLICY_VERSION_TABLE_NAME
-        + " WHERE deleted_at = 0 AND legacy_timeline < #{legacyTimeline} LIMIT 
#{limit})";
+        + " WHERE deleted_at > 0 AND deleted_at < #{legacyTimeline} LIMIT 
#{limit})";
   }
 
   @Override