modules/sql-engine/src/test/resources/mapping/table_identity_single.test

N0
SELECT * FROM CT_n1, NT_n1
---
Fragment#2 root
  distribution: single
  executionNodes: [N0]
  exchangeSourceNodes: {4=[N1]}
  colocationGroup[-1]: {nodes=[N0], sourceIds=[-1, 4], assignments={}, partitionsWithConsistencyTokens={N0=[]}}
  colocationGroup[4]: {nodes=[N0], sourceIds=[-1, 4], assignments={}, partitionsWithConsistencyTokens={N0=[]}}
  tree: 
    Receiver
        fieldNames: [ID0, C10, C20, ID, C1, C2]
        sourceFragmentId: 4
        est: (rows=1)

Fragment#4
  distribution: single
  executionNodes: [N1]
  targetNodes: [N0]
  exchangeSourceNodes: {3=[N1]}
  colocationGroup[-1]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  colocationGroup[1]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  colocationGroup[3]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  partitions: [CT_N1=[N1={0}]]
  tree: 
    Sender
        distribution: single
        targetFragmentId: 2
        est: (rows=100001)
      Project
          fieldNames: [ID0, C10, C20, ID, C1, C2]
          projection: [ID$0, C1$0, C2$0, ID, C1, C2]
          est: (rows=100001)
        NestedLoopJoin
            predicate: true
            fieldNames: [ID, C1, C2, ID$0, C1$0, C2$0]
            type: inner
            est: (rows=100001)
          Receiver
              fieldNames: [ID, C1, C2]
              sourceFragmentId: 3
              est: (rows=1)
          TableScan
              table: PUBLIC.CT_N1
              fieldNames: [ID, C1, C2]
              est: (rows=100001)

Fragment#3
  distribution: identity
  executionNodes: [N1]
  targetNodes: [N1]
  colocationGroup[0]: {nodes=[N1], sourceIds=[0], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  partitions: [NT_N1=[N1={0}]]
  tree: 
    Sender
        distribution: single
        targetFragmentId: 4
        est: (rows=100003)
      TableScan
          table: PUBLIC.NT_N1
          fieldNames: [ID, C1, C2]
          est: (rows=100003)
---

N1
SELECT * FROM CT_n1, NT_n1
---
Fragment#2 root
  distribution: single
  executionNodes: [N1]
  exchangeSourceNodes: {3=[N1]}
  colocationGroup[-1]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  colocationGroup[1]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  colocationGroup[3]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  partitions: [CT_N1=[N1={0}]]
  tree: 
    Project
        fieldNames: [ID0, C10, C20, ID, C1, C2]
        projection: [ID$0, C1$0, C2$0, ID, C1, C2]
        est: (rows=100001)
      NestedLoopJoin
          predicate: true
          fieldNames: [ID, C1, C2, ID$0, C1$0, C2$0]
          type: inner
          est: (rows=100001)
        Receiver
            fieldNames: [ID, C1, C2]
            sourceFragmentId: 3
            est: (rows=1)
        TableScan
            table: PUBLIC.CT_N1
            fieldNames: [ID, C1, C2]
            est: (rows=100001)

Fragment#3
  distribution: identity
  executionNodes: [N1]
  targetNodes: [N1]
  colocationGroup[0]: {nodes=[N1], sourceIds=[0], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  partitions: [NT_N1=[N1={0}]]
  tree: 
    Sender
        distribution: single
        targetFragmentId: 2
        est: (rows=100003)
      TableScan
          table: PUBLIC.NT_N1
          fieldNames: [ID, C1, C2]
          est: (rows=100003)
---

N0
SELECT * FROM CT_n1, NT_n2
---
Fragment#2 root
  distribution: single
  executionNodes: [N0]
  exchangeSourceNodes: {4=[N1]}
  colocationGroup[-1]: {nodes=[N0], sourceIds=[-1, 4], assignments={}, partitionsWithConsistencyTokens={N0=[]}}
  colocationGroup[4]: {nodes=[N0], sourceIds=[-1, 4], assignments={}, partitionsWithConsistencyTokens={N0=[]}}
  tree: 
    Receiver
        fieldNames: [ID0, C10, C20, ID, C1, C2]
        sourceFragmentId: 4
        est: (rows=1)

Fragment#4
  distribution: single
  executionNodes: [N1]
  targetNodes: [N0]
  exchangeSourceNodes: {3=[N2]}
  colocationGroup[-1]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  colocationGroup[1]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  colocationGroup[3]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  partitions: [CT_N1=[N1={0}]]
  tree: 
    Sender
        distribution: single
        targetFragmentId: 2
        est: (rows=100001)
      Project
          fieldNames: [ID0, C10, C20, ID, C1, C2]
          projection: [ID$0, C1$0, C2$0, ID, C1, C2]
          est: (rows=100001)
        NestedLoopJoin
            predicate: true
            fieldNames: [ID, C1, C2, ID$0, C1$0, C2$0]
            type: inner
            est: (rows=100001)
          Receiver
              fieldNames: [ID, C1, C2]
              sourceFragmentId: 3
              est: (rows=1)
          TableScan
              table: PUBLIC.CT_N1
              fieldNames: [ID, C1, C2]
              est: (rows=100001)

Fragment#3
  distribution: identity
  executionNodes: [N2]
  targetNodes: [N1]
  colocationGroup[0]: {nodes=[N2], sourceIds=[0], assignments={part_0=N2:1}, partitionsWithConsistencyTokens={N2=[part_0:1]}}
  partitions: [NT_N2=[N2={0}]]
  tree: 
    Sender
        distribution: single
        targetFragmentId: 4
        est: (rows=100004)
      TableScan
          table: PUBLIC.NT_N2
          fieldNames: [ID, C1, C2]
          est: (rows=100004)
---

N1
SELECT * FROM CT_n1, NT_n2
---
Fragment#2 root
  distribution: single
  executionNodes: [N1]
  exchangeSourceNodes: {3=[N2]}
  colocationGroup[-1]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  colocationGroup[1]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  colocationGroup[3]: {nodes=[N1], sourceIds=[-1, 1, 3], assignments={part_0=N1:1}, partitionsWithConsistencyTokens={N1=[part_0:1]}}
  partitions: [CT_N1=[N1={0}]]
  tree: 
    Project
        fieldNames: [ID0, C10, C20, ID, C1, C2]
        projection: [ID$0, C1$0, C2$0, ID, C1, C2]
        est: (rows=100001)
      NestedLoopJoin
          predicate: true
          fieldNames: [ID, C1, C2, ID$0, C1$0, C2$0]
          type: inner
          est: (rows=100001)
        Receiver
            fieldNames: [ID, C1, C2]
            sourceFragmentId: 3
            est: (rows=1)
        TableScan
            table: PUBLIC.CT_N1
            fieldNames: [ID, C1, C2]
            est: (rows=100001)

Fragment#3
  distribution: identity
  executionNodes: [N2]
  targetNodes: [N1]
  colocationGroup[0]: {nodes=[N2], sourceIds=[0], assignments={part_0=N2:1}, partitionsWithConsistencyTokens={N2=[part_0:1]}}
  partitions: [NT_N2=[N2={0}]]
  tree: 
    Sender
        distribution: single
        targetFragmentId: 2
        est: (rows=100004)
      TableScan
          table: PUBLIC.NT_N2
          fieldNames: [ID, C1, C2]
          est: (rows=100004)
---