A SQL plan is being created that indicates that the update to the sequence generator table row managing the value for the identity column is being executed without a DTM transaction. This allows serial ESP plans all updating the identity column to update the hbase rows outside of a DTM transaction. This can lead to duplicates.
I am testing a change to the SQL compiler generator to ensure we indicate this sequence generator update should be executed within a DTM transaction.
A SQL plan is being created that indicates that the update to the sequence generator table row managing the value for the identity column is being executed without a DTM transaction. This allows serial ESP plans all updating the identity column to update the hbase rows outside of a DTM transaction. This can lead to duplicates.
I am testing a change to the SQL compiler generator to ensure we indicate this sequence generator update should be executed within a DTM transaction.