Fix encryption status of sequences

Description

ALTER TABLE SET ACCESS METHOD doesn’t recreate sequences, which means their encryption status doesn’t change when a table is converted to/from tde_heap.

We need to add special handling around this:

  • handlers around CREATE SEQUENCE / ALTER SEQUENCE to associate a sequences encryption status with the encryption status of the owning table, if there’s an owner

  • modify the post event handler code to automatically call ALTER SEQUENCE for all sequences associated with the table, if needed - only if this is possible to implement

How to document

None

How to test

None

Attachments

1

Activity

Show:

shahidullah.khan March 10, 2025 at 12:26 PM

This issue is fixed now.

Done

Details

Assignee

Reporter

Components

Sprint

Fix versions

Priority

Smart Checklist

Created February 19, 2025 at 10:01 PM
Updated March 13, 2025 at 11:23 AM
Resolved March 10, 2025 at 12:28 PM