RisingWave Community - Why is the JDBC sink not executing updates and how to handle duplication on primary key in the sink?

The JDBC sink was not executing updates due to a duplicate key value violation error.
To handle duplication on the primary key in the sink, you can use the 'upsert' type in the sink configuration.
An improvement was made in version 1.0.0 of the sink, which better handles duplication on the primary key.
By upgrading to version 1.0.0 of the sink, the issue with updates not being executed and the duplicate key value violation error can be resolved.