Skip to content

Conversation

@jechol
Copy link
Contributor

@jechol jechol commented Oct 30, 2025

Reproduces a bug where combining select() + limit() with an aggregate that uses parent() in its filter causes SQL error.

This bug was found in ash_graphql where GraphQL list queries would automatically trigger this scenario.

Contributor checklist

Leave anything that you believe does not apply unchecked.

  • I accept the AI Policy, or AI was not used in the creation of this PR.
  • Bug fixes include regression tests
  • Chores
  • Documentation changes
  • Features include unit/acceptance tests
  • Refactoring
  • Update dependencies

Reproduces a bug where combining select() + limit() with an aggregate
that uses parent() in its filter causes SQL error.

This bug was found in ash_graphql where GraphQL list queries would
automatically trigger this scenario.
@jechol jechol force-pushed the test/aggregate-with-parent-filter-bug branch from ae18908 to e32aba4 Compare October 30, 2025 04:08
@zachdaniel
Copy link
Contributor

🔥 thanks for the repro!

@zachdaniel zachdaniel merged commit 7b8910b into ash-project:main Nov 4, 2025
58 of 67 checks passed
rgraff added a commit that referenced this pull request Dec 10, 2025
…tributes

* main: (23 commits)
  fix: do not build query filter with or: [] when all records are successfully inserted, for return_skipped_upsert?: true (#659)
  test: load aggregate with select and sort on from_many relationship (#661)
  test: add failing test for expr(has_one.function_calc) nil poisoning in batch (#660)
  test: aggregate with parent ref in relationship filter and sorting on relationship field (#658)
  test: binding error when loading aggregate (#657)
  chore(deps): bump ash_sql in the production-dependencies group (#656)
  test: multi relationship problems (#654)
  chore: release version v2.6.26
  chore: update ash_sql, use new select binding
  test: add complex calculation tests with filtered aggregates (#652)
  improvement: add generator to tsvector type (#655)
  test: add failing test for aggregate filtering on nested first aggregate (#653)
  chore: update ash_sql and add test
  docs: Mention :define_ecto_repo? option of use AshPostgres.Repo macro in getting started guide (#648)
  improvement: verify check constraint attributes at compile time
  chore: update ash
  chore: reuse compliance
  improvement: update deps for bug fixes
  chore: release version v2.6.25
  test: Add failing test for aggregate with parent() + select() + limit() (#644)
  ...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants