Added ALTER UPDATE/DELETE IN PARTITION Syntax

Why it matters

This feature allows users to perform update and delete operations more efficiently by targeting specific partitions in a table, reducing the amount of data scanned and improving operation performance when modifying partitioned data.

How to use it

Use the new syntax by adding IN PARTITION 'partition_id' to your ALTER UPDATE or ALTER DELETE statement. For example:

ALTER TABLE table_name UPDATE column = value WHERE condition IN PARTITION 'partition_id';

ALTER TABLE table_name DELETE WHERE condition IN PARTITION 'partition_id';