7

Let's say I have a table 'day_attribute_type'

id bigint(20) AI PK 
code varchar(255) 
persist_date bigint(20) 
update_date bigint(20) 
active bit(1) 
max int(11) 
min int(11) 
name varchar(255)

If I would add a new row into the Result Grid and press the Apply button, I would get the following query:

INSERT INTO `tl2`.`day_attribute_type` (`persist_date`, `update_date`, `active`, `max`, `min`, `name`) 
VALUES ('1', '2', b'1', b'12', b'12', b'text');

It looks like Workbench puts 'b' not only before the bit field, but also before some other fields. It's really annoying to post-edit the query and remove their buggy things.

MySQL WorkBench 8.0.16 x64, Windows 10 MYSQL Community Server 8.8.12

I've updated MySQL Workbench for a year and this nasty bug continued to appear... I've even reinstalled my Windows.

It looks like nobody is going to fix it. It is mentioned here. Please, can somebody try to reproduce this bug on Linux/Max and confirm either you have it or not.

Steve Chambers
  • 37,270
  • 24
  • 156
  • 208
Iaroslav Baranov
  • 1,100
  • 9
  • 17

1 Answers1

4

Tried this out myself (MySQL Workbench 8.0.19 on Windows) and saw the same results - agree it's pretty annoying.

As the issue hasn't been fixed in 4+ years I'd be tempted to use another MySQL GUI client for this purpose such as HeidiSQL, ToadSQL or DBeaver. Credit to JW-Munich for suggesting the last one in the comments.

Steve Chambers
  • 37,270
  • 24
  • 156
  • 208
  • every gui has its bugs and problems, so report the errors and it will be fixed if enough people cry out.(hopefully) – nbk Jun 25 '20 at 14:58
  • Would usually agree, although odd that this one hasn't been fixed yet when verified as a bug over 4 years ago and with and 4 duplicate bugs raised since. Still worth a click on the "Affects me" button on the [bug page](https://bugs.mysql.com/bug.php?id=79604). – Steve Chambers Jun 25 '20 at 15:29
  • 1
    that is because not enough people get to post a bug. And some never gone to be fixed, because they don't think that is a bug. i clicked affects me, lets see if we can get more people – nbk Jun 25 '20 at 15:39
  • 2
    thanks for tips for the other clients. I actually ended up going for [DBeaver](https://dbeaver.io/). It's multi-platform and seems to work pretty well. – JW-Munich Jul 01 '20 at 11:41
  • 7 years and still not fixed, I'm definitely moving to another client. – Houssem Nasri Jan 26 '23 at 01:57