Bug #113455 bigint数据类型bug 8.0版本

• Submitted: 19 Dec 2023 7:31
• Modified: 19 Dec 2023 12:43
• Reporter: kaixing yang
• Status: Can't repeat
• Category: MySQL Server: Data Types
• Severity: S4 (Feature request)
• Version: 8.0
• OS: Any
• CPU Architecture: Any
• Tags: 数据类型

[19 Dec 2023 7:31] kaixing yang

Description:
bigint类型输入where字段类型能把值为0的匹配出来

How to repeat:
create table test（
id int primary key,
pro bigint not null
）;

插入几条pro值为0的数据

select * from test where pro='abc';
或
select * from test where pro='汉字';

Suggested fix:
where字符串不会有结果

[19 Dec 2023 12:43] MySQL Verification Team

Hi Mr. ji,

Thank you for your bug report.

However, we can not repeat it.

You only have CREATE TABLE statement and no inserted rows.

Hence, we get no result, what so ever.

Can't repeat.