Skip to content

2.31.0.0-b168

2.31.0.0-b168: [docs] Correct YSQL UPDATE index key support (#32124)
@mguterl mguterl tagged this 16 Jun 01:44 
## Summary

- Update YSQL `UPDATE` semantics to remove the obsolete statement that
index-key and primary-key column updates are unsupported.
- Clarify that YSQL supports updating columns that are part of an index
key, including `PRIMARY KEY` columns, subject to applicable constraints.
- Apply the correction to stable, v2025.1, v2024.2, and v2.20 docs.
- Fix the sample query output row count from `(2 rows)` to `(3 rows)`.

## Validation

- Confirmed release notes document support for primary-key updates:
  - `docs/content/stable/releases/ybdb-releases/end-of-life/v2.3.md`
- Confirmed existing regression coverage for index-key and primary-key
updates:
-
`src/postgres/src/test/regress/sql/yb.orig.update_optimize_index_updates.sql`
- Confirmed source support via `YBCExecuteUpdateReplace` comment:
  - `src/postgres/src/include/executor/ybModifyTable.h`
- Ran `git diff --check`
Assets 2
Loading