Mysql Boolean datatype column when value is False.

[agaheu]

Hi,

Boolean columns behaving in a way that I can't understand when using mysql datasource, details:

A boolean column ("Is Active"):

and "Formula" column which has a expression: "return $("Is Active"); "

For True and False values different results occour. When the boolean column is True the expression returns "1" as expected but when it's False it returns nothing:

When I change the expression to "return typeof $("Is Active");" in order to understand the problem, the result is :

Is it some kind of bug or am i missing something?

[mjashanks]

Hey @agaheu - thanks for this - seems like a bug. Just to clarify - the value stored in your DB is definitely false / 0? Or is it null?

I'll look into it :)

[agaheu]

It is 0