Bug #94734 Inserting data in a table with at least 1 BIT(1) column generates faulty sql
Submitted: 21 Mar 2019 11:39 Modified: 21 Mar 2019 13:15
Reporter: Jochem Stout Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.15 OS:MacOS (10.14.3 (Mojave))
Assigned to: CPU Architecture:x86
Tags: bit, generated-sql, insert, mysqlworkbench

[21 Mar 2019 11:39] Jochem Stout
When I click "Select Rows - Limit 1000" and insert a new row in a table with at least 1 BIT(1) column, the generated SQL is faulty. It randomly adds a "b" in front of values of other columns.

For example, this generated SQL:

INSERT INTO `my_schema`.`my_table` (`col1`, `col1`, `col3`, `col4`, `col5`) VALUES ('test', 'test', b'1', b'EN', b'DD');

While only "col3" is of type BIT(1).

Schema character set: utf8mb4
Collation: utf8mb4_0900_ai_ci

How to repeat:
- Forward engineer a schema with the modelling tool
- Right click a table in the SCHEMAS tab. This table must have at least 1 column of type BIT(1)
- Click "Select Rows - Limit 1000"
- Insert data on a new row
- Click "apply"
[21 Mar 2019 13:15] MySQL Verification Team
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=93060.