Can't duplicate rows when table schema contains bit columns
| User, date | Message |
|---|---|
|
Written by th4
2 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
2 years ago 3949 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
2 years ago 3949 posts since Fri, 07 Apr 06 |
For further discussion see issue #766 |
|
Written by th4
2 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!!
|
|
Written by ansgar
2 years ago 3949 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
2 years ago 3949 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
2 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. |