TimescaleDB 2.29.2

2.29.2

2.29.2 (2026-08-18)

Fixed 6
  • Fix user-defined functions named `time_bucket` causing SQLSTATE `XX000`
  • Fix `time_bucket_gapfill()` with window aggregates over constants
  • Repair mismatched dimensional `CHECK` constraints
  • Fix compressed `SkipScan` dropping uncompressed rows when sort keys do not match distinct keys
  • Do not attach `SkipScan` to mismatched `IndexScan` paths under `MergeAppend`
  • Fix wrong results for `IS NULL` predicates with min/max sparse-index pushdown

From TimescaleDB

This release contains bug fixes since the 2.29.1 release. We recommend that you upgrade at the next available opportunity.

Bugfixes

  • #10189 Fix user-defined functions named time_bucket causing SQLSTATE XX000
  • #10363 Fix time_bucket_gapfill() with window aggregates over constants
  • #10416 Repair mismatched dimensional CHECK constraints
  • #10423 Fix compressed SkipScan dropping uncompressed rows when sort keys do not match distinct keys
  • #10430 Do not attach SkipScan to mismatched IndexScan paths under MergeAppend
  • #9921 Fix wrong results for IS NULL predicates with min/max sparse-index pushdown

Thanks

  • @borisborelly for reporting incorrect results with COUNT(DISTINCT) due to SkipScan dropping uncompressed rows.
View original

Upgraded? How did it go?

Discussion