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

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