Christoph Berg

Compiler warning from clang 14 on Debian unstable: ``` make[1]: Verzeichnis „/home/cbe/projects/postgresql/set-user/set-user“ wird betreten gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation...

The regression tests need to be updated for 2.17: ``` --- /home/cbe/projects/postgresql/hll/postgresql-hll/expected/setup.out 2022-09-21 14:54:06.147975874 +0200 +++ /home/cbe/projects/postgresql/hll/postgresql-hll/results/setup.out 2022-09-21 15:00:13.662572012 +0200 @@ -5,4 +5,3 @@ ALTER EXTENSION hll UPDATE TO '2.14';...

hll is incompatible with 32 bit systems: internal size 8 is invalid for passed-by-value type

1

hll compiles, but fails to load on 32 bit machines: ``` postgres@hll_regress ERROR: internal size 8 is invalid for passed-by-value type postgres@hll_regress STATEMENT: CREATE EXTENSION hll ```

Problems with building pg-auto-failover for Debian

2

Hi, following a discussion with @DimCitus I was trying to build pg-auto-failover for Debian (and apt.postgresql.org). Problem 1: ``` $ pg_buildext updatecontrol pg_buildext: error: No current PostgreSQL versions are supported...

Regression tests fail with PG 10+11

4

PostgreSQL 10 on Ubuntu Jammy: ``` 17:10:59 --- /tmp/autopkgtest.I0N6ZP/tree/expected/pushdown.out 2022-12-14 07:09:45.000000000 +0000 17:10:59 +++ /tmp/autopkgtest.I0N6ZP/tree/results/pushdown.out 2022-12-16 16:10:58.549828251 +0000 17:10:59 @@ -565,20 +565,16 @@ 17:10:59 17:10:59 EXPLAIN (COSTS FALSE, VERBOSE) 17:10:59...

Fix regression tests for different fetch size on 32-bit platforms

16

Net diff between server_options.out and server_options_1.out is: --- expected/server_options.out 2021-10-01 16:19:20.320972814 +0200 +++ expected/server_options_1.out 2021-10-01 16:22:04.428838428 +0200 @@ -235,11 +235,11 @@ -- Negative test cases for fetch_size option, should error...

Catch output variation for recent MariaDB server changes

3

MariaDB 10.5 prints "Unknown server host" instead of "Unknown MySQL server host". We are already normalizing the error message in tests, accept that form as well. Regression diff observed was:...

Incompatible with PostgreSQL 9.5

1

Hi, I've tried to update the pg-reorg Debian package for PostgreSQL 9.5 by simply adding rules to bin/Makefile, but apparently that's not enough with the 1.1.13 release: ``` --- 109,127...

SET is_cycle TO TRUE DEFAULT FALSE

1

sqlreduce shouldn't be this verbose in the CYCLE clause: ``` $ sqlreduce -d postgres WITH RECURSIVE run(x, y) AS ( SELECT 0, 0 UNION ALL SELECT x, y FROM run...

PostgreSQL 17: ERROR: commutator operator = is already the commutator of operator =

1

rdkit is not compatible with PG 17 yet: ``` **** /tmp/autopkgtest.Rnc5Gt/tree/Code/PgSQL/rdkit/regression.diffs **** diff -U3 /tmp/autopkgtest.Rnc5Gt/tree/Code/PgSQL/rdkit/expected/rdkit-91_1.out /tmp/autopkgtest.Rnc5Gt/tree/Code/PgSQL/rdkit/results/rdkit-91.out --- /tmp/autopkgtest.Rnc5Gt/tree/Code/PgSQL/rdkit/expected/rdkit-91_1.out 2024-05-23 12:10:12.000000000 +0000 +++ /tmp/autopkgtest.Rnc5Gt/tree/Code/PgSQL/rdkit/results/rdkit-91.out 2024-05-23 13:22:31.278341481 +0000 @@ -4,181 +4,160 @@...