Questions & Help>Questions

How to write relationships with no_attributes?

/ash#relationship
rapidfsub

rapidfsub

This is Product.relationships code.
https://github.com/rapidfsub/sonet/blob/develop/test/support/lib/sonet_lib/seven_eleven/product.ex#L44

This is load test code for above relationships.
https://github.com/rapidfsub/sonet/blob/develop/test/sonet_lib/seven_eleven/product_test.exs#L24

I think three stores, stores_alt1, stores_alt2 relationships should be equivalent.
But, only the stores relationship works,
and other two relationships raise Ecto.Query.CompileError.

I’m confused how to write relationship with no_attributes? true.
Is there any proper way to write this kind of relationships correctly? @zachdaniel

10 comments
/ash#relationship
432 10

Showing Posts 10 to 1

rapidfsub

rapidfsub OP

The bug I reported is fixed, but I found another one related to original one.
I opened a new issue in ash_postgres.
https://github.com/ash-project/ash_postgres/issues/413

0
Post #10
rapidfsub

rapidfsub OP

Thanks.

0
Post #9
zachdaniel

zachdaniel

Creator of Ash

This is fixed in main of ash_postgres. I will release new versions of ash and ash_postgres this week.

2
Post #8
zachdaniel

zachdaniel

Creator of Ash

Thank you, I’ll take a look in the next day or two.

0
Post #7
rapidfsub

rapidfsub OP

I opened a bug report about this.
https://github.com/ash-project/ash_postgres/issues/412

0
Post #6
zachdaniel

zachdaniel

Creator of Ash

If you can, please provide a reproduction and as much detail as you can. Ideally a test I can run that reproduces the specific error :smiley:

0
Post #5
zachdaniel

zachdaniel

Creator of Ash

** (Ecto.Query.CompileError) only one distinct expression is allowed in query
is a bug.

Please open a bug report.

0
Post #4
rapidfsub

rapidfsub OP

I will explain more about my question.

There are three resources: Store, Inventory, Product.
Store and Product is simple resource, and Inventory is join table resource.

  • Store
    has_many :inventories
  • Product
    has_many :inventories
  • Inventory
    belongs_to :store
    belongs_to :product

I know there is many_to_many feature,
but I wanted to show you there are some hard things when using no_attributes? true.

A private project in our company uses no_attributes? true a lot
(There are some scenarios our company have, only no_attributes? true can be a solution.),
and I meet this kind of error a lot.
How can I avoid these errors and write correct relationship?
Or is this an bug?

0
Post #3
rapidfsub

rapidfsub OP

Here are the stacktraces.

stacktrace for stores_alt1

  1) test relationships stores (SonetLib.SevenEleven.ProductTest)
     test/sonet_lib/seven_eleven/product_test.exs:24
     ** (Ecto.Query.CompileError) only one distinct expression is allowed in query
     code: Ashex.load!(product, [:stores_alt1])
     stacktrace:
       (ash_postgres 2.4.11) lib/data_layer.ex:1102: AshPostgres.DataLayer.lateral_join_query/3
       (ash_postgres 2.4.11) lib/data_layer.ex:961: AshPostgres.DataLayer.run_query_with_lateral_join/4
       (ash 3.4.35) lib/ash/actions/read/read.ex:2650: Ash.Actions.Read.run_query/4
       (ash 3.4.35) lib/ash/actions/read/read.ex:542: anonymous fn/8 in Ash.Actions.Read.do_read/5
       (ash 3.4.35) lib/ash/actions/read/read.ex:886: Ash.Actions.Read.maybe_in_transaction/3
       (ash 3.4.35) lib/ash/actions/read/read.ex:269: Ash.Actions.Read.do_run/3
       (ash 3.4.35) lib/ash/actions/read/read.ex:81: anonymous fn/3 in Ash.Actions.Read.run/3
       (ash 3.4.35) lib/ash/actions/read/read.ex:80: Ash.Actions.Read.run/3
       (ash 3.4.35) lib/ash/actions/read/relationships.ex:413: anonymous fn/2 in Ash.Actions.Read.Relationships.do_fetch_related_records/4
       (ash 3.4.35) lib/ash/actions/read/relationships.ex:65: Ash.Actions.Read.Relationships.fetch_related_records/4
       (ash 3.4.35) lib/ash/actions/read/relationships.ex:24: Ash.Actions.Read.Relationships.load/4
       (ash 3.4.35) lib/ash/actions/read/read.ex:298: Ash.Actions.Read.do_run/3
       (ash 3.4.35) lib/ash/actions/read/read.ex:81: anonymous fn/3 in Ash.Actions.Read.run/3
       (ash 3.4.35) lib/ash.ex:1859: Ash.load/3
       (ash 3.4.35) lib/ash.ex:1813: Ash.load/3
       (ash 3.4.35) lib/ash.ex:1754: Ash.load!/3
       test/sonet_lib/seven_eleven/product_test.exs:28: (test)

