It doesn’t. Sqlite version directly depends on the c source file used by exqlite, namely sqlite3.c.
The easiest method to track down the version is to look at commit history, there you should be able to correlate to what exqlite version it belongs.
iex(895)> import Ecto.Query
iex(896)> q = (Customer
...(896)> |> join(:inner, [c], o in assoc(c, :orders))
...(896)> |> group_by([c, o], c.id)
...(896)> |> select([c, o], %{id: c.id, name: c.name, num_orders: count(o.id)})
...(896)> |> order_by([c, o], desc: count(o.id))
...(896)> |> limit(5))
#Ecto.Query<from c0 in NorthwindElixirTraders.Customer,
join: o1 in assoc(c0, :orders), group_by: [c0.id],
order_by: [desc: count(o1.id)], limit: 5,
select: %{id: c0.id, name: c0.name, num_orders: count(o1.id)}>
iex(898)> Ecto.Adapters.SQL.to_sql(:all, Repo, q) |> elem(0) |> IO.puts
SELECT c0."id", c0."name", count(o1."id") FROM "customers" AS c0 INNER JOIN "orders" AS o1 ON o1."customer_id" = c0."id" GROUP BY c0."id" ORDER BY count(o1."id") DESC LIMIT 5
:ok
$ sqlite3 northwind_elixir_traders_repo.db
SQLite version 3.40.1 2022-12-28 14:03:47
Enter ".help" for usage hints.
sqlite> SELECT c0."id", c0."name", count(o1."id") FROM "customers" AS c0 INNER JOIN "orders" AS o1 ON o1."customer_id" = c0."id" GROUP BY c0."id" ORDER BY count(o1."id") DESC LIMIT 5;
20|Ernst Handel|10
63|QUICK-Stop|7
65|Rattlesnake Canyon Grocery|7
87|Wartian Herkku|7
37|Hungry Owl All-Night Grocers|6
The query is pretty mundane, no?
mix deps.clean --all
rm -rf _build .elixir_ls
mix deps.get
mix compile
“issue still exists. it’s just this group_by function that blows up”
