[PHOENIX-6963] Check if LAST_DDL_TIMESTAMP is set for tables and indexes created before PHOENIX-6186

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 5.2.0
• Component/s: core
• Assignee: Palash Chauhan
• Reporter: Rushabh Shah
• Created: 25/May/23 04:42
• Updated: 31/May/23 23:06
• Resolved: 31/May/23 22:11

Description

The whole design of PHOENIX-6883 is dependent on LAST_DDL_TIMESTAMP when we create/update table/view/index.
LAST_DDL_TIMESTAMP was introduced in PHOENIX-6186. What happens to table/view that is created before PHOENIX-6186? In the upgrade path, do we update LAST_DDL_TIMESTAMP for tables that are already created?
Also we added LAST_DDL_TIMESTAMP to an index in PHOENIX-6932. We will need to handle the upgrade path where we have to add LAST_DDL_TIMESTAMP to an existing index.

Issue Links

• links to: GitHub Pull Request #1612