Alvinkariuki
Ecto Query Returns unwanted data
I am trying to write a query that gets all users matching a criteria
The postgresql query is as follows
select id from users WHERE account_id IS NOT NULL LIMIT 10 OFFSET 10;
in this example, the number of users that match the given criteria are 12, meaning that for this query, only two user ids will be returned since it skips by 10 rows. This brings the correct data.
I have written the same query in ecto as follows
from(u in User, where: not is_nil(u.account_id), limit: 10, offset: 0 , select: u.id) |> Repo.all()
expected response:
{:ok, [11, 12]}
actual response:
'\f\r'
what is going on?
Marked As Solved
dimitarvp
They are the same, you’re simply seeing them formatted as characters because iex is trying to be helpful.
Run this in iex – [11, 12] == '\f\r'
Also Liked
sodapopcan
It’s a subtle syntactic difference and has been the cause of many questions. If you upgrade to the latest version of Elixir, charlists are now output using the new ~c sigil which is much easier to catch. You would have seen ~c"\f\r".
sodapopcan
Repo.all() returns a “bare” list, not an :ok/:error tuple.
Because you are only selecting ids that are each less than 255, they are being output as a charlist. The IDs in your case happen to correspond to the ascii characters \f and \r.
EDIT: or [11, 12] as @dimitarvp more helpfully said 
dimitarvp
Oops yeah, OP still needs to make sure the whole thing is wrapped in an :ok tuple indeed.
Wrong, see my next comment.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Enabling companies to succeed by building software people love.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Real-time error tracking, performance insights, and observability for devs.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"