Graph:
C -- A -- B
Solution with seed 0:
NESTED_LOOP_JOIN
---leftEmbeddingField: (none)
---rightEmbeddingField: b
---joinPredicates:
------a = b
---Outer:
------NESTED_LOOP_JOIN
---------leftEmbeddingField: c
---------rightEmbeddingField: (none)
---------joinPredicates:
------------c = a
---------Outer:
------------COLLSCAN
---------------ns = test.c
---------------filter = $and
---------------nodeId = 1
---------------fetched = 1
---------------sortedByDiskLoc = 0
---------------providedSorts = {baseSortPattern: {}, ignoredFields: []}
---------Inner:
------------COLLSCAN
---------------ns = test.a
---------------filter = $and
---------------nodeId = 2
---------------fetched = 1
---------------sortedByDiskLoc = 0
---------------providedSorts = {baseSortPattern: {}, ignoredFields: []}
---Inner:
------COLLSCAN
---------ns = test.b
---------filter = $and
---------nodeId = 4
---------fetched = 1
---------sortedByDiskLoc = 0
---------providedSorts = {baseSortPattern: {}, ignoredFields: []}

Solution with seed 4:
NESTED_LOOP_JOIN
---leftEmbeddingField: (none)
---rightEmbeddingField: c
---joinPredicates:
------a = c
---Outer:
------NESTED_LOOP_JOIN
---------leftEmbeddingField: b
---------rightEmbeddingField: (none)
---------joinPredicates:
------------b = a
---------Outer:
------------COLLSCAN
---------------ns = test.b
---------------filter = $and
---------------nodeId = 1
---------------fetched = 1
---------------sortedByDiskLoc = 0
---------------providedSorts = {baseSortPattern: {}, ignoredFields: []}
---------Inner:
------------COLLSCAN
---------------ns = test.a
---------------filter = $and
---------------nodeId = 2
---------------fetched = 1
---------------sortedByDiskLoc = 0
---------------providedSorts = {baseSortPattern: {}, ignoredFields: []}
---Inner:
------COLLSCAN
---------ns = test.c
---------filter = $and
---------nodeId = 4
---------fetched = 1
---------sortedByDiskLoc = 0
---------providedSorts = {baseSortPattern: {}, ignoredFields: []}

