Open fire opened 5 years ago
Also replaced:
def filter_by_tags(query, tag) do
query
|> join(:inner, [a], p in fragment(
"""
WITH articles AS( SELECT a.id, unnest(a.tag_list) tag FROM articles a ORDER BY a.id, a.created_at) select * from articles
"""), a.id == p.id)
|> where([a], fragment("tag = ?", ^tag))
end
As of Cockroachdb 4.2.1 the subquery issue is gone, but the system doesn't work.
Hi @fire I'm not sure I follow. This project uses Postgres as the DB, I believe there are more changes required to make it work with a different DB.
Can you share elixir / otp version and what are the changes you made to try to make this work?
The same ecto driver for postgresql is able to be used for cockroachdb.
Trying cockroachdb on 2.1 beta (v2.1.0-beta.20181015):