elixir-sqlite/sqlite_ecto2

Support select distinct with multiple columns

kiru opened this issue · 0 comments

kiru commented

SQLite does support selects with multiple joins, but with ecto I get an exception:

An exception is thrown at this place:

raise ArgumentError, "DISTINCT with multiple columns is not supported by SQLite"

Is this just a not-implemented case?

What is the return value of the distinct method? (I am not that familiar with the codebase)

edit:
It seems some select statement with distinct works. Can anyone explain this case?

https://github.com/elixir-sqlite/sqlite_ecto2/blob/master/test/sqlite_ecto_test.exs#L203