Hello David,
03.07.2024 13:41, David Rowley wrote:
Lastly, I think this would benefit from a test in
regress/sql/explain.sql, as the test changes that were included
removed the only occurrance of a Materialize node from the regression
tests' EXPLAIN outputs.
I've modified the tests where the previous patch disabled
enable_material to enable it again and mask out the possibly unstable
part. Do you think that's an ok level of testing?
Please look at a segfault crash introduced with 1eff8279d:
CREATE TABLE t1(i int);
CREATE TABLE t2(i int) PARTITION BY RANGE (i);
CREATE TABLE t2p PARTITION OF t2 FOR VALUES FROM (1) TO (2);
EXPLAIN ANALYZE SELECT * FROM t1 JOIN t2 ON t1.i > t2.i;
Leads to:
Core was generated by `postgres: law regression [local] EXPLAIN
'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0 0x000055c36dbac2f7 in tuplestore_storage_type_name (state=0x0) at
tuplestore.c:1476
1476 if (state->status == TSS_INMEM)
Best regards,
Alexander