| 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 13:15]
MySQL Verification Team
Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=93060.
Description: 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"