Per-statement verdicts of the measurement scripts, re-run 2026-11-03. Builds (all --enable-cassert --enable-debug, -O2): r18 18.6 (724edf9bde9) mbase master eaa5961efc6 r19base REL_19_STABLE e33700c7670 m0001 master + v5-0001 r190001 REL_19_STABLE + v5-0001 mv5 master + v5-0001 + v5-0002 r19v5 REL_19_STABLE + v5-0001 + 0002 CREATE INDEX / GENERATED / PARTITION BY rows: A accepted, R rejected as not immutable, E another error. ORACLE rows (after the change the script makes): index-scan count / seq-scan count; "!" marks a mismatch, "-" means no index was created. BLAST rows: CREATE INDEX on json_array(v RETURNING jsonb) for a column of that type. Columns, in order: r18 mbase m0001 r19base r190001 mv5 r19v5 == sweep.sql R A R A R R R L9 CREATE INDEX ON t ((json_array(v r R R R R R R R L21 CREATE INDEX ON tk0 ((json_array( R R R R R R R L25 CREATE INDEX ON tk0n ((json_array R A R A R R R L31 CREATE INDEX t1_i ON t1 ((json_ar R A R A R R R L44 CREATE INDEX t2_i ON t2 ((json_ar R A R A R R R L57 CREATE INDEX t3_i ON t3 ((json_ar R A R A R R R L70 CREATE INDEX t4_i ON t4 ((json_ar R A R A R R R L81 CREATE INDEX t4b_i ON t4b ((json_ R A R A R R R L91 CREATE INDEX t5_i ON t5 ((json_ar R A R A R R R L105 CREATE INDEX t6_i ON t6 ((json_a R A R A R R R L117 CREATE INDEX t7_i ON t7 ((json_a R A R A R R R L129 CREATE INDEX t8_i ON t8 ((json_o R A R A R R R L130 CREATE INDEX t8_j ON t8 ((json_a R A R A R R R L140 CREATE INDEX ON t9 ((json_array( R A R A R R R L146 CREATE UNIQUE INDEX tu_i ON tu ( R A R A R R R L160 CREATE INDEX tp_i ON tp (id) WHE R A R A R R R L169 CREATE TABLE tg (v cg, g jsonb G R A R A R R R L179 CREATE TABLE tk (v ck) PARTITION - 0/1! - 0/1! - - - ORACLE S0 shihao add-ts+TZ - 0/1! - 0/1! - - - ORACLE C1 add-attr int - 1/1 - 1/1 - - - ORACLE C1 add-attr int +REINDEX - 0/1! - 0/1! - - - ORACLE C2 rename-attr - 1/1 - 1/1 - - - ORACLE C2 rename-attr +REINDEX - 0/1! - 0/1! - - - ORACLE C3 drop-attr - 1/1 - 1/1 - - - ORACLE C3 drop-attr +REINDEX - 0/1! - 0/1! - - - ORACLE C4 rowtype rename-col - 1/1 - 1/1 - - - ORACLE C4 rowtype rename-col +REINDEX - 0/1! - 0/1! - - - ORACLE C4b rowtype add-col - 0/1! - 0/1! - - - ORACLE C5 nested rename - 1/1 - 1/1 - - - ORACLE C5 nested rename +REINDEX - 0/1! - 0/1! - - - ORACLE C6 domain-over-composite renam - 1/1 - 1/1 - - - ORACLE C6 domain-over-composite renam - 0/1! - 0/1! - - - ORACLE C7 array-of-composite rename - 1/1 - 1/1 - - - ORACLE C7 array-of-composite rename + - 0/1! - 0/1! - - - ORACLE C8 json_object rename - 0/1! - 0/1! - - - ORACLE C8b returning-json::text renam - 1/2! - 1/2! - - - ORACLE U1 unique after dup insert - 1/0! - 1/0! - - - ORACLE P1 partial-index predicate - 0/0 - 0/0 - - - ORACLE P1 partial-index predicate +RE == holes.sql R A R A R R R L52 CREATE INDEX th4_i ON th4 ((json_ R A R A R R R L78 CREATE INDEX th5_i ON th5 ((json_ A A A A A A A TRY H1a json_array(int) control R A R A R R R TRY H1b json_array(composite) R A R A R R R TRY H1c json_array(row(int)) anonymou R A R A R R R TRY H1d json_array(array[row(int)]) r R A R A R R R TRY H1e json_array(array[composite]) R A R A R R R TRY H1f json_array(nested composite) R A R A R R R TRY H1g json_array(domain over compos R A R A R R R TRY H1h json_array(domain over compos R A R A R R R TRY H1i json_array(array of domain ov R R R R R R R TRY H1j json_array(whole-row th1) R A R A R R R TRY H1k json_object(composite) return R R R R R R R TRY H1l to_jsonb(composite) R R R R R R R TRY H1m to_json(composite)::text R R R R R R R TRY H1n row_to_json(composite)::text R R R R R R R TRY H1o json_build_array(composite):: R R R R R R R TRY H1p jsonb_build_object(k, composi R A R A R R R TRY H1q json_scalar(composite)::text R R R R R R R TRY H1r json_exists PASSING composite R A A A A A A TRY H1s json_array(int4range) R A A A A A A TRY H1t json_array(int4multirange) R R R R R R R TRY H1u json_array(interval) R R R R R R R TRY H1v json_array(money) A A A A A A A TRY H1w json_array(timetz) A A A A A A A TRY H1x json_array(time) R A R A R R R TRY H1y gencol json_array(composite) R A R A R R R TRY H1z partkey json_array(composite) - 0/1! - 0/1! - - - ORACLE H4 range + CREATE CAST - 1/1 - 1/1 - - - ORACLE H4 range + CREATE CAST +REINDE - 0/1! - 0/1! - - - ORACLE H4b range + DROP CAST A A R A R R R TRY H5 control json_array(e5) direct 1/1 0/1! - 0/1! - - - ORACLE H5 range-of-enum + RENAME VALU 1/1 1/1 - 1/1 - - - ORACLE H5 range-of-enum + RENAME VALU == h6.sql A A A A A A A L11 CREATE INDEX th6_i ON th6 ((json_ R A R A R R R L26 CREATE INDEX t5_i ON t5 ((json_ar R R R R R R R L34 CREATE INDEX t7_i ON t7 ((json_ar E E E E E E E L38 CREATE INDEX t5m_i ON t5m ((json_ 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE H6 user base type + CREATE CAS - 0/1! - 0/1! - - - ORACLE H5min range-of-enum + RENAME V == h5m.sql R A R A R R R L11 CREATE INDEX t5m_i ON t5m ((json_ R A R A R R R L18 CREATE INDEX t5a_i ON t5a ((json_ - 0/1! - 0/1! - - - ORACLE H5m multirange-of-enum + RENAM == repro-range-enum.sql R A R A R R R L10 CREATE INDEX t_i ON t ((json_arra == floats.sql A A R A A R A L10 CREATE INDEX tf_i ON tf ((json_ar A A R A A R A L19 CREATE INDEX tf4_i ON tf4 ((json_ A R R A A R A L28 CREATE INDEX tft_i ON tft ((f::te 0/1! 0/1! - 0/1! 0/1! - 0/1! ORACLE F8 float8 + extra_float_digits 0/1! 0/1! - 0/1! 0/1! - 0/1! ORACLE F4 float4 + extra_float_digits == builtin-ranges.sql R A A A A A A L7 CREATE INDEX tbr_r ON tbr ((json_a R A A A A A A L8 CREATE INDEX tbr_m ON tbr ((json_a R A A A A A A L9 CREATE INDEX tbr_ro ON tbr ((json_ R A A A A A A L10 CREATE INDEX tbr_n ON tbr ((json_ R R R R R R R L11 CREATE INDEX tbr_d ON tbr ((json_ R R R R R R R L12 CREATE INDEX tbr_ts ON tbr ((json R A A A A A A L13 CREATE INDEX tbr_ra ON tbr ((json - 1/1 1/1 1/1 1/1 1/1 1/1 ORACLE BR int4range + CREATE CAST (su == jian-demo.sql R A R A R R R L9 CREATE INDEX tr_idx ON tr ((json_a == jian-demo-explain.sql - 0/1! - 0/1! - - - ORACLE JD jian demo myr + CREATE CAST == holes4.sql A A A A A A A TRY Q1 json_array(user base type), no 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE Q1 user base type + CREATE CAS 1/1 1/1 1/1 1/1 1/1 1/1 1/1 ORACLE Q1 user base type + CREATE CAS A A A A A A A TRY Q2 json_array(user base type), ca 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE Q2 user base type + DROP CAST A A A A A A A TRY Q3 json_array(domain over user ba 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE Q3 domain over user base type A A A A A A A TRY Q3b json_array(domain over user b 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE Q3b domain over user base type R A A A A R R TRY Q4 json_array(user base type[]), - 0/1! 0/1! 0/1! 0/1! - - ORACLE Q4 user base type[] + CREATE C A A A A A A A TRY Q5 json_array(domain), cast on th 1/1 1/1 1/1 1/1 1/1 1/1 1/1 ORACLE Q5 domain + CREATE CAST on the R A R A R R R TRY Q6a json_array(user range[]) R A R A R R R TRY Q6b json_array(domain over user r R A R A R R R TRY Q6c json_array(user multirange[]) R A R A R R R TRY Q6d json_array(array of domain ov A A R A R R R TRY Q6e json_array(enum with IMMUTABL R A R A R R R TRY Q6f json_array(enum[] with IMMUTA R A R A R R R TRY Q6g json_object(user range) R A R A R R R TRY Q6h json_array(user range) return R A R A R R R TRY Q6i gencol json_array(user range[ R A R A R R R TRY Q6j partkey json_array(user range == blast.sql A A A A A A A BLAST "char" R A A A A A A BLAST "char"[] R R R R R R R BLAST aclitem[] A A A A A A A BLAST bigint R A A A A A A BLAST bigint[] A A A A A A A BLAST bit A A A A A A A BLAST bit varying R A A A A A A BLAST bit varying[] R A A A A A A BLAST bit[] A A A A A A A BLAST boolean R A A A A A A BLAST boolean[] A R R A A R A BLAST box R R R A A R A BLAST box[] A R R A A R A BLAST bytea R R R A A R A BLAST bytea[] A A A A A A A BLAST character A A A A A A A BLAST character varying R A A A A A A BLAST character varying[] R A A A A A A BLAST character[] A A A A A A A BLAST cid R A A A A A A BLAST cid[] A A A A A A A BLAST cidr R A A A A A A BLAST cidr[] A R R A A R A BLAST circle R R R A A R A BLAST circle[] E E E E E E E BLAST cstring[] R R R R R R R BLAST date R R R R R R R BLAST date[] R R R R R R R BLAST datemultirange R R R R R R R BLAST datemultirange[] R R R R R R R BLAST daterange R R R R R R R BLAST daterange[] A A R A A R A BLAST double precision R A R A A R A BLAST double precision[] A A A A A A A BLAST gtsvector R A A A A A A BLAST gtsvector[] A A A A A A A BLAST inet R A A A A A A BLAST inet[] R A A A A A A BLAST int2vector R A A A A A A BLAST int2vector[] R A A A A A A BLAST int4multirange R A A A A A A BLAST int4multirange[] R A A A A A A BLAST int4range R A A A A A A BLAST int4range[] R A A A A A A BLAST int8multirange R A A A A A A BLAST int8multirange[] R A A A A A A BLAST int8range R A A A A A A BLAST int8range[] A A A A A A A BLAST integer R A A A A A A BLAST integer[] R R R R R R R BLAST interval R R R R R R R BLAST interval[] A A A A A A A BLAST json R A A A A A A BLAST json[] A A A A A A A BLAST jsonb R A A A A A A BLAST jsonb[] A A A A A A A BLAST jsonpath R A A A A A A BLAST jsonpath[] A R R A A R A BLAST line R R R A A R A BLAST line[] A R R A A R A BLAST lseg R R R A A R A BLAST lseg[] A A A A A A A BLAST macaddr A A A A A A A BLAST macaddr8 R A A A A A A BLAST macaddr8[] R A A A A A A BLAST macaddr[] R R R R R R R BLAST money R R R R R R R BLAST money[] A A A A A A A BLAST name R A A A A A A BLAST name[] A A A A A A A BLAST numeric R A A A A A A BLAST numeric[] R A A A A A A BLAST nummultirange R A A A A A A BLAST nummultirange[] R A A A A A A BLAST numrange R A A A A A A BLAST numrange[] A A A A A A A BLAST oid R A A A A A A BLAST oid[] R A A A A A A BLAST oidvector R A A A A A A BLAST oidvector[] A R R A A R A BLAST path R R R A A R A BLAST path[] R R R R R R R BLAST pg_aggregate[] R A R A R R R BLAST pg_aios[] R R R R R R R BLAST pg_am[] R A R A R R R BLAST pg_amop[] R R R R R R R BLAST pg_amproc[] R A R A R R R BLAST pg_attrdef[] E E E E E E E BLAST pg_attribute[] R A R A R R R BLAST pg_auth_members[] R R R R R R R BLAST pg_authid[] R A R A R R R BLAST pg_available_extension_versions R A R A R R R BLAST pg_available_extensions[] R A R A R R R BLAST pg_backend_memory_contexts[] A A A A A A A BLAST pg_brin_bloom_summary A R R A A R A BLAST pg_brin_minmax_multi_summary R A R A R R R BLAST pg_cast[] R R R R R R R BLAST pg_class[] R A R A R R R BLAST pg_collation[] R A R A R R R BLAST pg_config[] R A R A R R R BLAST pg_constraint[] R R R R R R R BLAST pg_conversion[] R R R R R R R BLAST pg_cursors[] R R R R R R R BLAST pg_database[] R A R A R R R BLAST pg_db_role_setting[] R R R R R R R BLAST pg_default_acl[] R A R A R R R BLAST pg_depend[] A A A A A A A BLAST pg_dependencies R A R A R R R BLAST pg_description[] R A R A R R R BLAST pg_enum[] R A R A R R R BLAST pg_event_trigger[] R A R A R R R BLAST pg_extension[] R A R A R R R BLAST pg_file_settings[] R R R R R R R BLAST pg_foreign_data_wrapper[] R R R R R R R BLAST pg_foreign_server[] R A R A R R R BLAST pg_foreign_table[] R A R A R R R BLAST pg_group[] R A R A R R R BLAST pg_hba_file_rules[] R A R A R R R BLAST pg_ident_file_mappings[] R A R A R R R BLAST pg_index[] R A R A R R R BLAST pg_indexes[] R A R A R R R BLAST pg_inherits[] R R R R R R R BLAST pg_init_privs[] R R R R R R R BLAST pg_language[] R R R A R R R BLAST pg_largeobject[] R R R R R R R BLAST pg_largeobject_metadata[] R R R R R R R BLAST pg_locks[] A A A A A A A BLAST pg_lsn R A A A A A A BLAST pg_lsn[] R A R A R R R BLAST pg_matviews[] A R R A A R A BLAST pg_mcv_list R R R R R R R BLAST pg_namespace[] A A A A A A A BLAST pg_ndistinct A A A A A A A BLAST pg_node_tree R A R A R R R BLAST pg_opclass[] R R R R R R R BLAST pg_operator[] R A R A R R R BLAST pg_opfamily[] R R R R R R R BLAST pg_parameter_acl[] R A R A R R R BLAST pg_partitioned_table[] R A R A R R R BLAST pg_policies[] R A R A R R R BLAST pg_policy[] R R R R R R R BLAST pg_prepared_statements[] R R R R R R R BLAST pg_prepared_xacts[] R R R R R R R BLAST pg_proc[] R A R A R R R BLAST pg_publication[] R A R A R R R BLAST pg_publication_namespace[] R A R A R R R BLAST pg_publication_rel[] R A R A R R R BLAST pg_publication_tables[] R R R R R R R BLAST pg_range[] R A R A R R R BLAST pg_replication_origin[] R A R A R R R BLAST pg_replication_origin_status[] R R R R R R R BLAST pg_replication_slots[] R A R A R R R BLAST pg_rewrite[] R R R R R R R BLAST pg_roles[] R A R A R R R BLAST pg_rules[] R A R A R R R BLAST pg_seclabel[] R A R A R R R BLAST pg_seclabels[] R A R A R R R BLAST pg_sequence[] R R R R R R R BLAST pg_sequences[] R A R A R R R BLAST pg_settings[] R R R R R R R BLAST pg_shadow[] R A R A R R R BLAST pg_shdepend[] R A R A R R R BLAST pg_shdescription[] R A R A R R R BLAST pg_shmem_allocations[] R A R A R R R BLAST pg_shmem_allocations_numa[] R A R A R R R BLAST pg_shseclabel[] A A A A A A A BLAST pg_snapshot R A A A A A A BLAST pg_snapshot[] R R R R R R R BLAST pg_stat_activity[] R R R R R R R BLAST pg_stat_all_indexes[] R R R R R R R BLAST pg_stat_all_tables[] R R R R R R R BLAST pg_stat_archiver[] R R R R R R R BLAST pg_stat_bgwriter[] R R R R R R R BLAST pg_stat_checkpointer[] R R R R R R R BLAST pg_stat_database[] R R R R R R R BLAST pg_stat_database_conflicts[] R A R A R R R BLAST pg_stat_gssapi[] R R R R R R R BLAST pg_stat_io[] R A R A R R R BLAST pg_stat_progress_analyze[] R A R A R R R BLAST pg_stat_progress_basebackup[] R A R A R R R BLAST pg_stat_progress_cluster[] R A R A R R R BLAST pg_stat_progress_copy[] R A R A R R R BLAST pg_stat_progress_create_index[] R A R A R R R BLAST pg_stat_progress_vacuum[] R R R R R R R BLAST pg_stat_recovery_prefetch[] R R R R R R R BLAST pg_stat_replication[] R R R R R R R BLAST pg_stat_replication_slots[] R R R R R R R BLAST pg_stat_slru[] R A R A R R R BLAST pg_stat_ssl[] R R R R R R R BLAST pg_stat_subscription[] R R R R R R R BLAST pg_stat_subscription_stats[] R R R R R R R BLAST pg_stat_sys_indexes[] R R R R R R R BLAST pg_stat_sys_tables[] R R R R R R R BLAST pg_stat_user_functions[] R R R R R R R BLAST pg_stat_user_indexes[] R R R R R R R BLAST pg_stat_user_tables[] R R R R R R R BLAST pg_stat_wal[] R R R R R R R BLAST pg_stat_wal_receiver[] R A R A R R R BLAST pg_stat_xact_all_tables[] R A R A R R R BLAST pg_stat_xact_sys_tables[] R A R A R R R BLAST pg_stat_xact_user_functions[] R A R A R R R BLAST pg_stat_xact_user_tables[] R R R R R R R BLAST pg_statio_all_indexes[] R R R R R R R BLAST pg_statio_all_sequences[] R R R R R R R BLAST pg_statio_all_tables[] R R R R R R R BLAST pg_statio_sys_indexes[] R R R R R R R BLAST pg_statio_sys_sequences[] R R R R R R R BLAST pg_statio_sys_tables[] R R R R R R R BLAST pg_statio_user_indexes[] R R R R R R R BLAST pg_statio_user_sequences[] R R R R R R R BLAST pg_statio_user_tables[] E E E E E E E BLAST pg_statistic[] R A R A R R R BLAST pg_statistic_ext[] E E E E E E E BLAST pg_statistic_ext_data[] E E E E E E E BLAST pg_stats[] R A R A R R R BLAST pg_stats_ext[] E E E E E E E BLAST pg_stats_ext_exprs[] R A R A R R R BLAST pg_subscription[] R A R A R R R BLAST pg_subscription_rel[] R A R A R R R BLAST pg_tables[] R R R R R R R BLAST pg_tablespace[] R R R R R R R BLAST pg_timezone_abbrevs[] R R R R R R R BLAST pg_timezone_names[] R R R R R R R BLAST pg_transform[] R R R A R R R BLAST pg_trigger[] R A R A R R R BLAST pg_ts_config[] R A R A R R R BLAST pg_ts_config_map[] R A R A R R R BLAST pg_ts_dict[] R R R R R R R BLAST pg_ts_parser[] R R R R R R R BLAST pg_ts_template[] R R R R R R R BLAST pg_type[] R R R R R R R BLAST pg_user[] R A R A R R R BLAST pg_user_mapping[] R A R A R R R BLAST pg_user_mappings[] R A R A R R R BLAST pg_views[] R A R A R R R BLAST pg_wait_events[] A R R A A R A BLAST point R R R A A R A BLAST point[] A R R A A R A BLAST polygon R R R A A R A BLAST polygon[] A A R A A R A BLAST real R A R A A R A BLAST real[] A A A A A A A BLAST refcursor R A A A A A A BLAST refcursor[] R R R R R R R BLAST regclass R R R R R R R BLAST regclass[] R R R R R R R BLAST regcollation R R R R R R R BLAST regcollation[] R R R R R R R BLAST regconfig R R R R R R R BLAST regconfig[] R R R R R R R BLAST regdictionary R R R R R R R BLAST regdictionary[] R R R R R R R BLAST regnamespace R R R R R R R BLAST regnamespace[] R R R R R R R BLAST regoper R R R R R R R BLAST regoper[] R R R R R R R BLAST regoperator R R R R R R R BLAST regoperator[] R R R R R R R BLAST regproc R R R R R R R BLAST regproc[] R R R R R R R BLAST regprocedure R R R R R R R BLAST regprocedure[] R R R R R R R BLAST regrole R R R R R R R BLAST regrole[] R R R R R R R BLAST regtype R R R R R R R BLAST regtype[] A A A A A A A BLAST smallint R A A A A A A BLAST smallint[] A A A A A A A BLAST text R A A A A A A BLAST text[] A A A A A A A BLAST tid R A A A A A A BLAST tid[] A A A A A A A BLAST time with time zone R A A A A A A BLAST time with time zone[] A A A A A A A BLAST time without time zone R A A A A A A BLAST time without time zone[] R R R R R R R BLAST timestamp with time zone R R R R R R R BLAST timestamp with time zone[] R R R R R R R BLAST timestamp without time zone R R R R R R R BLAST timestamp without time zone[] R R R R R R R BLAST tsmultirange R R R R R R R BLAST tsmultirange[] A A A A A A A BLAST tsquery R A A A A A A BLAST tsquery[] R R R R R R R BLAST tsrange R R R R R R R BLAST tsrange[] R R R R R R R BLAST tstzmultirange R R R R R R R BLAST tstzmultirange[] R R R R R R R BLAST tstzrange R R R R R R R BLAST tstzrange[] A A A A A A A BLAST tsvector R A A A A A A BLAST tsvector[] A A A A A A A BLAST txid_snapshot R A A A A A A BLAST txid_snapshot[] R A R A R R R BLAST ub_comp R A R A R R R BLAST ub_comp[] A A R A A R A BLAST ub_dfloat8 R A R A A R A BLAST ub_dfloat8[] A A A A A A A BLAST ub_dint R A A A A A A BLAST ub_dint[] A A A A A A A BLAST ub_dtext R A A A A R R BLAST ub_dtext[] R R R R R R R BLAST ub_enum R R R R R R R BLAST ub_enum[] A A R A R R R BLAST ub_enumc R A R A R R R BLAST ub_enumc[] R A R A R R R BLAST ub_multirange R A R A R R R BLAST ub_multirange[] R A R A R R R BLAST ub_multirangec R A R A R R R BLAST ub_multirangec[] R A R A R R R BLAST ub_nummultirange R A R A R R R BLAST ub_nummultirange[] R A R A R R R BLAST ub_numrange R A R A R R R BLAST ub_numrange[] R A R A R R R BLAST ub_range R A R A R R R BLAST ub_range[] A A R A R R R BLAST ub_rangec R A R A R R R BLAST ub_rangec[] A A A A A A A BLAST ub_text R A A A A R R BLAST ub_text[] A A A A A A A BLAST ub_textc R A A A A R R BLAST ub_textc[] A A A A A A A BLAST uuid R A A A A A A BLAST uuid[] A A A A A A A BLAST xid A A A A A A A BLAST xid8 R A A A A A A BLAST xid8[] R A A A A A A BLAST xid[] A A A A A A A BLAST xml R A A A A A A BLAST xml[] E A A A A A A BLAST oid8 E A A A A A A BLAST oid8[] E A R A R R R BLAST pg_dsm_registry_allocations[] E A R A R R R BLAST pg_publication_sequences[] E A R A R R R BLAST pg_stat_autovacuum_scores[] E A R E E R E BLAST pg_stat_kind_info[] E R R R R R R BLAST pg_stat_lock[] E A R E E R E BLAST pg_stat_progress_data_checksums E A R A R R R BLAST pg_stat_progress_repack[] E R R R R R R BLAST pg_stat_recovery[] E R R R R R R BLAST regdatabase E R R R R R R BLAST regdatabase[] == repro-array.sql R A A A A R R L12 CREATE INDEX t_i ON t ((json_arra == contrib.sql R A A A A R R TRY contrib citext array A A A A A A A TRY contrib citext direct A A A A A A A TRY contrib citext domain R A A A A R R TRY contrib hstore array A A A A A A A TRY contrib hstore direct A A A A A A A TRY contrib hstore domain R A A A A R R TRY contrib ltree array A A A A A A A TRY contrib ltree direct A A A A A A A TRY contrib ltree domain R A A A A R R TRY contrib lquery array A A A A A A A TRY contrib lquery direct A A A A A A A TRY contrib lquery domain R A A A A R R TRY contrib ltxtquery array A A A A A A A TRY contrib ltxtquery direct A A A A A A A TRY contrib ltxtquery domain R A A A A R R TRY contrib cube array A A A A A A A TRY contrib cube direct A A A A A A A TRY contrib cube domain R A A A A R R TRY contrib seg array A A A A A A A TRY contrib seg direct A A A A A A A TRY contrib seg domain R A A A A R R TRY contrib ean13 array A A A A A A A TRY contrib ean13 direct A A A A A A A TRY contrib ean13 domain R A A A A R R TRY contrib isbn13 array A A A A A A A TRY contrib isbn13 direct A A A A A A A TRY contrib isbn13 domain R A A A A R R TRY contrib isbn array A A A A A A A TRY contrib isbn direct A A A A A A A TRY contrib isbn domain R A A A A R R TRY contrib issn array A A A A A A A TRY contrib issn direct A A A A A A A TRY contrib issn domain R A A A A R R TRY contrib issn13 array A A A A A A A TRY contrib issn13 direct A A A A A A A TRY contrib issn13 domain R A A A A R R TRY contrib ismn13 array A A A A A A A TRY contrib ismn13 direct A A A A A A A TRY contrib ismn13 domain R A A A A R R TRY contrib ismn array A A A A A A A TRY contrib ismn direct A A A A A A A TRY contrib ismn domain R A A A A R R TRY contrib upc array A A A A A A A TRY contrib upc direct A A A A A A A TRY contrib upc domain - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib citext array + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib citext direct + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib citext domain + CREATE - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib hstore array + ALTER E 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib hstore direct + ALTER 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib hstore domain + ALTER - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib ltree array + CREATE C 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib ltree direct + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib ltree domain + CREATE - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib lquery array + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib lquery direct + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib lquery domain + CREATE - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib ltxtquery array + CREA 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib ltxtquery direct + CRE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib ltxtquery domain + CRE - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib cube array + CREATE CA 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib cube direct + CREATE C 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib cube domain + CREATE C - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib seg array + CREATE CAS 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib seg direct + CREATE CA 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib seg domain + CREATE CA - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib ean13 array + CREATE C 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib ean13 direct + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib ean13 domain + CREATE - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib isbn13 array + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib isbn13 direct + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib isbn13 domain + CREATE - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib isbn array + CREATE CA 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib isbn direct + CREATE C 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib isbn domain + CREATE C - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib issn array + CREATE CA 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib issn direct + CREATE C 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib issn domain + CREATE C - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib issn13 array + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib issn13 direct + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib issn13 domain + CREATE - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib ismn13 array + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib ismn13 direct + CREATE 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib ismn13 domain + CREATE - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib ismn array + CREATE CA 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib ismn direct + CREATE C 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib ismn domain + CREATE C - 0/1! 0/1! 0/1! 0/1! - - ORACLE contrib upc array + CREATE CAS 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib upc direct + CREATE CA 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! 0/1! ORACLE contrib upc domain + CREATE CA == repro.sql R A R A R R R L7 CREATE INDEX t_i ON t ((json_array == t0002.sql == sweep.sql, stored generated column (G1) and partition key (K1) r18: (CREATE rejected, nothing to show) mbase: G1 stored gencol: stored=[{"x": 1}] recomputed=[{"z": 1}] DIVERGE K1 partkey pruning=on count=0 K1 partkey pruning=off count=1 K1 row sits in tk_1, partition constraint now VIOLATED m0001: (CREATE rejected, nothing to show) r19base: G1 stored gencol: stored=[{"x": 1}] recomputed=[{"z": 1}] DIVERGE K1 partkey pruning=on count=0 K1 partkey pruning=off count=1 K1 row sits in tk_1, partition constraint now VIOLATED r190001: (CREATE rejected, nothing to show) mv5: (CREATE rejected, nothing to show) r19v5: (CREATE rejected, nothing to show)