IoTDB doesn't distinguish between zero and null values in sum aggregation
- Dominant language
- Java
- Stars
- 6.4k
- Forks
- 1.2k
- Avg merge
- 1d 23h
- Merged PRs (30d)
- 115
Description
In IoTDB, the aggregate result of sum is like:

You can see that both a 0 value and a null value result in 0, without distinction.
But in **MySQL**, the aggregate result of sum is like:

I wonder if IoTDB can similarly distinguish between zero values and null values in the aggregate result of sum
Contributor guide
Research direction
Start by reproducing the sum aggregation behavior described in the issue and compare results for zero and null values with MySQL's behavior. Trace IoTDB's sum aggregation implementation and its existing tests; done means zero and null produce distinguishable aggregate results consistent with the intended semantics.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100