Skip to content

Instantly share code, notes, and snippets.

@fastcat

fastcat/bug.sql

Created October 13, 2023 14:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fastcat/9d51244a79a64c2a99a13894d7382ad2 to your computer and use it in GitHub Desktop.
Save fastcat/9d51244a79a64c2a99a13894d7382ad2 to your computer and use it in GitHub Desktop.
Download ZIP
PG bug 18156
Raw
bug.sql
create table x (
p int4 not null,
i int4 not null,
f int4 null,
primary key (p, i),
foreign key (p, f) references x (p, i)
)
partition by list (p);
create table x1 partition of x for values in (0);
insert into x values (0,1,null), (0,2,1);
delete from x where (p,i) = (0,1);
select * from x;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment