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

[jshao]

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

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

commit da57dc914b066d0bfd1aca47d01d24c7c50c59c7
Author: github-actions[bot] 
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Nov 11 11:05:57 2025 -0800

    [#8979][FOLLOWUP] Fix the index names of statistic and job name in the 
upgrade script (#9069)
    
    ### 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.
    
    Co-authored-by: roryqi <h...@datastrato.com>
---
 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';