Editing booleans in the SQL table editor
I'm using 13.1.4 and think I'mseeing new behaviour thats confusing me a little. When I edit a table (this ones MySQL5) and double-click an empty boolean field checkbox. It now changes from [] to [-] then if I doubleclick it again it changes from [-] to [v] (tick). Pretty sure it used to have just two states [] and [v] what is this intermidate [-] state? how do booleans have three states?
Please sign in to leave a comment.
Hi.
The third state is NULL.
Regards,
Alexander.
So the empty checkbox [] is null and [-] is false? So it goes null -> double click -> false -> double click -> true - then back around to null if I double click again. The ORM at least dosn't really distinguish the first two states null==false.
Will it also attempt this if the column has a not null constraint?
Abit different: [ ] is false and [-] is NULL.
Not null columns have only 2 states.