子查询有BUG 版本3.1.2

Viewed 63
3.0

子查询查出来的结果是一样的, where条件没有生效

SELECT
a.Id,
a.PatientName,
(SELECT dic.DiagnosisCode FROM op_opdiagnoses dic WHERE dic.OpRegisterId = a.Id ORDER BY dic.CreationTime DESC LIMIT 1) DiagnosisCode,
(SELECT di.DiagnosisName FROM op_opdiagnoses di WHERE di.OpRegisterId = a.Id ORDER BY di.CreationTime DESC LIMIT 1) DiagnosisName
FROM
op_opregisters a

9f760128d0890f1e13487404c1ac9f22.png
012a920692fca58236bca643de9ca18f.png

1 Answers

SELECT
a.Id,
a.PatientName,
(SELECT dic.DiagnosisCode FROM op_opdiagnoses dic WHERE dic.OpRegisterId = a.Id ORDER BY dic.CreationTime DESC LIMIT 1) DiagnosisCode,
(SELECT di.DiagnosisName FROM op_opdiagnoses di WHERE di.OpRegisterId = a.Id ORDER BY di.CreationTime DESC LIMIT 1) DiagnosisName
FROM
op_opregisters a
这个的结果是什么？

徐振超@SelectDB7966
Related Questions
fe启动报错 Text cannot be parsed to a Duration: 10
集群夯住，查询报错report error status: PStatus: timeout when waiting for send fragments rpc,
2 answers
3.0.8运行一段时间版本报错 ：Reach limit of connections. Total: 1024, User: 100, Current: 100，什么原因会导致这样，要改哪个配置？
2 answers
3.x版本webUI点击具体表，报unexpected exception
1 answers
Doris主键点查比Clickhouse慢一个数量级原因
1 answers
官网文档为什么一直无法下载？
1 answers