Skip to content

v0.48.0

Choose a tag to compare

View all tags
@stephenafamo stephenafamo released this 26 Jun 21:45
· 72 commits to main since this release
v0.48.0
bf3b99b

Changed

  • PostgreSQL single-column relationship loaders — both the slice relationship query (<Parent>Slice.<Rel>) and the batch count method (<Parent>Slice.LoadCount<Rel>) — now filter related rows with col = ANY($1) instead of col IN (SELECT unnest($1)), so the query planner can use an index scan on the foreign key instead of a Seq Scan + Hash Semi Join. Composite-key relationships keep the existing IN (SELECT unnest(...)) form. (thanks @sandonemaki)

Fixed

  • Fixed PostgreSQL generated query parsing for CTEs that use table functions in FROM (for example unnest(...) AS alias), which could incorrectly widen CTE spans and generate malformed query mods such as duplicated outer SELECT projections.

Full Changelog: v0.47.0...v0.48.0

Contributors

sandonemaki
Assets 2
Loading