There is problem with default values of BIT columns.
If you set default value to 1, after saving changes HeidiSQL shows empty default value.
In phpMyAdmin the default value is displayed correctly.
MySQL default value of bit column
I forgot to add the version I was using, which was r4943
I just tested with 9.2 stable and it's broken as well: create tab shows a default value of b'' for bit columns and table editing does not work for those columns (sql error 1067: invalid default value for 'column name').
Exporting works fine tho, and produces the expected sql code with b'0' or b'1' as default values.
I just tested with 9.2 stable and it's broken as well: create tab shows a default value of b'' for bit columns and table editing does not work for those columns (sql error 1067: invalid default value for 'column name').
Exporting works fine tho, and produces the expected sql code with b'0' or b'1' as default values.
Code modification/commit
from ansgarbecker,
9 years ago,
revision 4961
Fix wrong detection of BIT default values. See http://www.heidisql.com/forum.php?t=17862
Please login to leave a reply, or register at first.