Bug description
I am using Superset 4.1.3 for MySQL database, and I noticed that boolean fields are not displayed correctly in the Explore/SQL Lab table preview.
For example, fields like:
Enabled
EmailConfirmed
PhoneNumberConfirmed
TwoFactorEnabled
LockoutEnabled
Instead of showing true / false (or 1 / 0), Superset displays them as small icons (stacked lines), making it difficult to read and interpret boolean data.
Screenshots/recordings
Superset version
4.1.3
Python version
3.9
Node version
16
Browser
Chrome
Additional context
No response
Checklist
- [ ] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [ ] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
Comment From: dosubot[bot]
This is a known UI limitation in Superset 4.1.3: boolean fields are rendered as icons (specifically, the FieldBinaryOutlined icon) in Explore and SQL Lab, rather than as true/false or 1/0 text values. This behavior is controlled by the frontend rendering logic and type inference, and is especially common with MySQL, where boolean fields are often stored as TINYINT(1) and may be mis-inferred by Superset's type detection. There is currently no configuration option or setting to change this rendering to text in Superset 4.1.3; changing it would require frontend code changes. Multiple users have found this confusing and have requested more readable alternatives, but as of now, it is not configurable or fixed in this version reference.
To reply, just mention @dosu.
How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other 
