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

Can't duplicate rows when table schema contains bit columns

User, date Message
Written by th4
3 years ago
Category: General
17 posts since Mon, 11 Oct 10
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~
Written by ansgar
3 years ago
4785 posts since Fri, 07 Apr 06
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.
Written by ansgar
3 years ago
4785 posts since Fri, 07 Apr 06
For further discussion see issue #766
Written by th4
3 years ago
17 posts since Mon, 11 Oct 10
Wow looks like it's working now, i can even see values from server correctly! Thanks!!happy
Written by ansgar
3 years ago
4785 posts since Fri, 07 Apr 06
Well most values seem right, but I have seen wrong ones too, so be carefull - this is not yet well tested.
Written by ansgar
3 years ago
4785 posts since Fri, 07 Apr 06
By the way, you can see the server values compared to what HeidiSQL reads when firing:

SELECT bin(bitcolumn), bitcolumn FROM mytable

Written by th4
3 years ago
17 posts since Mon, 11 Oct 10
Oh ok i'll double check values when it's important stuff then!
 

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