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?

3 comments
Comment actions Permalink

Hi.

The third state is NULL.

Regards,
Alexander.

0
Comment actions Permalink

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?

0
Comment actions Permalink

Abit different: [ ] is false and [-] is NULL.

Not null columns have only 2 states.

0

Please sign in to leave a comment.