the specific query leads to a windows TDengine crash
Open
@yu285 is already working on this.
Since Jun 26, 2023.
bug
- Dominant language
- C
- Stars
- 25.1k
- Forks
- 5k
- Avg merge
- 4d 59m
- Merged PRs (30d)
- 7
Description
Bug Description
To Reproduce
类似这样的查询
SELECT
t0.ts as ts,
t0.`val` AS `M0`,
t1.`val` AS `M1`
FROM
(
SELECT
_wstart AS `ts`,
AVG(`lval`) AS `val`
FROM
`32f150dc50be4bcb869ca1532546481a_data`.`9`
WHERE
ts >= '1995-04-24 21:49:51'
AND ts <= '2023-06-26 15:21:35' INTERVAL(99999y) FILL(NULL)
) t0,
(
SELECT
_wstart AS `ts`,
MAX(`lval`) AS `val`
FROM
`32f150dc50be4bcb869ca1532546481a_data`.`10`
WHERE
ts >= '1995-04-24 21:49:51'
AND ts <= '2023-06-26 15:21:35' INTERVAL(99999y) FILL(NULL)
) t1
WHERE
t0.ts = t1.ts
AND (
t0.val IS NOT NULL
OR t1.val IS NOT NULL
)
ORDER BY
t0.`ts` DESC
LIMIT
1000
Expected Behavior
正常查询
Screenshots
If applicable, add screenshots to help explain your problem.
Environment (please complete the following information):
OS Name: Windows
OS Version: 10.0.19045
OS Platform: Windows
RID: win10-x64
TDengine Version 3.0.5
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.