vkryukov

vkryukov

Can Ash calculation return a map?

Hi, I have the following calculation in one of my resources:

  calculations do
    calculate :llm_model,
              :map,
              expr(
                cond do
                  role == :basic -> %{"model" => "gpt-4o-mini"}
                  role == :pro -> %{"model" => "o3-mini", "reasoning_effort" => "medium"}
                  role == :admin -> %{"model" => "o3-mini", "reasoning_effort" => "high"}
                end
              )
  end

This compiles without any problems, and my reading of Ash.Resource — ash v3.29.3 is that any return type, including :map, is allowed.

However, I get the following error when executing this code, where victor is a User resource:

victor |> Ash.load!(:llm_model)
[debug] QUERY ERROR source="users" db=2.3ms queue=1.4ms idle=1593.8ms
SELECT u0."id", (CASE WHEN u0."role"::varchar::varchar = $1::varchar::varchar THEN $2 WHEN u0."role"::varchar::varchar = $3::varchar::varchar THEN $4 WHEN u0."role"::varchar::varchar = $5::varchar::varchar THEN $6 ELSE NULL END) FROM "users" AS u0 WHERE (u0."id"::uuid::uuid = $7::uuid::uuid) [:basic, %{"model" => "gpt-4o-mini"}, :pro, %{"model" => "o3-mini", "reasoning_effort" => "medium"}, :admin, %{"model" => "o3-mini", "reasoning_effort" => "high"}, "ab2ba555-671f-4d73-861d-c9171ec7ec9b"]
↳ anonymous fn/3 in AshPostgres.DataLayer.run_query/2, at: lib/data_layer.ex:785
** (Ash.Error.Unknown)
Bread Crumbs:
  > Error returned from: FiveWhys.Accounts.User.read

Unknown Error

* ** (DBConnection.EncodeError) Postgrex expected a binary, got %{"model" => "gpt-4o-mini"}. Please make sure the value you are passing matches the definition in your table or in your query or convert the value accordingly.
<...>

I understand it that there is an attempt to evaluate the expression in Postgresql level, which understandably fails.

Am I expecting too much from calculated fields here? I can of course split it into two calculated fields, e.g., model and reasoning_effort, but I’m curious what is the idiomatic Ash solution here.

Marked As Solved

zachdaniel

zachdaniel

Creator of Ash

This is a bug. Can you open an issue on the ash_postgres repo with a link to a reproduction?

Also Liked

vkryukov

vkryukov

Yes, upgraded everything and can confirm that the bug is still there:

Upgraded:
  ash 3.5.2 => 3.5.4
  ash_admin 0.13.3 => 0.13.4
  ash_authentication 4.6.3 => 4.6.4
  ash_authentication_phoenix 2.5.2 => 2.5.3
  ash_graphql 1.7.6 => 1.7.7
  ash_phoenix 2.1.25 => 2.1.26
  ash_postgres 2.5.14 => 2.5.15
  ash_sql 0.2.66 => 0.2.67

Created a ticket: Calculated field with :map return type doesn't work with Postgres backend · Issue #528 · ash-project/ash_postgres · GitHub

Last Post!

vkryukov

vkryukov

Yes, upgraded everything and can confirm that the bug is still there:

Upgraded:
  ash 3.5.2 => 3.5.4
  ash_admin 0.13.3 => 0.13.4
  ash_authentication 4.6.3 => 4.6.4
  ash_authentication_phoenix 2.5.2 => 2.5.3
  ash_graphql 1.7.6 => 1.7.7
  ash_phoenix 2.1.25 => 2.1.26
  ash_postgres 2.5.14 => 2.5.15
  ash_sql 0.2.66 => 0.2.67

Created a ticket: Calculated field with :map return type doesn't work with Postgres backend · Issue #528 · ash-project/ash_postgres · GitHub

Where Next?

Popular in Questions Top

Brian
What is the proper way to load a module from a file in to IEX? In the python world, doing something like this pretty standard: from ....
New
dokuzbir
I want to highlight html closing tags when i click a html tag. That works in .html files but doesnt work for html.eex templates. How can...
New
joeerl
Hello again - after a longish gap I’ve decided I really must dig into Elixir and see what’s been happening here - so I have a few questio...
New
Fl4m3Ph03n1x
About me? ( if you have nothing better to do than reading about some random guy in the internet :stuck_out_tongue: ) Hello all, this is ...
New
9mm
I am constructing a JSON object (map) and I need to conditionally set a field. I’m trying to write proper elixir-way code… and I’m at a l...
New
komlanvi
Hi everyone, I was playing with phoenix liveView but I run into an issue. I have a form and want to validate each input text when the te...
New
Harrisonl
We have an ECS cluster with 4 services, where each task joins a single cluster, via discovery ECS discovery service. Currently when I de...
New

Other popular topics Top

vonH
In asking this question I am more interested about the expressiveness of the language itself and less concerned about the availability of...
New
Darmani72
If I have a post route which an argument: post /my_post_route/:my_param1, MyController.my_post_handler How would get the post params ...
New
gausby
I asked this very same question on twitter and got some interesting feedback, but I thought it would be a good question to ask here as we...
1207 40165 209
New
dblack
I’ve got an issue with an app and I’ve no idea of how to troubleshoot it. I’m hoping someone here might have seen something similar. I p...
New
romenigld
I am trying to run a deploy with docker and I successfully runned with this command: docker build -t romenigld/blog-prod . but when I t...
New
Patoshizzle
After calling mix ecto.create I get this error: 17:00:32.162 [error] GenServer #PID&lt;0.412.0&gt; terminating ** (Postgrex.Error) FATAL...
New

We're in Beta

About us Mission Statement