upgrade-duckdb-extension

name	upgrade-duckdb-extension
description	Upgrade the system_stats extension to a new DuckDB release. Use when the user asks to upgrade DuckDB, bump the duckdb submodule, sync to a new DuckDB tag (e.g. v1.5.2), or update the duckdb / extension-ci-tools submodules together.

Upgrade system_stats to a new DuckDB release

Three submodules must move together. Two are pinned to matching release tags, one tracks main. Then build, run two test suites, and write a changelog entry.

Inputs

Before starting, confirm the target DuckDB version (e.g. v1.5.2). Everything else is derived from it.

Workflow

Track these as a checklist; do not skip ahead:

• 1. Pin duckdb submodule to tags/$TARGET
• 2. Pin extension-ci-tools submodule to $TARGET (same tag)
• 3. Build: CMAKE_BUILD_PARALLEL_LEVEL=10 make reldebug
• 4. Run test
  • Extension C++ unit test: ./build/reldebug/extension/system_stats/test/unittest/unittest_system_stats
  • SQL test: make test_reldebug (expands to ./build/reldebug/test/unittest "test/*")

Reference: historical upgrade commits

• 97359a4 — Upgrade duckdb v1.5.2. Minimal: 3 submodules + 1 CMake source line + CHANGELOG.