distal-attribute
distal-attribute
distal-attribute
distal-attribute

Can't duplicate rows when table schema contains bit columns

th4 posted 3 years ago in General
Hello, since I updated to beta version duplicating rows (via ctrl+ins) that involve columns with bit data result in an SQL error. (eg: /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 */)

It worked ok in version 6 stable.

Bye and thanks again for the awesome program~
ansgar posted 3 years ago
There was never a working BIT support in HeidiSQL yet. But I'm now working on that, only bitmask calculation is driving me nuts. So I have committed the code now in r3823 which allows you to enter bit values like '01010111' into a grid cell, while the displayed values from the server sometimes are wrong.
ansgar posted 3 years ago
For further discussion see issue #766
th4 posted 3 years ago
Wow looks like it's working now, i can even see values from server correctly! Thanks!!happy
ansgar posted 3 years ago
Well most values seem right, but I have seen wrong ones too, so be carefull - this is not yet well tested.
ansgar posted 3 years ago
By the way, you can see the server values compared to what HeidiSQL reads when firing:

SELECT bin(bitcolumn), bitcolumn FROM mytable

th4 posted 3 years ago
Oh ok i'll double check values when it's important stuff then!

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