yugabyte / tpcc

Repo to run TPCC benchmarks against YugabyteDB
Other
24 stars 21 forks source link

Use CTEs in the updatestock procedures #125

Open andrei-mart opened 2 years ago

andrei-mart commented 2 years ago

The feature allowing to batch single line updates in stored procedures was removed due to a correctness issue. That significantly impacted the NewOrder operation where this feature was used. We still can take advantage of batching: there is no correctness issue if single line updates are inside CTEs. Hence we should wrap the update statements into CTEs.