Bug #113087 Insert row with boolean column not working as expected
Submitted: 15 Nov 2023 8:34 Modified: 15 Nov 2023 12:10
Reporter: Barathi. S Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:8.0.34 OS:MacOS
Assigned to: CPU Architecture:Any
Tags: boolean datatype, insert row error

[15 Nov 2023 8:34] Barathi. S 
Description:
Insert row in table with boolean column treats remaining columns as boolean

How to repeat:
1. Create a table with boolean column
2. Fetch the rows of the table
3. Copy/Add new row in the result
4. Following values after boolean column will be treated as boolean and will not be able to insert row

Suggested fix:
Only the particular column should be referred as boolean
[15 Nov 2023 8:36] Barathi. S 
Table created

Attachment: Screenshot 2023-11-15 at 1.58.21 PM.png (image/png, text), 259.28 KiB.
[15 Nov 2023 12:10] MySQL Verification Team 
Hello Barathi,

Thank you for the bug report.
Imho this is duplicate of Bug #93060, please see Bug #93060.

Regards,
Ashwini Patil