Open martosaur opened 8 months ago
Thank you for the report. We should probably add more test repos for other adapters than postgrex and automatically run the existing tests on all of those repos. I don't know when I'll get to setting this up, though. Contributions are welcome.
Summary
:empty
and:not_empty
filters doesn't seem to be working for SQLite DBSteps to reproduce
Setup flop for a project with SQLite DB and try to filter a column using
:empty
op.Expected behaviour
Columns is filtered normally
Actual behaviour
Query always returns empty list
Elixir/Erlang version
Elixir 1.15.7 (compiled with Erlang/OTP 26) Elixir 1.16.0 (compiled with Erlang/OTP 26)
Flop and Ecto versions
The test is written for
main
's headAdditional context
I was able to dig it to this point. Consider this test:
It would be reasonable to expect those queries to be equal, but they are different:
I suspect SQLite adapter might have a different behaviour for
true: :any
param then postgres, hence the issue.