Streams: Joins on Views for Append-only Streams No Longer Produce Unexpected Results

Attention

This behavior change is in the 2023_01 bundle.

For the current status of the bundle, refer to Bundle History.

When querying APPEND_ONLY streams on views that use joins, results are now consistent between the left and right side join contents:

Previously:

Append-only stream queries over a view that used joins could return results that were inconsistent with the expectations of an append-only stream. In addition, they possibly included updates that have happened since the stream offset.

Currently:

Append-only stream queries return inserts that have occurred on either join input, joined with the current values of the tables at the stream offset.

Ref: 920