-
Notifications
You must be signed in to change notification settings - Fork 1.9k
Open
@davajm
Description
Describe the bug
A simple rolling window sum is giving us different results depending on if Tesseract is enabled or not.
To Reproduce
- Define following model in Cube
cubes: - name: test_cube sql: | SELECT TIMESTAMP '2025-10-07 10:00:00' AS created_at, 1 AS val UNION ALL SELECT TIMESTAMP '2025-10-08 10:00:00' AS created_at, 2 AS val dimensions: - name: created_at sql: created_at type: time measures: - name: val type: sum sql: val rolling_window: trailing: unbounded
- Fetch measurement for whatever date range as long as it excludes one of the timestamps. Example filtering on
2025年10月08日
{
"measures": [
"test_cube.val"
],
"timeDimensions": [
{
"dimension": "test_cube.created_at",
"dateRange": [
"2025-10-08",
"2025-10-08"
]
}
],
"filters": []
}
- Execute above with
CUBEJS_TESSERACT_SQL_PLANNERset tofalseand then when set totrue - Note that it returns 3 when Tesseract is disabled, but 2 when enabled.
Expected behavior
I would expect them to be the same. Personally, the behavior when Tesseract is disabled looks more correct and stops us from being able to enable it right now.
Version:
1.3.78
Metadata
Metadata
Assignees
Labels
No labels