(gravitino) branch main updated: [#9225] fix(scripts): Fix errors in upgrade scripts in PG (#9226)

[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 a381489798 [#9225] fix(scripts): Fix errors in upgrade scripts in PG  
(#9226)
a381489798 is described below

commit a3814897987da3c42ee322eff1f6d588ca6101f1
Author: Mini Yu <y...@datastrato.com>
AuthorDate: Tue Nov 25 14:27:08 2025 +0800

    [#9225] fix(scripts): Fix errors in upgrade scripts in PG  (#9226)
    
    ### What changes were proposed in this pull request?
    
    Rename columns `partitions` in table_version_info to `partitioning`.
    
    ### Why are the changes needed?
    
    It's a bug.
    
    Fix: #9225
    
    ### Does this PR introduce _any_ user-facing change?
    
    N/A
    
    ### How was this patch tested?
    
    Locally.
---
 scripts/postgresql/upgrade-1.0.0-to-1.1.0-postgresql.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/scripts/postgresql/upgrade-1.0.0-to-1.1.0-postgresql.sql 
b/scripts/postgresql/upgrade-1.0.0-to-1.1.0-postgresql.sql
index 8a45186957..72dae7977f 100644
--- a/scripts/postgresql/upgrade-1.0.0-to-1.1.0-postgresql.sql
+++ b/scripts/postgresql/upgrade-1.0.0-to-1.1.0-postgresql.sql
@@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS table_version_info (
     table_id        BIGINT NOT NULL,
     format          VARCHAR(64),
     properties      TEXT,
-    partitions  TEXT,
+    partitioning  TEXT,
     distribution TEXT,
     sort_orders TEXT,
     indexes      TEXT,
@@ -34,7 +34,7 @@ COMMENT ON TABLE table_version_info                  IS 
'table detail informatio
 COMMENT ON COLUMN table_version_info.table_id        IS 'table id';
 COMMENT ON COLUMN table_version_info.format          IS 'table format, such as 
Lance, Iceberg and so on, it will be null if it is not a lakehouse table';
 COMMENT ON COLUMN table_version_info.properties      IS 'table properties';
-COMMENT ON COLUMN table_version_info.partitions      IS 'table partition info';
+COMMENT ON COLUMN table_version_info.partitioning    IS 'table partition info';
 COMMENT on COLUMN table_version_info.distribution    IS 'table distribution 
info';
 COMMENT ON COLUMN table_version_info.sort_orders     IS 'table sort order 
info';
 COMMENT ON COLUMN table_version_info.indexes         IS 'table index info';