Data Query WHERE Condition Non-init Field Value Without Single Quotes, Query Result Displays All Table Data

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 数据查询where条件非init字段值，未加单引号，查询结果显示表的所有数据

| username: xiaohetao

As shown in the figure above, the MPI field is not initialized. The SQL execution in the figure should report an error, but why does the query display all the data in the table?

Is this phenomenon a bug?

2
| username: 啦啦啦啦啦 | Original post link

Normal, it’s equivalent to performing an implicit conversion.

3
| username: caiyfc | Original post link

This phenomenon is implicit conversion. The following post can explain this phenomenon:

4
| username: 哈喽沃德 | Original post link

It’s not a bug, it’s an implicit conversion.

5
| username: xiaohetao | Original post link

Thank you, everyone, for answering my questions and clearing up my confusion. :+1:

6
| username: system | Original post link

This topic was automatically closed 1 minute after the last reply. No new replies are allowed.