-- rollup is rollup_leaves and rollup_dims is rollup_columns since 4.2; the older names stay accepted through 4.x. They are read as the new ones when the new one is empty,
-- the new one wins when both are set, CREATE INDEX and ALTER INDEX say which spelling to use, and the options of the index keep the name they were given.
-- (write_buffer_alias covers mutable_limit.)
CREATE EXTENSION pg_sift;
CREATE TABLE ra (id int, g int, h int, v int, items jsonb) WITH (autovacuum_enabled = off);
INSERT INTO ra SELECT i, i % 5, i % 7, i, jsonb_build_array(jsonb_build_object('kind', 'k' || i % 3)) FROM generate_series(1, 3000) i;
CREATE INDEX ra_old ON ra USING sift_col (id, g, h, v, items) WITH (paths = 'items[]{kind text}', rollup = 'items[].kind', rollup_dims = 'g, h: v');
NOTICE:  reloption "rollup" is the older name of "rollup_leaves"
HINT:  Use "rollup_leaves"; the older name keeps working.
NOTICE:  reloption "rollup_dims" is the older name of "rollup_columns"
HINT:  Use "rollup_columns"; the older name keeps working.
NOTICE:  sift_col index "ra_old": 1 advice (track_changes)
DETAIL:  advice: track_changes = the table has no one-column primary key
HINT:  Reasons, costs and how to turn each off: SELECT * FROM sift.index_choices('ra_old');
CREATE INDEX ra_new ON ra USING sift_col (id, g, h, v, items) WITH (paths = 'items[]{kind text}', rollup_leaves = 'items[].kind', rollup_columns = 'g, h: v');
NOTICE:  sift_col index "ra_new": 1 advice (track_changes)
DETAIL:  advice: track_changes = the table has no one-column primary key
HINT:  Reasons, costs and how to turn each off: SELECT * FROM sift.index_choices('ra_new');
SELECT relname, reloptions FROM pg_class WHERE relname IN ('ra_old', 'ra_new') ORDER BY relname;
 relname |                                    reloptions                                    
---------+----------------------------------------------------------------------------------
 ra_new  | {"paths=items[]{kind text}",rollup_leaves=items[].kind,"rollup_columns=g, h: v"}
 ra_old  | {"paths=items[]{kind text}",rollup=items[].kind,"rollup_dims=g, h: v"}
(2 rows)

-- the same options: the same rollups (the unit records of the build) and the same verdict
SELECT (SELECT string_agg(format('%s/%s', segments, rows), ',') FROM sift.col_index_info('ra_old')) = (SELECT string_agg(format('%s/%s', segments, rows), ',') FROM sift.col_index_info('ra_new')) AS same_shape;
 same_shape 
------------
 t
(1 row)

SELECT sift.col_verify('ra_old', true), sift.col_verify('ra_new', true);
 col_verify | col_verify 
------------+------------
            | 
(1 row)

-- both given: the new name decides (the old one names a column that is not there, and would fail alone)
CREATE INDEX ra_both ON ra USING sift_col (id, g, h, v) WITH (rollup_columns = 'off', rollup_dims = 'nope, g');
NOTICE:  reloption "rollup_dims" is the older name of "rollup_columns"
HINT:  Use "rollup_columns"; the older name keeps working.
NOTICE:  sift_col index "ra_both": 1 advice (track_changes)
DETAIL:  advice: track_changes = the table has no one-column primary key
HINT:  Reasons, costs and how to turn each off: SELECT * FROM sift.index_choices('ra_both');
CREATE INDEX ra_alone ON ra USING sift_col (id, g, h, v) WITH (rollup_dims = 'nope, g');
NOTICE:  reloption "rollup_dims" is the older name of "rollup_columns"
HINT:  Use "rollup_columns"; the older name keeps working.
ERROR:  invalid rollup_columns option: "nope" is not a column of the index
CREATE INDEX ra_leaf_alone ON ra USING sift_col (id, items) WITH (paths = 'items[]{kind text}', rollup = 'items[].nope');
NOTICE:  reloption "rollup" is the older name of "rollup_leaves"
HINT:  Use "rollup_leaves"; the older name keeps working.
ERROR:  invalid rollup_leaves option: "items[].nope" is not a leaf declared in paths
-- both words of auto
CREATE INDEX ra_auto ON ra USING sift_col (id, g, h, v) WITH (rollup_columns = 'auto');
NOTICE:  sift_col index "ra_auto": 1 automatic choice (rollup_columns), 1 advice (track_changes)
DETAIL:  advice: track_changes = the table has no one-column primary key; rollup_columns = g, h
HINT:  Reasons, costs and how to turn each off: SELECT * FROM sift.index_choices('ra_auto');
ALTER INDEX ra_auto SET (rollup_leaves = 'default');
-- ALTER INDEX SET and RESET of the older names
ALTER INDEX ra_old SET (rollup = 'off');
NOTICE:  reloption "rollup_dims" is the older name of "rollup_columns"
HINT:  Use "rollup_columns"; the older name keeps working.
NOTICE:  reloption "rollup" is the older name of "rollup_leaves"
HINT:  Use "rollup_leaves"; the older name keeps working.
ALTER INDEX ra_old SET (rollup_dims = 'g, h');
NOTICE:  reloption "rollup" is the older name of "rollup_leaves"
HINT:  Use "rollup_leaves"; the older name keeps working.
NOTICE:  reloption "rollup_dims" is the older name of "rollup_columns"
HINT:  Use "rollup_columns"; the older name keeps working.
SELECT reloptions FROM pg_class WHERE relname = 'ra_old';
                         reloptions                         
------------------------------------------------------------
 {"paths=items[]{kind text}",rollup=off,"rollup_dims=g, h"}
(1 row)

ALTER INDEX ra_old SET (rollup_leaves = 'items[].kind');
NOTICE:  reloption "rollup" is the older name of "rollup_leaves"
HINT:  Use "rollup_leaves"; the older name keeps working.
NOTICE:  reloption "rollup_dims" is the older name of "rollup_columns"
HINT:  Use "rollup_columns"; the older name keeps working.
ALTER INDEX ra_old RESET (rollup, rollup_dims);
SELECT reloptions FROM pg_class WHERE relname = 'ra_old';
                       reloptions                        
---------------------------------------------------------
 {"paths=items[]{kind text}",rollup_leaves=items[].kind}
(1 row)

REINDEX INDEX ra_old;
NOTICE:  sift_col index "ra_old": 1 advice (track_changes)
DETAIL:  advice: track_changes = the table has no one-column primary key
HINT:  Reasons, costs and how to turn each off: SELECT * FROM sift.index_choices('ra_old');
SELECT sift.col_verify('ra_old', true);
 col_verify 
------------
 
(1 row)

DROP TABLE ra;
DROP EXTENSION pg_sift;