New Features 🎉
- Support expressions in JoinScan DISTINCT target lists (e.g.,
upper(name),name IS NULL).
Stability Improvements 💪
- Fix JoinScan
DISTINCTplanning for deferred keys. - Fix JoinScan pushdown with outer-only
ORDER BYpathkeys. - Fix
pdb.score()withSELECTsubquery inWHEREclause. - Handle
IN (SELECT ...) OR IS NULLvia LeftMark JoinScan. - Fix score filter for joins and cases without other quals.
- Handle pruned columns in nested semi/anti join keys.
- Handle aliased indexed expressions in search resolution and top-k order by.
- Lower x86_64 target-cpu from x86-64-v3 to x86-64-v2 for broader hardware compatibility.
- Prevent DSM buffer overflow in PG18 parallel index scans.
- Fix
PlaceHolderVar found where not expectederror. - Restore
pdb.agg(jsonb)if accidentally removed by an upgrade script.