Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

regrading to the start window of interval #24918

Open
heyingjiee opened this issue Feb 28, 2024 · 0 comments
Open

regrading to the start window of interval #24918

heyingjiee opened this issue Feb 28, 2024 · 0 comments
Assignees
Labels
help wanted Extra attention is needed

Comments

@heyingjiee
Copy link

Bug Description
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

  1. Go to '...'
  2. Type in '....'
  3. 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);
image

查询语句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);
image

问题:
查询语句2仅仅多了一个Where筛选条件,为什么会导致两条查询语句返回的时间不一致

@heyingjiee heyingjiee added the bug Something isn't working label Feb 28, 2024
@yu285 yu285 added help wanted Extra attention is needed and removed bug Something isn't working labels Mar 4, 2024
@yu285 yu285 changed the title 时间窗口起始时间 regrading to the start window of interval Mar 6, 2024
@yu285 yu285 self-assigned this Mar 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

2 participants