stacktrace for stores_alt2

  1) test relationships stores (SonetLib.SevenEleven.ProductTest)
     test/sonet_lib/seven_eleven/product_test.exs:24
     ** (Ecto.Query.CompileError) only one distinct expression is allowed in query
     code: Ashex.load!(product, [:stores_alt2])
     stacktrace:
       (ash_postgres 2.4.11) lib/data_layer.ex:1102: AshPostgres.DataLayer.lateral_join_query/3
       (ash_postgres 2.4.11) lib/data_layer.ex:961: AshPostgres.DataLayer.run_query_with_lateral_join/4
       (ash 3.4.35) lib/ash/actions/read/read.ex:2650: Ash.Actions.Read.run_query/4
       (ash 3.4.35) lib/ash/actions/read/read.ex:542: anonymous fn/8 in Ash.Actions.Read.do_read/5
       (ash 3.4.35) lib/ash/actions/read/read.ex:886: Ash.Actions.Read.maybe_in_transaction/3
       (ash 3.4.35) lib/ash/actions/read/read.ex:269: Ash.Actions.Read.do_run/3
       (ash 3.4.35) lib/ash/actions/read/read.ex:81: anonymous fn/3 in Ash.Actions.Read.run/3
       (ash 3.4.35) lib/ash/actions/read/read.ex:80: Ash.Actions.Read.run/3
       (ash 3.4.35) lib/ash/actions/read/relationships.ex:413: anonymous fn/2 in Ash.Actions.Read.Relationships.do_fetch_related_records/4
       (ash 3.4.35) lib/ash/actions/read/relationships.ex:65: Ash.Actions.Read.Relationships.fetch_related_records/4
       (ash 3.4.35) lib/ash/actions/read/relationships.ex:24: Ash.Actions.Read.Relationships.load/4
       (ash 3.4.35) lib/ash/actions/read/read.ex:298: Ash.Actions.Read.do_run/3
       (ash 3.4.35) lib/ash/actions/read/read.ex:81: anonymous fn/3 in Ash.Actions.Read.run/3
       (ash 3.4.35) lib/ash.ex:1859: Ash.load/3
       (ash 3.4.35) lib/ash.ex:1813: Ash.load/3
       (ash 3.4.35) lib/ash.ex:1754: Ash.load!/3
       test/sonet_lib/seven_eleven/product_test.exs:32: (test)
0
Post #2
zachdaniel

zachdaniel

Creator of Ash

What are the details of the error? Just knowing Ecto.Query.CompileError is not really useful without more information.

With that said, could you also describe specifically what the stores relationship is meant to provide?

I can’t really give advice as I don’t know what you’re specifically looking to do.

0
Post #1
— All posts loaded —

Where Next? Top

View thread on forum (has 10 replies!)
ash
relationship
Home Questions & Help>Questions
2 285 10
Last post
REPLY VIEW THREAD WITH 10 POSTS

Trending in Questions Top

katta
Questions & Help>Questions

Phoenix Ecto realistic benchmarks
I having some trouble figuring out if I have set myself too strict of standards for my production server. Currently I can handle 75% of r...
/phoenix#ecto#troubleshooting
2 1863 12
New
achenet
Questions & Help>Questions

No Tailwind binary for FreeBSD
Hello, I’m trying to build a basic Phoenix web-app, and I’d like to use Tailwind. However, when I launch mix phx.server, I get an error...
/phoenix#freebsd#tailwindcss#tailwind
11 1073 14
New
bradley
Questions & Help>Questions

Are there any generic KMS libraries out there?
I really like the adapter patterns that ecto, nebulex, waffle, etc. use and would love find something similar for a key management servic...
#libraries#hex-packages
1 953 3
New
Cxx-mlr
Questions & Help>Questions

