I have a column in my Postgres database of type citext (case-insensitive text). However, when I add a filter on this column to a dashboard, the data is filtered in a case sensitive manner. If I run the raw SQL from Metabase, it produces the correct (case-insensitive) result. Any idea what could be going wrong here? Is Metabase doing some kind of caching/is this filtering happening outside of the database? Is there any way to correctly handle this? Should I open a bug report? Thanks for any help!
Post "Diagnostic Info" from Admin > Troubleshooting.
I don't think I understand. You are saying that Metabase makes a correct query on your database, but is not displaying those results. That sounds like a very big problem.
There's no caching unless you have enabled it:
Sounds like you are seeing this issue:
https://github.com/metabase/metabase/issues/21359 - upvote by clicking on the first post
@flamber I am facing the same issue.
Is the "case insensitive" filtering issues resolved in latest versions? If yes which version.
@abhay If you click the issue I linked, then you'll see it Closed and has Milestone 0.44.1