Default date ordering changed with v1.3.24
- Dominant language
- Rust
- Stars
- 20.8k
- Forks
- 2.1k
- Avg merge
- 1d 2h
- Merged PRs (30d)
- 181
Description
**Describe the bug**
Version 1.3.24 changed the default ordering behavior on date queries that have multiple granularities. Previously, querying, say, day and value would order by the value timestamp. With this change, it orders by the day.
https://github.com/cube-js/cube/compare/v1.3.23...v1.3.24
**To Reproduce**
Create a cube that has a date field. Query it with GraphQL like so:
```
query Foo {
cube {
intradayPerformance {
observation_date {
value
day
}
}
}
}
```
With v1.3.23, the results will be ordered ascending by value. With v1.3.24, the results will be ordered by the day. (If you look at the generated SQL, you can see both columns in the select but the order by index changes from the timestamp to the day.)
**Expected behavior**
I expect the v1.3.23 behavior where the order is on the finest date granularity.
**Screenshots**
v1.3.23
v1.3.24
**Minimally reproducible Cube Schema**
N/A
**Version:**
v1.3.24 thru v.1.3.47
**Additional context**
Nothing.
Contributor guide
Assessment
This issue has not been assessed yet.