Cannot change a boolean default value in DB Manager to 0 unless you use 'false'

======== TEMPLATE BUG FORM ========

Wappler Version : 3.7.3
Operating System : Mac
Server Model: NodeJS
Database Type: MySql8
Hosting Type: AWS/Docker.

Expected behavior

What do you think should happen?

I wouldn’t necessarily call this a bug, but perhaps a UX improvement. When you view the default value of a boolean in the DB Manager it displays as 0 or 1. Intuitively if I want to change the value from 1 to 0, then I use 0 and update. It then just returns back to 1 and fails.

If however I type ‘false’ then it does indeed change in the DB Manager to 0.

This can no doubt be improved a little.

Community Page
Last updated: