Ansicht
Dokumentation

SELECT, buffered projection views: records missing
Tip-No.: 2606 ( INFO2606 )

Short text

SELECT, buffered projection views: records missing
Tip-No.: 2606

Symptom

SELECT with WHERE condition does not return any (or not all the expected
records for 100% buffered projection views. If the view is not
buffered, the selection runs correctly.

Cause

Error in dbrsql.c:bind_view_list(). In this function, the bind list
for the WHERE condition for the original table is set up. Error:
the WA offsets of the view, and not those of the original, are used.
Consequence: reading the DB workds, as the offset is ignored.
Reading in the buffer fails; the subsequent selection uses the
specified displacements.

Solution

Do not hold the original table in the buffer
or wait for corr. B11K007654.
No longer occurs in update levels higher than 1.1H.