Skip to content

Validate partition expressions across all regions before ALTER #9454

Closed

Description

@killme2008

Follow-up to #8894 and the review of #9418.

Persisted partition bounds retain their original types when a column's type changes. A bound at 3000-01-01T00:00:00Z fits TIMESTAMP(3) but overflows TIMESTAMP(9), even if every stored row fits the new unit. The partition-filter coercion in #9418 returns an arithmetic overflow error during scan construction. Its regression test covers this path; it does not prevent ALTER from accepting incompatible partition bounds.

ALTER should validate partition-expression compatibility for all affected regions before changing any region. Validation only when each region applies ALTER can leave earlier regions modified when a later region rejects its bound.

Scope:

  • Validate persisted partition expressions against the proposed schema, including timestamp-unit widening and changes to nullable field columns referenced by partitions.
  • Reject incompatible changes before submitting ALTER to any region, without dropping partition predicates or converting overflowing bounds to NULL.
  • Cover a multi-region case where only a later region has an incompatible bound and assert that rejection leaves every region and the table schema unchanged.
  • Cover compatible changes and verify query results after ALTER.

The current regression test exercises scan construction directly. An end-to-end ALTER reproduction remains part of this follow-up.

Activity

  1. added a commit that references this issue on Oct 19, 2026
    1e29e8d
  2. added 4 commits that reference this issue on Oct 27, 2026
    0488225
    23d70ce
    9c62d55
    badceec
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions