(gravitino) branch main updated: [#8979][FOLLOWUP] Fix the index names of statistic and job name in the upgrade script (#9067)

[mchades]

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

mchades 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 fa4e1095c4 [#8979][FOLLOWUP] Fix the index names of statistic and job 
name in the upgrade script (#9067)
fa4e1095c4 is described below

commit fa4e1095c4a06a75c0081e5a403c83365898ab81
Author: roryqi <h...@datastrato.com>
AuthorDate: Tue Nov 11 21:27:24 2025 +0800

    [#8979][FOLLOWUP] Fix the index names of statistic and job name in the 
upgrade script (#9067)
    
    ### What changes were proposed in this pull request?
    
    Rename index names. Keep consistent with the initial sql script.
    
    ### Why are the changes needed?
    
    Fix: #8979
    
    ### Does this PR introduce _any_ user-facing change?
    
    No.
    
    ### How was this patch tested?
    
    Existing UT.
---
 scripts/postgresql/upgrade-0.9.0-to-1.0.0-postgresql.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/scripts/postgresql/upgrade-0.9.0-to-1.0.0-postgresql.sql 
b/scripts/postgresql/upgrade-0.9.0-to-1.0.0-postgresql.sql
index 5d8f541fca..0157a3ecad 100644
--- a/scripts/postgresql/upgrade-0.9.0-to-1.0.0-postgresql.sql
+++ b/scripts/postgresql/upgrade-0.9.0-to-1.0.0-postgresql.sql
@@ -115,8 +115,8 @@ CREATE TABLE IF NOT EXISTS statistic_meta (
     UNIQUE (statistic_name, metadata_object_id, deleted_at)
 );
 
-CREATE INDEX IF NOT EXISTS policy_relation_meta_idx_stid ON statistic_meta 
(statistic_id);
-CREATE INDEX IF NOT EXISTS policy_relation_meta_idx_moid ON statistic_meta 
(metadata_object_id);
+CREATE INDEX IF NOT EXISTS statistic_meta_idx_stid ON statistic_meta 
(statistic_id);
+CREATE INDEX IF NOT EXISTS statistic_meta_idx_moid ON statistic_meta 
(metadata_object_id);
 COMMENT ON TABLE statistic_meta IS 'statistic metadata';
 COMMENT ON COLUMN statistic_meta.id IS 'auto increment id';
 COMMENT ON COLUMN statistic_meta.statistic_id IS 'statistic id';
@@ -171,8 +171,8 @@ CREATE TABLE IF NOT EXISTS job_run_meta (
     UNIQUE (metalake_id, job_execution_id, deleted_at)
 );
 
-CREATE INDEX IF NOT EXISTS policy_relation_meta_idx_job_template_id ON 
job_run_meta (job_template_id);
-CREATE INDEX IF NOT EXISTS policy_relation_meta_idx_job_execution_id ON 
job_run_meta (job_execution_id);
+CREATE INDEX IF NOT EXISTS job_run_meta_idx_job_template_id ON job_run_meta 
(job_template_id);
+CREATE INDEX IF NOT EXISTS job_run_meta_idx_job_execution_id ON job_run_meta 
(job_execution_id);
 COMMENT ON TABLE job_run_meta IS 'job run metadata';
 COMMENT ON COLUMN job_run_meta.job_run_id IS 'job run id';
 COMMENT ON COLUMN job_run_meta.job_template_id IS 'job template id';