taosdata
regrading to the start window of interval
Bug Description A clear and concise description of what the bug is.
To Reproduce Steps to reproduce the behavior:
- Go to '...'
- Type in '....'
- See error
Expected Behavior A clear and concise description of what you expected to happen.
Screenshots If applicable, add screenshots to help explain your problem.
Environment (please complete the following information):
- OS: [e.g. CentOS 7.0]
- Memory, CPU, current Disk Space
- TDengine Version [e.g. 1.6.1.7]
Additional Context Add any other context about the problem here.
查询语句1：
SELECT _WSTART, _WEND, count(*) AS total_count
FROM mp.clue
WHERE time_server >= '2024-02-28 00:00:00.000000000' AND time_server <= '2024-02-28 14:59:59.999999999'
INTERVAL(6h) FILL(NULL_F);
查询语句2：
SELECT _WSTART, _WEND, count(*) AS total_count
FROM mp.clue
WHERE time_server >= '2024-02-28 00:00:00.000000000' AND time_server <= '2024-02-28 14:59:59.999999999' AND clue_platform_id='402'
INTERVAL(6h) FILL(NULL_F);
问题： 查询语句2仅仅多了一个Where筛选条件，为什么会导致两条查询语句返回的时间不一致
I am also experiencing the same issue. When the interval is greater than 2 hours, this problem occurs.
The screenshot is as follows：
