Skip to content
New issue

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

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

Already on GitHub? # to your account

Fix cagg_migrate_to_time_bucket during update #7763

Open
wants to merge 1 commit into
base: main
Choose a base branch
from

Conversation

fabriziomello
Copy link
Contributor

@fabriziomello fabriziomello commented Feb 20, 2025

In #6837 we added a migration for CAggs using time_bucket_ng to use the new version of time_bucket that support orign and/or offset.

We made a mistake because we place the code to migrate existing CAggs using time_bucket_ng to time_bucket in the update script but this code should be placed instead on post-update.sql script where we can call functions from the new extension version loaded.

Disable-check: force-changelog-file

Copy link

codecov bot commented Feb 20, 2025

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 81.92%. Comparing base (59f50f2) to head (b18e3ca).
Report is 789 commits behind head on main.

Additional details and impacted files
@@            Coverage Diff             @@
##             main    #7763      +/-   ##
==========================================
+ Coverage   80.06%   81.92%   +1.86%     
==========================================
  Files         190      247      +57     
  Lines       37181    45430    +8249     
  Branches     9450    11355    +1905     
==========================================
+ Hits        29770    37220    +7450     
- Misses       2997     3741     +744     
- Partials     4414     4469      +55     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

@fabriziomello fabriziomello force-pushed the fix_cagg_migrate_to_time_bucket_during_update branch from 58ce092 to 860cb3f Compare February 21, 2025 14:27
Copy link
Contributor

@erimatnor erimatnor left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM, I just left some questions for things I am not sure about.

In timescale#6837 we added a migration for CAggs using `time_bucket_ng` to use
the new version of `time_bucket` that support orign and/or offset.

We made a mistake because we place the code to migrate existing CAggs
using `time_bucket_ng` to `time_bucket` in the update script but this
code should be placed instead on post-update.sql script where we can
call functions from the new extension version loaded.
@fabriziomello fabriziomello force-pushed the fix_cagg_migrate_to_time_bucket_during_update branch from 860cb3f to b18e3ca Compare February 21, 2025 17:16
# for free to join this conversation on GitHub. Already have an account? # to comment
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants