【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】5.7.25-TiDB-v6.1.5
【复现路径】两表联查出的问题
【遇到的问题:问题现象及影响】mysql上查的结果是3条,tidb上查询结果是42条
【资源配置】进入到 TiDB Dashboard -集群信息 (Cluster Info) -主机(Hosts) 截图此页面
【附件:截图/日志/监控】
tidb的查询:
sql如下:
SELECT
t1.*,
t2.tag_status
FROM
t_new_inspect_item_config t1
LEFT JOIN t_new_inspect_config t2 ON t1.inspect_id = t2.id
AND t1.STATUS = 1
AND t1.is_deleted = 0
AND t2.STATUS = 1
AND t2.is_deleted = 0
WHERE
t1.tenant_id = ‘730000’
AND t1.inspect_id = ‘1372816766597782118’;
select * from t_new_inspect_config t where t.tenant_id =‘730000’ and t.id =‘1372816766597782118’;
select * from t_new_inspect_item_config where tenant_id =‘730000’ and inspect_id =‘1372816766597782118’;
查询结果如下:
mysql上同样的sql: