Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: tidb 同一条sql语句，where条件不一样，查出的结果一样
|
username: leoones
[Overview] Scenario + Problem Overview
The same SQL statement with different WHERE conditions yields the same result.
The SQL is as follows:
SELECT /*+ SQL_NO_CACHE */
id,
seller_id,
is_finished,
gmt_create,
gmt_modified
FROM
temp_order_trace
WHERE
is_finished = 0
AND seller_id = 'AZPSNNS54BFCZ';
SELECT /*+ SQL_NO_CACHE */
id,
seller_id,
is_finished,
gmt_create,
gmt_modified
FROM
temp_order_trace
WHERE
is_finished = 2
AND seller_id = 'AZPSNNS54BFCZ';
[Problem] Current Issue Encountered
The results are as follows:
[Business Impact]
Affects business, data query inconsistency.
[TiDB Version]
V5.4.0
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: