Bug #114088 使用union all函數查詢bit型字段的結果錯誤。

• Submitted: 22 Feb 2024 6:24
• Modified: 29 Feb 2024 12:29
• Reporter: hao xu
• Status: Can't repeat
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 8.0.34
• OS: Windows (Microsoft Windows 10 Home China)
• CPU Architecture: Any
• Tags: WBBugReporter

[22 Feb 2024 6:24] hao xu

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\admin\AppData\Roaming\MySQL\Workbench\log\wb.log]

How to repeat:
1、新建表Table:字段（id,is_effective），類型分別為varchar(32)，bit(1)；
2、插入數據（001，0）和（002，1）；
3、使用union all函數查詢，如：
select * from Table where is_effective = 0
union all
select * from Table where is_effective = 1;

[22 Feb 2024 13:11] MySQL Verification Team

Hello!

Thank you for the bug report.
Could you please provide the result set after selecting union all?

Regards,
Ashwini Patil

[28 Feb 2024 15:05] hao xu

Please see the screenshot！

[29 Feb 2024 12:29] MySQL Verification Team

Hello!

Thank you for the details.
I tried to reproduce your issue on windows 11 with workbench 8.0.36 but I am not seeing any issues at my end. 
8.0.34 is an old version. Please try with latest version. Thanks.

Regards,
Ashwini Patil

[29 Feb 2024 12:30] MySQL Verification Team

8.0.36 test results

Attachment: 114088_test_results.png (image/png, text), 51.93 KiB.