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
SQLite does support selects with multiple joins, but with ecto I get an exception:
An exception is thrown at this place:
sqlite_ecto2/lib/sqlite_ecto/connection.ex
Line 242 in 7ba0b62
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