|A Prepared statement might have resulted in an incorrect result in a multi-node environment. For example, a database with two query nodes.
|Correlated subqueries from an encoded plan are now detected and marked. This ensures correct results are provided.
Cluster with two query nodes.
Create bucket shellTest.
Then on the first query node:
This should produce:
which is the correct result.
Now from the second query node:
This should produce the same result, however, it produces instead:
|For Gerrit Dashboard: MB-57251
|MB-57251 Proper detect and mark correlated subqueries from encoded plan
|MB-57251 Handle Subqueries separately