Re: Schema variables - new implementation for Postgres 15 - Mailing list pgsql-hackers

 > [schema-variables-20210909.patch]

Hi Pavel,

The patch applies and compiles fine but 'make check' for the
assert-enabled fails on 131 out of 210 tests.

(while compiling HEAD checks run without errors for both assert-disabled
and assert-enabled)


Erik Rijkers


test tablespace                   ... ok          303 ms
parallel group (20 tests):  oid char pg_lsn int2 varchar txid int4
regproc uuid float4 text name money boolean bit float8 int8 enum numeric
rangetypes
      boolean                      ... ok          112 ms
      char                         ... ok           57 ms
      name                         ... ok          106 ms
      varchar                      ... ok           74 ms
      text                         ... ok          106 ms
      int2                         ... ok           73 ms
      int4                         ... ok           92 ms
      int8                         ... ok          130 ms
      oid                          ... ok           55 ms
      float4                       ... ok          102 ms
      float8                       ... ok          126 ms
      bit                          ... ok          124 ms
      numeric                      ... ok          362 ms
      txid                         ... ok           87 ms
      uuid                         ... ok          100 ms
      enum                         ... ok          142 ms
      money                        ... ok          109 ms
      rangetypes                   ... ok          433 ms
      pg_lsn                       ... ok           64 ms
      regproc                      ... ok           91 ms
parallel group (20 tests):  lseg path circle time macaddr
create_function_0 timetz line macaddr8 numerology point interval inet
date strings polygon box multirangetypes timestamp timestamptz
      strings                      ... ok          166 ms
      numerology                   ... ok           89 ms
      point                        ... ok           96 ms
      lseg                         ... ok           35 ms
      line                         ... ok           70 ms
      box                          ... ok          255 ms
      path                         ... ok           50 ms
      polygon                      ... ok          237 ms
      circle                       ... ok           53 ms
      date                         ... ok          127 ms
      time                         ... ok           60 ms
      timetz                       ... ok           67 ms
      timestamp                    ... ok          379 ms
      timestamptz                  ... ok          413 ms
      interval                     ... ok           97 ms
      inet                         ... ok          118 ms
      macaddr                      ... ok           60 ms
      macaddr8                     ... ok           80 ms
      multirangetypes              ... ok          307 ms
      create_function_0            ... ok           63 ms
parallel group (12 tests):  comments unicode misc_sanity tstypes xid
expressions horology geometry mvcc type_sanity regex opr_sanity
      geometry                     ... ok          140 ms
      horology                     ... ok          120 ms
      tstypes                      ... ok           53 ms
      regex                        ... ok          335 ms
      type_sanity                  ... ok          155 ms
      opr_sanity                   ... ok          355 ms
      misc_sanity                  ... ok           43 ms
      comments                     ... ok           20 ms
      expressions                  ... ok          100 ms
      unicode                      ... ok           25 ms
      xid                          ... ok           56 ms
      mvcc                         ... ok          146 ms
test create_function_1            ... ok           10 ms
test create_type                  ... ok           30 ms
test create_table                 ... ok          333 ms
test create_function_2            ... ok           11 ms
parallel group (5 tests):  copydml copyselect insert_conflict insert copy
      copy                         ... ok          336 ms
      copyselect                   ... ok           34 ms
      copydml                      ... ok           28 ms
      insert                       ... ok          291 ms
      insert_conflict              ... FAILED (test process exited with
exit code 2)      239 ms
parallel group (3 tests):  create_operator create_procedure create_misc
      create_misc                  ... ok          131 ms
      create_operator              ... ok           29 ms
      create_procedure             ... ok           52 ms
