Bug #104772 使用where查询列数据不带运算条件返回的结果为非空非中文数据
Submitted: 31 Aug 2021 2:50 Modified: 31 Aug 2021 13:10
Reporter: Guard GUAN Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Operator Severity:S3 (Non-critical)
Version: OS:Windows
Assigned to: CPU Architecture:x86

[31 Aug 2021 2:50] Guard GUAN 
Description:
WHERE od.user_name AND UI.phone IS NOT NULL
查询结果为非空非中文数据
正确查询方式
WHERE (od.user_name AND UI.phone) IS NOT NULL
返回数据正常

How to repeat:
过滤数据没有规律

Suggested fix:
WHERE od.user_name
直接报错，非法查询条件
[31 Aug 2021 13:10] MySQL Verification Team 
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php 

If you can provide more information, feel free to add it to this bug.

Thank you for your interest in MySQL.