Re:BUG #19625: SQL/JSON boolean DEFAULT expression silently replaced with 'false'

Started by zengman7 days ago2 messagesbugs
Beta feature

Hackorum builds and tests every patch posted to the lists, not only commitfest submissions. This is Hackorum's own CI rather than the PostgreSQL project's, and it is still under testing - please report anything that looks wrong.

appliessuccessCI history

You can run a PostgreSQL built from this patch straight from Docker, with no checkout and no build:

docker run --rm -p 5432:5432 ghcr.io/hackorum-dev/postgres-patch:t253456
psql -h localhost -U postgres

Built from patchset v2 (message #2), August 24, 2026 at 03:50 AM.

Every patchset is also pushed to a branch of our PostgreSQL fork, so you can check out the same tree CI built. Without a PostgreSQL checkout:

git clone --branch t253456_2 https://github.com/hackorum-dev/postgres.git

In a checkout you already have, add the fork once:

git remote add hackorum https://github.com/hackorum-dev/postgres.git

then, for this patchset and every later one:

git fetch hackorum t253456_2 && git checkout t253456_2

Patchset v2 (message #2) is on t253456_2

Jump to latest
#1zengman
zengman@halodbtech.com

Hi,

The formatting above seems a bit messed up, so I am re-attaching the diff file.

--
Regards,
Man Zeng

Attachments:

t253456_1
json-bool-default-fix.patchapplication/octet-stream; charset=gb18030; name=json-bool-default-fix.patchDownload+9-12
#2zengman
zengman@halodbtech.com
In reply to: zengman (#1)

Added regression tests and rebased.

--
Regards,
Man Zeng

Attachments:

t253456_2
0002-json-bool-default-fix.patchapplication/octet-stream; charset=gb18030; name=0002-json-bool-default-fix.patchDownload+33-12