parallel group (5 tests):  create_view create_index_spgist
index_including create_index index_including_gist
      create_index                 ... FAILED (test process exited with
exit code 2)     3801 ms
      create_index_spgist          ... ok          523 ms
      create_view                  ... FAILED (test process exited with
exit code 2)      339 ms
      index_including              ... FAILED (test process exited with
exit code 2)     3801 ms
      index_including_gist         ... FAILED (test process exited with
exit code 2)     3801 ms
parallel group (16 tests):  create_aggregate create_cast typed_table
drop_if_exists roleattributes create_am hash_func updatable_views errors
infinite_recurse create_function_3 triggers constraints select inherit
vacuum
      create_aggregate             ... FAILED (test process exited with
exit code 2)      164 ms
      create_function_3            ... FAILED (test process exited with
exit code 2)      164 ms
      create_cast                  ... FAILED (test process exited with
exit code 2)      164 ms
      constraints                  ... FAILED (test process exited with
exit code 2)      181 ms
      triggers                     ... FAILED (test process exited with
exit code 2)      181 ms
      select                       ... FAILED (test process exited with
exit code 2)      181 ms
      inherit                      ... FAILED (test process exited with
exit code 2)      181 ms
      typed_table                  ... FAILED (test process exited with
exit code 2)      163 ms
      vacuum                       ... FAILED (test process exited with
exit code 2)      180 ms
      drop_if_exists               ... FAILED (test process exited with
exit code 2)      163 ms
      updatable_views              ... FAILED (test process exited with
exit code 2)      163 ms
      roleattributes               ... FAILED (test process exited with
exit code 2)      163 ms
      create_am                    ... FAILED (test process exited with
exit code 2)      163 ms
      hash_func                    ... FAILED (test process exited with
exit code 2)      162 ms
      errors                       ... FAILED (test process exited with
exit code 2)      162 ms
      infinite_recurse             ... FAILED (test process exited with
exit code 2)      162 ms
test sanity_check                 ... FAILED (test process exited with
exit code 2)       26 ms
parallel group (20 tests):  select_into subselect select_distinct arrays
join namespace hash_index select_having portals transactions aggregates
random update delete union btree_index select_implicit
select_distinct_on prepared_xacts case
      select_into                  ... FAILED (test process exited with
exit code 2)       20 ms
      select_distinct              ... FAILED (test process exited with
exit code 2)       21 ms
      select_distinct_on           ... FAILED (test process exited with
exit code 2)       26 ms
      select_implicit              ... FAILED (test process exited with
exit code 2)       26 ms
      select_having                ... FAILED (test process exited with
exit code 2)       23 ms
      subselect                    ... FAILED (test process exited with
exit code 2)       20 ms
      union                        ... FAILED (test process exited with
exit code 2)       25 ms
      case                         ... FAILED (test process exited with
exit code 2)       27 ms
      join                         ... FAILED (test process exited with
exit code 2)       22 ms
      aggregates                   ... FAILED (test process exited with
exit code 2)       24 ms
      transactions                 ... FAILED (test process exited with
exit code 2)       24 ms
      random                       ... failed (ignored) (test process
exited with exit code 2)       24 ms
      portals                      ... FAILED (test process exited with
exit code 2)       23 ms
      arrays                       ... FAILED (test process exited with
exit code 2)       20 ms
      btree_index                  ... FAILED (test process exited with
exit code 2)       25 ms
      hash_index                   ... FAILED (test process exited with
exit code 2)       22 ms
      update                       ... FAILED (test process exited with
exit code 2)       23 ms
      delete                       ... FAILED (test process exited with
exit code 2)       24 ms
      namespace                    ... FAILED (test process exited with
exit code 2)       21 ms
      prepared_xacts               ... FAILED (test process exited with
exit code 2)       25 ms
parallel group (20 tests):  gist brin identity generated password
tablesample lock matview replica_identity rowsecurity security_label
object_address drop_operator groupingsets join_hash privileges collate
init_privs spgist gin
      brin                         ... FAILED (test process exited with
exit code 2)       15 ms
      gin                          ... FAILED (test process exited with
exit code 2)       22 ms
      gist                         ... FAILED (test process exited with
exit code 2)       13 ms
      spgist                       ... FAILED (test process exited with
exit code 2)       22 ms
      privileges                   ... FAILED (test process exited with
exit code 2)       19 ms
      init_privs                   ... FAILED (test process exited with
exit code 2)       21 ms
      security_label               ... FAILED (test process exited with
exit code 2)       17 ms
      collate                      ... FAILED (test process exited with
exit code 2)       20 ms
      matview                      ... FAILED (test process exited with
exit code 2)       17 ms
      lock                         ... FAILED (test process exited with
exit code 2)       15 ms
      replica_identity             ... FAILED (test process exited with
exit code 2)       17 ms
      rowsecurity                  ... FAILED (test process exited with
exit code 2)       17 ms
      object_address               ... FAILED (test process exited with
exit code 2)       17 ms
      tablesample                  ... FAILED (test process exited with
exit code 2)       15 ms
      groupingsets                 ... FAILED (test process exited with
exit code 2)       17 ms
      drop_operator                ... FAILED (test process exited with
exit code 2)       17 ms
      password                     ... FAILED (test process exited with
exit code 2)       14 ms
      identity                     ... FAILED (test process exited with
exit code 2)       13 ms
      generated                    ... FAILED (test process exited with
exit code 2)       14 ms
      join_hash                    ... FAILED (test process exited with
exit code 2)       18 ms
parallel group (2 tests):  brin_multi brin_bloom
      brin_bloom                   ... FAILED (test process exited with
exit code 2)        4 ms
      brin_multi                   ... FAILED (test process exited with
exit code 2)        4 ms
parallel group (14 tests):  async create_table_like collate.icu.utf8
misc sysviews alter_operator tidscan tidrangescan alter_generic tsrf
incremental_sort misc_functions tid dbsize
      create_table_like            ... FAILED (test process exited with
exit code 2)       10 ms
      alter_generic                ... FAILED (test process exited with
exit code 2)       15 ms
      alter_operator               ... FAILED (test process exited with
exit code 2)       13 ms
      misc                         ... FAILED (test process exited with
exit code 2)       11 ms
      async                        ... FAILED (test process exited with
exit code 2)        9 ms
      dbsize                       ... FAILED (test process exited with
exit code 2)       17 ms
      misc_functions               ... FAILED (test process exited with
exit code 2)       14 ms
      sysviews                     ... FAILED (test process exited with
exit code 2)       12 ms
      tsrf                         ... FAILED (test process exited with
exit code 2)       14 ms
      tid                          ... FAILED (test process exited with
exit code 2)       16 ms
      tidscan                      ... FAILED (test process exited with
exit code 2)       13 ms
      tidrangescan                 ... FAILED (test process exited with
exit code 2)       13 ms
      collate.icu.utf8             ... FAILED (test process exited with
exit code 2)        9 ms
      incremental_sort             ... FAILED (test process exited with
exit code 2)       13 ms
parallel group (6 tests):  amutils psql_crosstab collate.linux.utf8 psql
stats_ext rules
      rules                        ... FAILED (test process exited with
exit code 2)        8 ms
      psql                         ... FAILED (test process exited with
exit code 2)        7 ms
      psql_crosstab                ... FAILED (test process exited with
exit code 2)        7 ms
      amutils                      ... FAILED (test process exited with
exit code 2)        7 ms
      stats_ext                    ... FAILED (test process exited with
exit code 2)        8 ms
      collate.linux.utf8           ... FAILED (test process exited with
exit code 2)        7 ms
test select_parallel              ... FAILED (test process exited with
exit code 2)        3 ms
test write_parallel               ... FAILED (test process exited with
exit code 2)        3 ms
parallel group (2 tests):  publication subscription
      publication                  ... FAILED (test process exited with
exit code 2)        4 ms
      subscription                 ... FAILED (test process exited with
exit code 2)        4 ms
parallel group (17 tests):  select_views foreign_key xmlmap window
functional_deps tsearch cluster combocid bitmapops tsdicts equivclass
guc indirect_toast advisory_lock foreign_data dependency portals_p2
      select_views                 ... FAILED (test process exited with
exit code 2)       11 ms
      portals_p2                   ... FAILED (test process exited with
exit code 2)       20 ms
      foreign_key                  ... FAILED (test process exited with
exit code 2)       11 ms
      cluster                      ... FAILED (test process exited with
exit code 2)       15 ms
      dependency                   ... FAILED (test process exited with
exit code 2)       19 ms
      guc                          ... FAILED (test process exited with
exit code 2)       16 ms
      bitmapops                    ... FAILED (test process exited with
exit code 2)       16 ms
      combocid                     ... FAILED (test process exited with
exit code 2)       15 ms
      tsearch                      ... FAILED (test process exited with
exit code 2)       14 ms
      tsdicts                      ... FAILED (test process exited with
exit code 2)       16 ms
      foreign_data                 ... FAILED (test process exited with
exit code 2)       17 ms
      window                       ... FAILED (test process exited with
exit code 2)       12 ms
      xmlmap                       ... FAILED (test process exited with
exit code 2)       12 ms
      functional_deps              ... FAILED (test process exited with
exit code 2)       13 ms
      advisory_lock                ... FAILED (test process exited with
exit code 2)       16 ms
      indirect_toast               ... FAILED (test process exited with
exit code 2)       16 ms
      equivclass                   ... FAILED (test process exited with
exit code 2)       15 ms
parallel group (6 tests):  json json_encoding jsonb jsonpath_encoding
jsonb_jsonpath jsonpath
      json                         ... FAILED (test process exited with
exit code 2)        4 ms
      jsonb                        ... FAILED (test process exited with
exit code 2)        6 ms
      json_encoding                ... FAILED (test process exited with
exit code 2)        5 ms
      jsonpath                     ... FAILED (test process exited with
exit code 2)       10 ms
      jsonpath_encoding            ... FAILED (test process exited with
exit code 2)        6 ms
      jsonb_jsonpath               ... FAILED (test process exited with
exit code 2)        7 ms
parallel group (19 tests):  plpgsql limit rowtypes sequence largeobject
returning domain polymorphism plancache prepare alter_table truncate
temp rangefuncs with copy2 conversion schema_variables xml
      plancache                    ... FAILED (test process exited with
exit code 2)       16 ms
      limit                        ... FAILED (test process exited with
exit code 2)       10 ms
      plpgsql                      ... FAILED (test process exited with
exit code 2)        7 ms
      copy2                        ... FAILED (test process exited with
exit code 2)       25 ms
      temp                         ... FAILED (test process exited with
exit code 2)       21 ms
      domain                       ... FAILED (test process exited with
exit code 2)       13 ms
      rangefuncs                   ... FAILED (test process exited with
exit code 2)       22 ms
      prepare                      ... FAILED (test process exited with
exit code 2)       19 ms
      conversion                   ... FAILED (test process exited with
exit code 2)       24 ms
      truncate                     ... FAILED (test process exited with
exit code 2)       19 ms
      alter_table                  ... FAILED (test process exited with
exit code 2)       18 ms
      sequence                     ... FAILED (test process exited with
exit code 2)       11 ms
      polymorphism                 ... FAILED (test process exited with
exit code 2)       13 ms
      rowtypes                     ... FAILED (test process exited with
exit code 2)       10 ms
      returning                    ... FAILED (test process exited with
exit code 2)       11 ms
      largeobject                  ... FAILED (test process exited with
exit code 2)       10 ms
      with                         ... FAILED (test process exited with
exit code 2)       22 ms
      xml                          ... FAILED (test process exited with
exit code 2)       23 ms
      schema_variables             ... FAILED (test process exited with
exit code 2)       23 ms
parallel group (11 tests):  explain hash_part partition_info reloptions
memoize compression partition_aggregate partition_join indexing
partition_prune tuplesort
      partition_join               ... FAILED      902 ms
      partition_prune              ... ok         1006 ms
      reloptions                   ... ok          106 ms
      hash_part                    ... ok           99 ms
      indexing                     ... ok          929 ms
      partition_aggregate          ... ok          791 ms
      partition_info               ... ok          104 ms
      tuplesort                    ... ok         1099 ms
      explain                      ... ok           90 ms
      compression                  ... ok          214 ms
      memoize                      ... ok          109 ms
parallel group (2 tests):  event_trigger oidjoins
      event_trigger                ... ok          107 ms
      oidjoins                     ... ok          157 ms
test fast_default                 ... ok          138 ms
test stats                        ... ok          617 ms



On 9/9/21 6:59 AM, Pavel Stehule wrote:
> Hi
>
> fresh rebase
>
> Regards
>
> Pavel
>