Github user sandhyasun commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1586#discussion_r192186819
--- Diff: core/sql/generator/GenPreCode.cpp ---
@@ -4520,7 +4520,9 @@ RelExpr * GenericUpdate::preCodeGen(Generator *
generator,
{
oltOptInfo().setOltOpt(FALSE);
generator->oltOptInfo()->setOltOpt(FALSE);
- generator->setAqrEnabled(FALSE);
+ //enabling AQR to take care of the lock conflict error 8558 that
+ // should be retried.
+ // generator->setAqrEnabled(FALSE);
--- End diff --
The while insert would get retried again. The insert/select operation of
lob columns treats the input to the target table as a char string and does it
in chunks. If there is lock clash, the transaction gets aborted and we retry.
---
