Re: BUG #16690: database connection aborted with a signal 9 when query is run on MacOS Catalina

PG Bug reporting form <noreply@postgresql.org> writes:
> The following query works on...
> Windows 10 Education Build 1909 18363.1139 PostgreSQL 12.1, compiled by
> Visual C++ build 1914, 64-bit
> Mojave 10.14.6 PostgreSQL 12.1 on x86_64-apple-darwin, compiled by Apple
> LLVM version 6.0 (clang-600.0.54) (based on LLVM 3.5svn), 64-bit

> but causes a database connection to be aborted (signal 9) when run on...
> Catalina 10.15.6 PostgreSQL 12.1 on x86_64-apple-darwin, compiled by Apple
> LLVM version 6.0 (clang-600.0.54) (based on LLVM 3.5svn), 64-bit

Not a lot we can do with that level of detail.  Can you provide a
self-contained test case?  (That is, besides the query, we need the
table definitions and some possibly-dummy data.  Ideally, provide a
SQL script that provokes the crash starting from an empty database.)

It'd also be quite useful to know what build options you used.
Notably, I'm wondering about whether you enabled JIT (--with-llvm).

            regards, tom lane