MySQL Bugs: #97774: Editing data in the results grid generates invalid SQL

Bug #97774	Editing data in the results grid generates invalid SQL
Submitted:	25 Nov 2019 19:15	Modified:	24 Nov 2021 19:58
Reporter:	Sean O'Connor	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	8.0.18	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
After selecting results from a table.  When you are inserting a new row via editing in the grid, the editor generates invalid sql after hitting apply.

I have a table with several bit columns.  I entered b'0' for instance.
When the SQL is geneated, all the columns have a b in front of them.  So even varchars have a b.  For instance:  b'Some value'.  This of course causes problems when it's trying to treat all columns as bits.

I had to revert back to the 6.3.10 version. 

How to repeat:
See above.

Suggested fix:
Don't put a b infront of columns that aren't bits in the generated SQL.

Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=93060.

HI,
You have marked this as a duplicate of another and that one a duplicate of this one.  

I have been waiting over two years now for this to be fixed.  It's VERY time consuming to have to edit the sql on every single row when you are inserting.  CAn you please address this issue?  I keep installing new versions and it never gets fixed.  I think it's fell through the cracks as it's an important bug and it's been two years.  Still a bug in 8.0.27.  Thank You.

Hello,

Thank you for your feedback.
We fully understand your concern, but please note that we don't prioritize bug fixing but it is done by development.
I'll convey your concern to the WB development team. Thank you once again!

Regards,
Ashwini Patil

Any update on that? It's a degradation that should have already been resolved