SELECT FOR UPDATE with SubQuery (and "Write Consistency")

Just a quick post to provide a reference to a "bug" aka "expected behaviour if it is in the specification" that Jonathan Lewis has written about.

.

.

.