JohnnyCurran
I cannot figure out why this test is failing. It fails on assert result_one == result_two. The hardcoded string sigil query returns a list of length 1, the interpolated query returns an empty list.
The Jason.encode’d struct is apparently the same as the hardcoded string sigil.
The schema of Job isn’t that important, just that custom_fields is a jsonb column.
test "json" do
intern = %{"Employment Type" => "Intern"}
insert(:job, custom_fields: intern)
intern_json = Jason.encode!(intern)
assert intern_json === ~s|{"Employment Type":"Intern"}| # This passes fine
query =
from j in Job,
as: :job,
where: fragment("custom_fields @> ?", ^intern_json),
select: j.id
query_two =
from j in Job,
where: fragment("custom_fields @> ?", ~s|{"Employment Type":"Intern"}|),
select: j.id
result_one = Repo.all(query)
result_two = Repo.all(query_two)
assert result_one == result_two # Failure here
end
Result:
Assertion with == failed
code: assert result_one == result_two
left: []
right: ["job_id0"]
Thanks for all the help
Trending in Questions
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
Hi everyone,
I am toying with the idea of building a “match maker” for giving personal help to people that wants to start coding.
I sta...
New
Hello,
I know there is an approach for handling lists that allows for optimized traversal, but I can’t recall the specific method (somet...
New
Documentation
While reading the Scoped Routes section, I noticed that the documentation currently refers to a problem without explainin...
New
So my question is quite simple and i have found no conclusive answer on forum, google or AI.
Should we use :erlang.float for Integer to ...
New
I recently noticed that Elixir’s Logger defaults its primary log level to :debug when no :logger, :level application configuration is pre...
New
I’m new to elixir and just tried to install the elixirLS extension for VScode(ium) and it is throwing some errors that I would like help ...
New
Other Trending Topics
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
Hi there! We created Gust: A task orchestrator inspired by Airflow.
For those who have never heard about Aiflow, it’s a Python-based wor...
New
Hi everyone!
The first release candidate for the Expert language server project is now available!
We’ve published a press release detai...
New
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
Xamal is a deployment tool for Elixir apps that deploys native releases to bare metal servers over SSH. It’s a port of GitHub - basecamp/...
New
With AI doing more of the implementation work, I’ve been wondering how much coding I should deliberately keep doing myself.
My main conc...
New
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixirconf-us
- #ai
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #elixirconf-eu
- #metaprogramming
- #hex











Showing Posts 1 to 4- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
LostKobrakai
Can you run both queries through
MyApp.Repo.to_sqland see if they’re somehow different?JohnnyCurran
The second query is surrounded in single quotes but I’m not sure if that’s just what it would look like if it wasn’t interpolated?
LostKobrakai
That is the difference though. With a hardcoded value ecto doesn’t parameterize the value, so postgres knows the type of the value. With a parameterized value however you likely need to give postgres some hints on what type of value this is supposed to be.
JohnnyCurran
Okay, figured it out:
Instead of using
Jason.encode, usetype/2with:map:Thanks!