Bug: default value incorrectly shown as b'' for actual values of b'0' and b'1'

eos's profile image eos posted 9 years ago in General Permalink
Applies to type of BIT(1). This is used extensively by grails to represent booleans.

When you select a table in heidiSQL, it shows the columns listed, including "Default" values. It shows these always as "" when they should be 0 or 1.

If you look at the "CREATE code", it shows:

`my_column` BIT(1) NOT NULL DEFAULT b'',

If you then do a pure sql:

show full columns from mytable

It shows: b'1' or b'0' correctly as the default.



Please login to leave a reply, or register at first.