# Changelog

## Baseline

- First survey — no prior run to compare against. CAI 69.1.

## Lenses

- Code Health 57.7
- Architecture 94.1
- Maturity 75.6
- Readiness 78.2
- Security 79.8
- Performance 91.4

## Changes since last survey

- 300 commits — 198 feature/other, 102 fixes

## By area

- integ-test/src — 99 commits
- core/src — 64 commits
- opensearch/src — 34 commits
- api/src — 17 commits
- .github/workflows — 16 commits
- (root) — 13 commits
- plugin/src — 10 commits
- ppl/src — 9 commits
- integ-test/build.gradle — 8 commits
- docs/user — 7 commits
- legacy/src — 3 commits
- async-query-core/src — 2 commits
- async-query/src — 2 commits
- release-notes/opensearch-sql.release-notes-3.7.0.0.md — 2 commits
- release-notes/opensearch-sql.release-notes-3.8.0.0.md — 2 commits
- sql/src — 2 commits
- common/src — 1 commit
- direct-query-core/src — 1 commit
- docs/dev — 1 commit
- doctest/build.gradle — 1 commit

## Notable commits

- fix: Add PPL bugfix skill for Claude Code (#5307)
- fix: Detect integral SUM overflow and fix BIGINT AVG (#5612)
- fix: Fix 500 from coalesce, mvappend, array and percentile_approx types on short, byte and float values (#5874)
- fix: Fix 500 from sort and stats on object, nested, geo_point and flat_object fields (#5858)
- fix: Fix 500s and empty results from binary fields in Calcite pushdowns (#5767)
- fix: Fix 500s from in, between, case and coalesce on object and nested fields (#5870)
- fix: Fix CalcitePPLAggregationIT on the analytics-engine route (parquet testSimpleCount0 + APPROX_COUNT_DISTINCT name) (#5525)
- fix: Fix ClassCastException in PPL multisearch on indexes with @timestamp alias field (#5577)
- fix: Fix IllegalStateException in UnifiedQueryPlanner.preserveCollation on composite-collation plans (#5650)
- fix: Fix O(cols^2) PPL result materialization on wide schemas (#5940)
- fix: Fix PPL search command ignoring wildcards and over-matching quoted values (#5682) (#5697)
- fix: Fix SQL IT test queries, assertions, and data for engine-agnostic compatibility (#5584)
- fix: Fix SemanticCheckException not thrown (#5239)
- fix: Fix UnsupportedOperationException merging an empty object with a populated sibling (#5791)
- fix: Fix analytics engine routing for SQL after V2 parser change (#5456)
- fix: Fix boolean coercion from numeric values for wildcard index queries (#5269) (#5293)
- fix: Fix code-coverage action (#5763)
- fix: Fix comma-separated sources with request-level time bounds (#5852)
- fix: Fix dedup 500 on cross-index object/scalar mapping conflict (#5685) (#5732)
- fix: Fix distribution build: pin analytics-api dep to 3.7.0-SNAPSHOT (#5455)
- …and 280 more

## Architecture

- 0 containers · 14 bounded contexts · 41 dependency edges (baseline)
