# v0.42.0 — Documentation Truthfulness, Test Quality & Fuzz Automation

**Status: ✅ Released** | **Scope: Large**

> v0.42.0 added `repair_stream_table`, refreshed generated catalogs and stale
> documentation, improved E2E polling, and expanded differential tests and fuzz
> coverage.

---

## What shipped

The release paired documentation fixes with test and CI work so the published
guidance and automated checks matched the implementation.

---

## Repair stream table state and generate catalogs from code

The release implemented `pgtrickle.repair_stream_table(name)` and added an E2E
test for the restore runbook. It replaced regex-based catalog generation with
Rust-aware extraction, regenerated both catalogs, and added a CI drift check.

---

## SQL reference freshness and stale-term audit

The release added missing `create_stream_table` parameters, removed deprecated
GUCs from active tuning guidance, updated architecture paths, and added
`just docs-lint` and generated-reference drift checks.

---

## Replace fixed sleeps with state-polling helpers

The release introduced `wait_for_refresh_history`, `wait_for_cdc_mode`,
`wait_for_scheduler_tick`, and `wait_for_job_status` helpers. It replaced the
highest-impact fixed sleeps in WAL CDC, scheduler, cascade, and bgworker tests.

---

## Aggregate correctness property tests and fuzz CI

The release added differential E2E tests for `SUM(CASE ...)`, switched CASE
detection to the parsed AST, and added FULL JOIN aggregate property tests.
Fuzz targets run in CI with a scheduled smoke job and corpus replay on PRs.

---

## Also in v0.42.0

- Parameterized WAL decoder SQL
- Current keyless-design comments in place of stale EC-06 notes
- A keyless multiset property test

---

## Scope

v0.42.0 combined documentation accuracy work with test improvements that had
been planned across two releases.

> **Historical source:** [Assessment 9 at the v0.106.0 review](https://github.com/trickle-labs/pg-trickle/blob/5ed05167/plans/PLAN_OVERALL_ASSESSMENT_9.md)
> findings FEAT-01, DOC-01–08, CQ-03, CQ-04, TEST-01–02, TEST-05–06, TEST-09,
> CI-05–07, OPS-05, COR-04, COR-05, COR-07, COR-08.

---

*Previous: [v0.41.0 — DVM Correctness: Structural Cache Keys, Placeholder Safety & WAL Transition Guards](v0.41.0.md)*
*Next: [v0.43.0 — Performance Tunability, Diagnostics & Refresh Intelligence](v0.43.0.md)*