ash-project · zachdaniel · Dec 4, 2025 · Dec 4, 2025
diff --git a/test/aggregate_test.exs b/test/aggregate_test.exs
@@ -102,7 +102,7 @@
    assert read_post.count_of_comments == 1
  end

  test "loading optimizable first aggregate with relationship filter does not cause binding errors" do
    org =
      Organization
      |> Ash.Changeset.for_create(:create, %{name: "The Org"})
@@ -1976,7 +1976,36 @@
     end
   end
 
+  test "load aggregate with select and sort on from_many relationship" do
+    author =
+      Author
+      |> Ash.Changeset.for_create(:create, %{first_name: "John", last_name: "Doe"})
+      |> Ash.create!()
+
+    post =
+      Post
+      |> Ash.Changeset.for_create(:create, %{title: "Test Post"})
+      |> Ash.Changeset.manage_relationship(:author, author, type: :append_and_remove)
+      |> Ash.create!()
+
+    Comment
+    |> Ash.Changeset.for_create(:create, %{title: "Test Comment"})
+    |> Ash.Changeset.manage_relationship(:post, post, type: :append_and_remove)
+    |> Ash.create!()
+
+    results =
+      Post
+      |> Ash.Query.filter(id == ^post.id)
+      |> Ash.Query.select([:id, :title])
+      |> Ash.Query.sort([{Ash.Sort.expr_sort(expr(latest_comment.created_at)), :desc}])
+      |> Ash.Query.load(:author_first_name)
+      |> Ash.read!()
+
+    assert Enum.count(results) == 1
+    assert List.first(results).author_first_name == "John"
+  end
+
   test "aggregate with parent() ref in relationship filter and sorting on relationship field" do
     chat_1 =
       Chat
      |> Ash.Changeset.for_create(:create, %{name: "Test Chat"})