Re: Schema variables - new implementation for Postgres 15

Hi

čt 9. 9. 2021 v 12:21 odesílatel Erik Rijkers <er(at)xs4all(dot)nl> napsal:

> > [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.
>

This morning I tested it. I'll recheck it.

Pavel

> (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
> >
>