Using try/catch with update_in/3
I’m working on a small exercise involving update_in/3, and I came up with this solution: data = %{ name: "Periodic Table", category:...
#learning-elixir
9 273 12
New
unaware8150
Questions & Help>Questions

What could be a clean way to handle constant strings across a codebase?
Hello folks! So at work, we are seeing some situations where we have to define some “fixed” strings that are used across the codebase in...
#learning-elixir
21 487 17
New
ChrisAmelia
Questions & Help>Questions

Need help understanding order of function calls from Phoenix auth
I’ve got trouble wrapping my head around the order in which functions are called in this snippet (from Phoenix’s authentication): toke...
/phoenix#learning-elixir
0 76 2
New
dillonoconnor
Questions & Help>Questions

Hologram compiler and iex -S mix
Is there any way to avoid the Hologram compiler running when using iex? It seems like the front-end code could potentially be disregarded...
/hologram#iex
2 386 3
New

Other Trending Topics Top

GenericJam
News>Announcing

Mob - Native BEAM / Elixir on Native Mobile
Edit: 2026 May 15 - This post is archived. Mob is alive!! Main docs: mob v0.7.11 — Documentation A bit of explanation for the slightly c...
/mob#library#beam#mobile#liveview#react-native#mobile-app#mobile-development
259 8396 111
New
garrison
News>Announcing

Hobbes - a low-level distributed database for the Elixir programming language
Hobbes is a low-level distributed database for the Elixir programming language. Hobbes provides a simple, safe, and scalable storage lay...
#library#database#distributed#hobbes
306 6242 88
New
budgie
Chat & Discussions>Discussions

I genuinely hate programming now
A little off-topic, but I feel like people here have a good head on their shoulders. I used to be quite good at making software. Was luc...
#ai#career#rant
460 3763 113
New
KristerV
Chat & Discussions>AI / LLMs

State of developing agents with Elixir (not coding agents)
Hey. Is there anyone here who creates agents in their apps? Not talking about using agents, but creating them. I’m finding it pretty diff...
#agent#ai#llm#dev-tools#ai-tools
31 3653 21
New
mcass19
News>Announcing

ExRatatui - Elixir bindings for the Rust ratatui terminal UI library
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
#library#rust#terminal#tui
60 3370 16
New
juhalehtonen
Chat & Discussions>Discussions

Stack Overflow Developer Survey 2026
There has been a thread to discuss the Stack Overflow Developer Survey on this forum every year since 2018, so here’s yet another one for...
#developer-survey#stack-overflow
10 4244 4
New
Back to top

Latest Ash Threads

Ash Forum ❯

Questions & Help>Questions

Questions Questions ❯

Latest on Elixir Forum

Elixir Forum ❯

Sponsor Spotlight

Defacto

Bringing learning, work and compliance together since 1987.

Our Sponsors

Dashbit

Build Elixir applications with speed and confidence.

EEF

Supporting innovation across the BEAM ecosystem.

AppSignal

Catch errors, track performance, monitor hosts and more.

Honeybadger

Error tracking, logs, uptime, and Just Enough APM. Built for developers.

Code Sync

Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!

Manning

Master modern tools, write cleaner code, and tackle real-world challenges.

Defacto

Bringing learning, work and compliance together since 1987.

Potions

The deployment platform built for Elixir: PaaS ease, VPS control.

Software Mansion

The team behind Membrane, Popcorn, LiveDebugger. Available for hire.

Pragmatic Studio

Courses that'll move you from confusion to "Aha, now I get it!"

View all our sponsors ❯

Categories:

Sub Categories:

Forums

Popular Tags

Our Sponsors

Dashbit

Build Elixir applications with speed and confidence.

EEF

Supporting innovation across the BEAM ecosystem.

AppSignal

Catch errors, track performance, monitor hosts and more.

Honeybadger

Error tracking, logs, uptime, and Just Enough APM. Built for developers.

Code Sync

Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!

Manning

Master modern tools, write cleaner code, and tackle real-world challenges.

Defacto

Bringing learning, work and compliance together since 1987.

Potions

The deployment platform built for Elixir: PaaS ease, VPS control.

Software Mansion

The team behind Membrane, Popcorn, LiveDebugger. Available for hire.

Pragmatic Studio

Courses that'll move you from confusion to "Aha, now I get it!"

View all our sponsors ❯

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews