(gravitino) branch main updated: [#9031] fix(policy): fix deletePolicyAndVersionMetasByLegacyTimeline error (#9032)

[jshao]

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

jshao pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/gravitino.git


The following commit(s) were added to refs/heads/main by this push:
     new 71de7a7e32 [#9031] fix(policy): fix 
deletePolicyAndVersionMetasByLegacyTimeline error (#9032)
71de7a7e32 is described below

commit 71de7a7e3296ff8d06df61c66538236f00e0418b
Author: mchades <liminghu...@datastrato.com>
AuthorDate: Fri Nov 7 10:03:05 2025 +0800

    [#9031] fix(policy): fix deletePolicyAndVersionMetasByLegacyTimeline error 
(#9032)
    
    ### 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
---
 .../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 43b3befa29..328a3ca16f 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 fd80230fcb..a9371ec71e 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