Date: 2010-05-19 11:33:27 +0200
From: zeuner <>
To: SQL devs <>
Version: 2.38.1 (Jun2010)
CC: @njnes

Last updated: 2010-08-20 14:04:08 +0200

Comment 14046

Date: 2010-05-19 11:33:27 +0200
From: zeuner <>

Created attachment 5
SQL code to show the issue

When an update statement changes a row with the same OID as a previous update statement in the same transaction, only the first update is stored (see attached SQL test). This is because the subsequent updates are only inserted uBAT, but not replaced into it. The attached patch fixes this, and seems to be stable for me so far.

This bug report is based on a mailing list question where the same issue was observed on a Feb2010 branch build. I did not verify this, but it might well be that the same patch could also help on that branch.

Attached file: multiple-updates-in-transaction.sql (application/octet-stream, 469 bytes)
Description: SQL code to show the issue

Comment 14047

Date: 2010-05-19 11:34:26 +0200
From: zeuner <>

Created attachment 6
possible fix

Attached file: override-previous-updates.diff (text/plain, 305 bytes)
Description: possible fix

Comment 14135

Date: 2010-06-21 20:04:04 +0200
From: @njnes

Changeset 86afee7de2ff made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=86afee7de2ff

Changeset description:

add test for
Bugzilla Bug #2543   	multiple update statements in one transaction lose updates

Comment 14136

Date: 2010-06-21 20:05:06 +0200
From: @njnes

added test to src/test/BugTracker-2010/Tests/multiple-updates-in-transaction.Bug-2543.sql

applied fix. Indeed we need to keep updated values.

Comment 14137

Date: 2010-06-21 20:26:55 +0200
From: @njnes

Changeset 063cbe9c5b78 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=063cbe9c5b78

Changeset description:

add test for
Bugzilla Bug #2543   	multiple update statements in one transaction lose updates
(transplanted from 86afee7de2ff4755b3679d935a99d13023c7e5dc)

Comment 14737

Date: 2010-08-19 17:47:02 +0200
From: @sjoerdmullender

This was released in the Jun2010-SP1 release.