Mysql Boolean Issue going from Dashboard to Question

[csyperski]

Hello, I'm having an issue passing my filters from a dashboard, where the filter works to a specific question, specifically with fields that are:

| iep | tinyint(1) or boolean in the DDL

When I attempt to view a table that should have this IEP flag passed to the question here is what I am seeing:

You can see that the data isn't filtered and true is being shown twice, if I select the 2nd true option it works. see below....

I've been pulling my hair out trying different datatypes to get this to work, and I can seem to. I've tried using bit as well and it seems to happen with all boolean fields.

I'm on You're on version v0.40.5 on Ubuntu 20.04 using
openjdk version "11.0.11" 2021-04-20
OpenJDK Runtime Environment (build 11.0.11+9-Ubuntu-0ubuntu2.20.04)
OpenJDK 64-Bit Server VM (build 11.0.11+9-Ubuntu-0ubuntu2.20.04, mixed mode, sharing)

This only occurs in navigating from the dash to the question.

Please help, I really want to use Metabase, but this might be a deal breaker for us! Thanks so much for any assistance!

[csyperski]

In more troubleshooting I'm finding that when I pass iep=1 via the URL instead of iep=true, it looks like the filtering does work, but the selection filter box now has three values for a boolean field, which doesn't seem correct.

[flamber]

Hi @csyperski
Boolean filters have some known problems, which is being fixed right now and should be in 0.41
https://github.com/metabase/metabase/issues/15498 - upvote by clicking on the first post

[csyperski]

Thanks for the quick response, are there any known work around for this or are there nightly builds I can that have a fix for this?

[flamber]

@csyperski You can use the build from the PR listed in the bottom of the issue.

[csyperski]

Is the fix included in 0.41 RC1? If so, will I be able to update to 0.41 official from the RC? (or could there be incompatible schema changes in the h2 db)? Or is the 0.41 release coming soon where I should just wait? What's RC -> Official typically look like?

[flamber]

@csyperski No, look here: https://github.com/metabase/metabase/pull/18104

Hopefully it gets merged today, and we're likely going to do a RC2 next week, where it would then be included. Yes, 0.41 is coming soon. When? I don't know, soon.

As with any other software, remember to backup before upgrading.
You can always upgrade, just not downgrade.
You should absolutely not be using H2 for your application database:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html

[csyperski]

I just wanted to confirm that version 0.41 fixed the boolean issue for me, thanks so much!