Skip to content

Instantly share code, notes, and snippets.

@milinda

milinda/CALCITE-968

Created November 20, 2015 21:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save milinda/97484c23a8dc57fc2682 to your computer and use it in GitHub Desktop.
Save milinda/97484c23a8dc57fc2682 to your computer and use it in GitHub Desktop.
Download ZIP
Calcite query optimizer error for stream-to-realtion joins
Raw
CALCITE-968
Root: rel#25:Subset#6.ENUMERABLE.[]
Original rel:
Sets:
Set#0, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS)
rel#8:Subset#0.NONE.[0], best=null, importance=0.531441
rel#0:LogicalTableScan.NONE.[[0]](table=[STREAMJOINS, ORDERS]), rowcount=100.0, cumulative cost={inf}
rel#152:Subset#0.BINDABLE.[0], best=rel#151, importance=0.4304672100000001
rel#151:BindableTableScan.BINDABLE.[[0]](table=[STREAMJOINS, ORDERS]), rowcount=100.0, cumulative cost={1.0 rows, 1.01 cpu, 0.0 io}
rel#160:Subset#0.ENUMERABLE.[0], best=rel#592, importance=0.4782969000000001
rel#159:EnumerableTableScan.ENUMERABLE.[[0]](table=[STREAMJOINS, ORDERS]), rowcount=100.0, cumulative cost={100.0 rows, 101.0 cpu, 0.0 io}
rel#592:EnumerableInterpreter.ENUMERABLE.[0](input=rel#152:Subset#0.BINDABLE.[0]), rowcount=100.0, cumulative cost={51.0 rows, 51.01 cpu, 0.0 io}
rel#594:EnumerableInterpreter.ENUMERABLE.[[0]](input=rel#152:Subset#0.BINDABLE.[0]), rowcount=100.0, cumulative cost={51.0 rows, 51.01 cpu, 0.0 io}
Set#1, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4)
rel#10:Subset#1.NONE.[0], best=null, importance=0.5904900000000001
rel#9:LogicalProject.NONE.[[0]](input=rel#8:Subset#0.NONE.[0],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=CAST($2):VARCHAR(32) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=100.0, cumulative cost={inf}
rel#169:Subset#1.ENUMERABLE.[0], best=rel#168, importance=0.531441
rel#168:EnumerableProject.ENUMERABLE.[[0]](input=rel#160:Subset#0.ENUMERABLE.[0],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=CAST($2):VARCHAR(32) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=100.0, cumulative cost={151.0 rows, 551.01 cpu, 0.0 io}
rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last], best=null, importance=0.531441
Set#2, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER)
rel#11:Subset#2.NONE.[], best=null, importance=0.5904900000000001
rel#1:LogicalTableScan.NONE.[](table=[STREAMJOINS, PRODUCTS]), rowcount=200.0, cumulative cost={inf}
rel#149:Subset#2.BINDABLE.[], best=rel#148, importance=0.4782969000000001
rel#148:BindableTableScan.BINDABLE.[](table=[STREAMJOINS, PRODUCTS]), rowcount=200.0, cumulative cost={2.0 rows, 2.0100000000000002 cpu, 0.0 io}
rel#158:Subset#2.ENUMERABLE.[], best=rel#586, importance=0.531441
rel#157:EnumerableTableScan.ENUMERABLE.[](table=[STREAMJOINS, PRODUCTS]), rowcount=200.0, cumulative cost={200.0 rows, 201.0 cpu, 0.0 io}
rel#586:EnumerableInterpreter.ENUMERABLE.[](input=rel#149:Subset#2.BINDABLE.[]), rowcount=200.0, cumulative cost={102.0 rows, 102.01 cpu, 0.0 io}
rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last], best=null, importance=0.531441
Set#3, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4, VARCHAR(32) ID0, INTEGER SUPPLIER)
rel#13:Subset#3.NONE.[], best=null, importance=0.6561
rel#12:LogicalJoin.NONE.[](left=rel#10:Subset#1.NONE.[0],right=rel#11:Subset#2.NONE.[],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#106:LogicalProject.NONE.[](input=rel#105:Subset#16.NONE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#78:Subset#3.ENUMERABLE.[], best=rel#206, importance=0.6561
rel#181:EnumerableProject.ENUMERABLE.[](input=rel#162:Subset#16.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={7413.663473309607 rows, 21653.02 cpu, 0.0 io}
rel#195:EnumerableMergeJoin.ENUMERABLE.[[4 ASC-nulls-last], [5 ASC-nulls-last]](left=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],right=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#206:EnumerableJoin.ENUMERABLE.[](left=rel#169:Subset#1.ENUMERABLE.[0],right=rel#158:Subset#2.ENUMERABLE.[],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={3913.517018598809 rows, 653.02 cpu, 0.0 io}
Set#4, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) ID0, INTEGER SUPPLIER)
rel#15:Subset#4.NONE.[], best=null, importance=0.7290000000000001
rel#14:LogicalProject.NONE.[](input=rel#13:Subset#3.NONE.[],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,ID0=$5,SUPPLIER=$6), rowcount=3000.0, cumulative cost={inf}
rel#119:LogicalProject.NONE.[](input=rel#105:Subset#16.NONE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#549:LogicalProject.NONE.[](input=rel#78:Subset#3.ENUMERABLE.[],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,ID0=$5,SUPPLIER=$6), rowcount=3000.0, cumulative cost={inf}
rel#558:LogicalProject.NONE.[](input=rel#162:Subset#16.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#80:Subset#4.ENUMERABLE.[], best=rel#79, importance=0.49499999999999994
rel#79:EnumerableProject.ENUMERABLE.[](input=rel#78:Subset#3.ENUMERABLE.[],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,ID0=$5,SUPPLIER=$6), rowcount=3000.0, cumulative cost={6913.517018598809 rows, 18653.02 cpu, 0.0 io}
rel#170:EnumerableProject.ENUMERABLE.[](input=rel#162:Subset#16.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={7413.663473309607 rows, 18653.02 cpu, 0.0 io}
Set#5, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ORDERID, INTEGER SUPPLIERID)
rel#17:Subset#5.NONE.[], best=null, importance=0.81
rel#16:LogicalProject.NONE.[](input=rel#15:Subset#4.NONE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$5), rowcount=3000.0, cumulative cost={inf}
rel#53:LogicalProject.NONE.[](input=rel#13:Subset#3.NONE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$6), rowcount=3000.0, cumulative cost={inf}
rel#114:LogicalProject.NONE.[](input=rel#105:Subset#16.NONE.[],ROWTIME=$2,ORDERID=$3,SUPPLIERID=$1), rowcount=3000.0, cumulative cost={inf}
rel#223:LogicalProject.NONE.[](input=rel#162:Subset#16.ENUMERABLE.[],ROWTIME=$2,ORDERID=$3,SUPPLIERID=$1), rowcount=3000.0, cumulative cost={inf}
rel#239:LogicalProject.NONE.[](input=rel#78:Subset#3.ENUMERABLE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$6), rowcount=3000.0, cumulative cost={inf}
rel#164:Subset#5.ENUMERABLE.[], best=rel#166, importance=0.405
rel#163:EnumerableProject.ENUMERABLE.[](input=rel#162:Subset#16.ENUMERABLE.[],ROWTIME=$2,ORDERID=$3,SUPPLIERID=$1), rowcount=3000.0, cumulative cost={7413.663473309607 rows, 9653.02 cpu, 0.0 io}
rel#166:EnumerableProject.ENUMERABLE.[](input=rel#78:Subset#3.ENUMERABLE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$6), rowcount=3000.0, cumulative cost={6913.517018598809 rows, 9653.02 cpu, 0.0 io}
rel#167:EnumerableProject.ENUMERABLE.[](input=rel#80:Subset#4.ENUMERABLE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$5), rowcount=3000.0, cumulative cost={9913.51701859881 rows, 27653.02 cpu, 0.0 io}
Set#6, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ORDERID, INTEGER SUPPLIERID)
rel#19:Subset#6.NONE.[], best=null, importance=0.9
rel#18:LogicalDelta.NONE.[](input=rel#17:Subset#5.NONE.[]), rowcount=3000.0, cumulative cost={inf}
rel#26:AbstractConverter.NONE.[](input=rel#25:Subset#6.ENUMERABLE.[],convention=NONE,sort=[]), rowcount=3000.0, cumulative cost={inf}
rel#31:LogicalProject.NONE.[](input=rel#30:Subset#7.NONE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$5), rowcount=3000.0, cumulative cost={inf}
rel#38:LogicalProject.NONE.[](input=rel#36:Subset#8.NONE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$6), rowcount=3000.0, cumulative cost={inf}
rel#77:LogicalProject.NONE.[](input=rel#39:Subset#8.ENUMERABLE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$6), rowcount=3000.0, cumulative cost={inf}
rel#117:LogicalProject.NONE.[](input=rel#112:Subset#17.NONE.[],ROWTIME=$2,ORDERID=$3,SUPPLIERID=$1), rowcount=3000.0, cumulative cost={inf}
rel#172:LogicalProject.NONE.[](input=rel#156:Subset#17.ENUMERABLE.[],ROWTIME=$2,ORDERID=$3,SUPPLIERID=$1), rowcount=3000.0, cumulative cost={inf}
rel#227:LogicalProject.NONE.[](input=rel#226:Subset#18.NONE.[],ROWTIME=$2,ORDERID=$3,SUPPLIERID=$1), rowcount=3000.0, cumulative cost={inf}
rel#234:LogicalProject.NONE.[](input=rel#232:Subset#19.NONE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$6), rowcount=3000.0, cumulative cost={inf}
rel#455:LogicalProject.NONE.[](input=rel#228:Subset#18.ENUMERABLE.[],ROWTIME=$2,ORDERID=$3,SUPPLIERID=$1), rowcount=3000.0, cumulative cost={inf}
rel#457:LogicalProject.NONE.[](input=rel#243:Subset#19.ENUMERABLE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$6), rowcount=3000.0, cumulative cost={inf}
rel#25:Subset#6.ENUMERABLE.[], best=null, importance=1.0
rel#27:AbstractConverter.ENUMERABLE.[](input=rel#19:Subset#6.NONE.[],convention=ENUMERABLE,sort=[]), rowcount=3000.0, cumulative cost={inf}
rel#33:EnumerableProject.ENUMERABLE.[](input=rel#32:Subset#7.ENUMERABLE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$5), rowcount=3000.0, cumulative cost={inf}
rel#40:EnumerableProject.ENUMERABLE.[](input=rel#39:Subset#8.ENUMERABLE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$6), rowcount=3000.0, cumulative cost={inf}
rel#161:EnumerableProject.ENUMERABLE.[](input=rel#156:Subset#17.ENUMERABLE.[],ROWTIME=$2,ORDERID=$3,SUPPLIERID=$1), rowcount=3000.0, cumulative cost={inf}
rel#229:EnumerableProject.ENUMERABLE.[](input=rel#228:Subset#18.ENUMERABLE.[],ROWTIME=$2,ORDERID=$3,SUPPLIERID=$1), rowcount=3000.0, cumulative cost={inf}
rel#244:EnumerableProject.ENUMERABLE.[](input=rel#243:Subset#19.ENUMERABLE.[],ROWTIME=$0,ORDERID=$1,SUPPLIERID=$6), rowcount=3000.0, cumulative cost={inf}
Set#7, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) ID0, INTEGER SUPPLIER)
rel#30:Subset#7.NONE.[], best=null, importance=0.81
rel#28:LogicalDelta.NONE.[](input=rel#15:Subset#4.NONE.[]), rowcount=3000.0, cumulative cost={inf}
rel#37:LogicalProject.NONE.[](input=rel#36:Subset#8.NONE.[],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,ID0=$5,SUPPLIER=$6), rowcount=3000.0, cumulative cost={inf}
rel#118:LogicalProject.NONE.[](input=rel#112:Subset#17.NONE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#207:LogicalProject.NONE.[](input=rel#39:Subset#8.ENUMERABLE.[],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,ID0=$5,SUPPLIER=$6), rowcount=3000.0, cumulative cost={inf}
rel#209:LogicalProject.NONE.[](input=rel#156:Subset#17.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#552:LogicalProject.NONE.[](input=rel#232:Subset#19.NONE.[],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,ID0=$5,SUPPLIER=$6), rowcount=3000.0, cumulative cost={inf}
rel#555:LogicalProject.NONE.[](input=rel#226:Subset#18.NONE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#567:LogicalProject.NONE.[](input=rel#228:Subset#18.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#569:LogicalProject.NONE.[](input=rel#243:Subset#19.ENUMERABLE.[],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,ID0=$5,SUPPLIER=$6), rowcount=3000.0, cumulative cost={inf}
rel#32:Subset#7.ENUMERABLE.[], best=null, importance=0.9
rel#76:EnumerableProject.ENUMERABLE.[](input=rel#39:Subset#8.ENUMERABLE.[],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,ID0=$5,SUPPLIER=$6), rowcount=3000.0, cumulative cost={inf}
rel#171:EnumerableProject.ENUMERABLE.[](input=rel#156:Subset#17.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#563:EnumerableProject.ENUMERABLE.[](input=rel#228:Subset#18.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#565:EnumerableProject.ENUMERABLE.[](input=rel#243:Subset#19.ENUMERABLE.[],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,ID0=$5,SUPPLIER=$6), rowcount=3000.0, cumulative cost={inf}
Set#8, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4, VARCHAR(32) ID0, INTEGER SUPPLIER)
rel#36:Subset#8.NONE.[], best=null, importance=0.7290000000000001
rel#34:LogicalDelta.NONE.[](input=rel#13:Subset#3.NONE.[]), rowcount=3000.0, cumulative cost={inf}
rel#52:LogicalUnion.NONE.[](input#0=rel#48:Subset#10.NONE.[],input#1=rel#51:Subset#12.NONE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#113:LogicalProject.NONE.[](input=rel#112:Subset#17.NONE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#39:Subset#8.ENUMERABLE.[], best=null, importance=0.7290000000000001
rel#73:EnumerableUnion.ENUMERABLE.[](input#0=rel#74:Subset#10.ENUMERABLE.[],input#1=rel#75:Subset#12.ENUMERABLE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#175:EnumerableProject.ENUMERABLE.[](input=rel#156:Subset#17.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
Set#9, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER)
rel#46:Subset#9.NONE.[], best=null, importance=0.5904900000000001
rel#41:LogicalDelta.NONE.[](input=rel#11:Subset#2.NONE.[]), rowcount=200.0, cumulative cost={inf}
rel#189:Subset#9.ENUMERABLE.[0 ASC-nulls-last], best=null, importance=0.531441
rel#197:Subset#9.ENUMERABLE.[], best=null, importance=0.531441
Set#10, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4, VARCHAR(32) ID0, INTEGER SUPPLIER)
rel#48:Subset#10.NONE.[], best=null, importance=0.6561
rel#47:LogicalJoin.NONE.[](left=rel#10:Subset#1.NONE.[0],right=rel#46:Subset#9.NONE.[],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#69:LogicalProject.NONE.[](input=rel#68:Subset#14.NONE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#74:Subset#10.ENUMERABLE.[], best=null, importance=0.6561
rel#183:EnumerableProject.ENUMERABLE.[](input=rel#155:Subset#14.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#194:EnumerableMergeJoin.ENUMERABLE.[[4 ASC-nulls-last], [5 ASC-nulls-last]](left=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],right=rel#189:Subset#9.ENUMERABLE.[0 ASC-nulls-last],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#205:EnumerableJoin.ENUMERABLE.[](left=rel#169:Subset#1.ENUMERABLE.[0],right=rel#197:Subset#9.ENUMERABLE.[],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
Set#11, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4)
rel#49:Subset#11.NONE.[0], best=null, importance=0.5904900000000001
rel#43:LogicalDelta.NONE.[0](input=rel#10:Subset#1.NONE.[0]), rowcount=100.0, cumulative cost={inf}
rel#247:LogicalDelta.NONE.[0](input=rel#169:Subset#1.ENUMERABLE.[0]), rowcount=100.0, cumulative cost={inf}
rel#85:Subset#11.NONE.[], best=null, importance=0.29524500000000004
rel#43:LogicalDelta.NONE.[0](input=rel#10:Subset#1.NONE.[0]), rowcount=100.0, cumulative cost={inf}
rel#84:LogicalProject.NONE.[](input=rel#83:Subset#15.NONE.[0],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=CAST($2):VARCHAR(32) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=100.0, cumulative cost={inf}
rel#247:LogicalDelta.NONE.[0](input=rel#169:Subset#1.ENUMERABLE.[0]), rowcount=100.0, cumulative cost={inf}
rel#191:Subset#11.ENUMERABLE.[4 ASC-nulls-last], best=null, importance=0.531441
rel#199:Subset#11.ENUMERABLE.[0], best=rel#584, importance=0.531441
rel#584:EnumerableProject.ENUMERABLE.[[0]](input=rel#583:Subset#15.ENUMERABLE.[0],ROWTIME=$0,ID=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=CAST($2):VARCHAR(32) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL), rowcount=100.0, cumulative cost={151.0 rows, 551.01 cpu, 0.0 io}
Set#12, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4, VARCHAR(32) ID0, INTEGER SUPPLIER)
rel#51:Subset#12.NONE.[], best=null, importance=0.6561
rel#50:LogicalJoin.NONE.[](left=rel#49:Subset#11.NONE.[0],right=rel#11:Subset#2.NONE.[],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#62:LogicalProject.NONE.[](input=rel#61:Subset#13.NONE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#254:LogicalJoin.NONE.[](left=rel#49:Subset#11.NONE.[0],right=rel#158:Subset#2.ENUMERABLE.[],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#324:LogicalJoin.NONE.[](left=rel#49:Subset#11.NONE.[0],right=rel#158:Subset#2.ENUMERABLE.[],condition==($5, $4),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#75:Subset#12.ENUMERABLE.[], best=rel#201, importance=0.6561
rel#185:EnumerableProject.ENUMERABLE.[](input=rel#154:Subset#13.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={7413.663473309607 rows, 21653.02 cpu, 0.0 io}
rel#193:EnumerableMergeJoin.ENUMERABLE.[[4 ASC-nulls-last], [5 ASC-nulls-last]](left=rel#191:Subset#11.ENUMERABLE.[4 ASC-nulls-last],right=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#201:EnumerableJoin.ENUMERABLE.[](left=rel#199:Subset#11.ENUMERABLE.[0],right=rel#158:Subset#2.ENUMERABLE.[],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={3913.517018598809 rows, 653.02 cpu, 0.0 io}
Set#13, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER, TIMESTAMP(0) ROWTIME, INTEGER ID0, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4)
rel#61:Subset#13.NONE.[], best=null, importance=0.5904900000000001
rel#59:LogicalJoin.NONE.[](left=rel#11:Subset#2.NONE.[],right=rel#49:Subset#11.NONE.[0],condition==($6, $0),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#65:LogicalProject.NONE.[](input=rel#51:Subset#12.NONE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#373:LogicalJoin.NONE.[](left=rel#158:Subset#2.ENUMERABLE.[],right=rel#49:Subset#11.NONE.[0],condition==($6, $0),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#274:LogicalJoin.NONE.[](left=rel#158:Subset#2.ENUMERABLE.[],right=rel#49:Subset#11.NONE.[0],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#154:Subset#13.ENUMERABLE.[], best=rel#200, importance=0.5904900000000001
rel#184:EnumerableProject.ENUMERABLE.[](input=rel#75:Subset#12.ENUMERABLE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={6913.517018598809 rows, 21653.02 cpu, 0.0 io}
rel#192:EnumerableMergeJoin.ENUMERABLE.[[0 ASC-nulls-last], [6 ASC-nulls-last]](left=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],right=rel#191:Subset#11.ENUMERABLE.[4 ASC-nulls-last],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#200:EnumerableJoin.ENUMERABLE.[](left=rel#158:Subset#2.ENUMERABLE.[],right=rel#199:Subset#11.ENUMERABLE.[0],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={4413.663473309607 rows, 653.02 cpu, 0.0 io}
Set#14, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER, TIMESTAMP(0) ROWTIME, INTEGER ID0, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4)
rel#68:Subset#14.NONE.[], best=null, importance=0.5904900000000001
rel#66:LogicalJoin.NONE.[](left=rel#46:Subset#9.NONE.[],right=rel#10:Subset#1.NONE.[0],condition==($6, $0),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#72:LogicalProject.NONE.[](input=rel#48:Subset#10.NONE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#155:Subset#14.ENUMERABLE.[], best=null, importance=0.5904900000000001
rel#182:EnumerableProject.ENUMERABLE.[](input=rel#74:Subset#10.ENUMERABLE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#190:EnumerableMergeJoin.ENUMERABLE.[[0 ASC-nulls-last], [6 ASC-nulls-last]](left=rel#189:Subset#9.ENUMERABLE.[0 ASC-nulls-last],right=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#198:EnumerableJoin.ENUMERABLE.[](left=rel#197:Subset#9.ENUMERABLE.[],right=rel#169:Subset#1.ENUMERABLE.[0],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
Set#15, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS)
rel#83:Subset#15.NONE.[0], best=null, importance=0.9999999999999999
rel#81:LogicalDelta.NONE.[0](input=rel#8:Subset#0.NONE.[0]), rowcount=100.0, cumulative cost={inf}
rel#150:LogicalTableScan.NONE.[[0]](table=[]), rowcount=100.0, cumulative cost={inf}
rel#289:LogicalDelta.NONE.[0](input=rel#160:Subset#0.ENUMERABLE.[0]), rowcount=100.0, cumulative cost={inf}
rel#204:Subset#15.BINDABLE.[0], best=rel#203, importance=0.49999999999999994
rel#203:BindableTableScan.BINDABLE.[[0]](table=[]), rowcount=100.0, cumulative cost={1.0 rows, 1.01 cpu, 0.0 io}
rel#583:Subset#15.ENUMERABLE.[0], best=rel#589, importance=0.49999999999999994
rel#589:EnumerableInterpreter.ENUMERABLE.[0](input=rel#204:Subset#15.BINDABLE.[0]), rowcount=100.0, cumulative cost={51.0 rows, 51.01 cpu, 0.0 io}
rel#591:EnumerableInterpreter.ENUMERABLE.[[0]](input=rel#204:Subset#15.BINDABLE.[0]), rowcount=100.0, cumulative cost={51.0 rows, 51.01 cpu, 0.0 io}
Set#16, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER, TIMESTAMP(0) ROWTIME, INTEGER ID0, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4)
rel#105:Subset#16.NONE.[], best=null, importance=0.5904900000000001
rel#103:LogicalJoin.NONE.[](left=rel#11:Subset#2.NONE.[],right=rel#10:Subset#1.NONE.[0],condition==($6, $0),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#109:LogicalProject.NONE.[](input=rel#13:Subset#3.NONE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#162:Subset#16.ENUMERABLE.[], best=rel#196, importance=0.5904900000000001
rel#180:EnumerableProject.ENUMERABLE.[](input=rel#78:Subset#3.ENUMERABLE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={6913.517018598809 rows, 21653.02 cpu, 0.0 io}
rel#188:EnumerableMergeJoin.ENUMERABLE.[[0 ASC-nulls-last], [6 ASC-nulls-last]](left=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],right=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#196:EnumerableJoin.ENUMERABLE.[](left=rel#158:Subset#2.ENUMERABLE.[],right=rel#169:Subset#1.ENUMERABLE.[0],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={4413.663473309607 rows, 653.02 cpu, 0.0 io}
Set#17, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER, TIMESTAMP(0) ROWTIME, INTEGER ID0, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4)
rel#112:Subset#17.NONE.[], best=null, importance=0.6561
rel#110:LogicalDelta.NONE.[](input=rel#105:Subset#16.NONE.[]), rowcount=3000.0, cumulative cost={inf}
rel#125:LogicalProject.NONE.[](input=rel#36:Subset#8.NONE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#140:LogicalUnion.NONE.[](input#0=rel#61:Subset#13.NONE.[],input#1=rel#68:Subset#14.NONE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#156:Subset#17.ENUMERABLE.[], best=null, importance=0.6561
rel#153:EnumerableUnion.ENUMERABLE.[](input#0=rel#154:Subset#13.ENUMERABLE.[],input#1=rel#155:Subset#14.ENUMERABLE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#173:EnumerableProject.ENUMERABLE.[](input=rel#39:Subset#8.ENUMERABLE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
Set#18, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER, TIMESTAMP(0) ROWTIME, INTEGER ID0, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4)
rel#226:Subset#18.NONE.[], best=null, importance=0.6561
rel#224:LogicalDelta.NONE.[](input=rel#162:Subset#16.ENUMERABLE.[]), rowcount=3000.0, cumulative cost={inf}
rel#233:LogicalProject.NONE.[](input=rel#232:Subset#19.NONE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#278:LogicalUnion.NONE.[](input#0=rel#61:Subset#13.NONE.[],input#1=rel#277:Subset#29.NONE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#288:LogicalUnion.NONE.[](input#0=rel#285:Subset#30.NONE.[],input#1=rel#287:Subset#31.NONE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#228:Subset#18.ENUMERABLE.[], best=null, importance=0.7290000000000001
rel#416:EnumerableUnion.ENUMERABLE.[](input#0=rel#417:Subset#30.ENUMERABLE.[],input#1=rel#418:Subset#31.ENUMERABLE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#419:EnumerableUnion.ENUMERABLE.[](input#0=rel#154:Subset#13.ENUMERABLE.[],input#1=rel#421:Subset#29.ENUMERABLE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#456:EnumerableProject.ENUMERABLE.[](input=rel#243:Subset#19.ENUMERABLE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
Set#19, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4, VARCHAR(32) ID0, INTEGER SUPPLIER)
rel#232:Subset#19.NONE.[], best=null, importance=0.7290000000000001
rel#230:LogicalDelta.NONE.[](input=rel#78:Subset#3.ENUMERABLE.[]), rowcount=3000.0, cumulative cost={inf}
rel#237:LogicalProject.NONE.[](input=rel#226:Subset#18.NONE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#256:LogicalUnion.NONE.[](input#0=rel#252:Subset#21.NONE.[],input#1=rel#51:Subset#12.NONE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#268:LogicalUnion.NONE.[](input#0=rel#264:Subset#25.NONE.[],input#1=rel#267:Subset#27.NONE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#243:Subset#19.ENUMERABLE.[], best=null, importance=0.6561
rel#422:EnumerableUnion.ENUMERABLE.[](input#0=rel#423:Subset#25.ENUMERABLE.[],input#1=rel#424:Subset#27.ENUMERABLE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#425:EnumerableUnion.ENUMERABLE.[](input#0=rel#426:Subset#21.ENUMERABLE.[],input#1=rel#75:Subset#12.ENUMERABLE.[],all=true), rowcount=6000.0, cumulative cost={inf}
rel#454:EnumerableProject.ENUMERABLE.[](input=rel#228:Subset#18.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
Set#20, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER)
rel#250:Subset#20.NONE.[], best=null, importance=0.531441
rel#245:LogicalDelta.NONE.[](input=rel#158:Subset#2.ENUMERABLE.[]), rowcount=200.0, cumulative cost={inf}
rel#458:Subset#20.ENUMERABLE.[0 ASC-nulls-last], best=null, importance=0.531441
rel#513:Subset#20.ENUMERABLE.[], best=null, importance=0.531441
Set#21, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4, VARCHAR(32) ID0, INTEGER SUPPLIER)
rel#252:Subset#21.NONE.[], best=null, importance=0.531441
rel#251:LogicalJoin.NONE.[](left=rel#169:Subset#1.ENUMERABLE.[0],right=rel#250:Subset#20.NONE.[],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#317:LogicalJoin.NONE.[](left=rel#169:Subset#1.ENUMERABLE.[0],right=rel#250:Subset#20.NONE.[],condition==($5, $4),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#323:LogicalProject.NONE.[](input=rel#277:Subset#29.NONE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#426:Subset#21.ENUMERABLE.[], best=null, importance=0.5904900000000001
rel#445:EnumerableProject.ENUMERABLE.[](input=rel#421:Subset#29.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#470:EnumerableMergeJoin.ENUMERABLE.[[4 ASC-nulls-last], [5 ASC-nulls-last]](left=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],right=rel#458:Subset#20.ENUMERABLE.[0 ASC-nulls-last],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#521:EnumerableJoin.ENUMERABLE.[](left=rel#169:Subset#1.ENUMERABLE.[0],right=rel#513:Subset#20.ENUMERABLE.[],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
Set#24, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER)
rel#262:Subset#24.NONE.[0 ASC-nulls-last], best=null, importance=0.531441
rel#257:LogicalDelta.NONE.[0 ASC-nulls-last](input=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last]), rowcount=200.0, cumulative cost={inf}
rel#465:Subset#24.ENUMERABLE.[0 ASC-nulls-last], best=null, importance=0.531441
Set#25, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4, VARCHAR(32) ID0, INTEGER SUPPLIER)
rel#264:Subset#25.NONE.[], best=null, importance=0.531441
rel#263:LogicalJoin.NONE.[](left=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],right=rel#262:Subset#24.NONE.[0 ASC-nulls-last],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#303:LogicalJoin.NONE.[](left=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],right=rel#262:Subset#24.NONE.[0 ASC-nulls-last],condition==($5, $4),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#309:LogicalProject.NONE.[](input=rel#287:Subset#31.NONE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#423:Subset#25.ENUMERABLE.[], best=null, importance=0.5904900000000001
rel#451:EnumerableProject.ENUMERABLE.[](input=rel#418:Subset#31.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#502:EnumerableMergeJoin.ENUMERABLE.[[4 ASC-nulls-last], [5 ASC-nulls-last]](left=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],right=rel#465:Subset#24.ENUMERABLE.[0 ASC-nulls-last],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#523:EnumerableJoin.ENUMERABLE.[](left=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],right=rel#465:Subset#24.ENUMERABLE.[0 ASC-nulls-last],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
Set#26, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4)
rel#265:Subset#26.NONE.[4 ASC-nulls-last], best=null, importance=0.531441
rel#259:LogicalDelta.NONE.[4 ASC-nulls-last](input=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last]), rowcount=100.0, cumulative cost={inf}
rel#467:Subset#26.ENUMERABLE.[4 ASC-nulls-last], best=null, importance=0.531441
Set#27, type: RecordType(TIMESTAMP(0) ROWTIME, INTEGER ID, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4, VARCHAR(32) ID0, INTEGER SUPPLIER)
rel#267:Subset#27.NONE.[], best=null, importance=0.531441
rel#266:LogicalJoin.NONE.[](left=rel#265:Subset#26.NONE.[4 ASC-nulls-last],right=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#310:LogicalJoin.NONE.[](left=rel#265:Subset#26.NONE.[4 ASC-nulls-last],right=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],condition==($5, $4),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#316:LogicalProject.NONE.[](input=rel#285:Subset#30.NONE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#424:Subset#27.ENUMERABLE.[], best=null, importance=0.5904900000000001
rel#448:EnumerableProject.ENUMERABLE.[](input=rel#417:Subset#30.ENUMERABLE.[],ROWTIME=$2,ID=$3,PRODUCT=$4,UNITS=$5,PRODUCT4=$6,ID0=$0,SUPPLIER=$1), rowcount=3000.0, cumulative cost={inf}
rel#471:EnumerableMergeJoin.ENUMERABLE.[[4 ASC-nulls-last], [5 ASC-nulls-last]](left=rel#467:Subset#26.ENUMERABLE.[4 ASC-nulls-last],right=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#522:EnumerableJoin.ENUMERABLE.[](left=rel#467:Subset#26.ENUMERABLE.[4 ASC-nulls-last],right=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],condition==($4, $5),joinType=inner), rowcount=3000.0, cumulative cost={inf}
Set#29, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER, TIMESTAMP(0) ROWTIME, INTEGER ID0, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4)
rel#277:Subset#29.NONE.[], best=null, importance=0.5904900000000001
rel#276:LogicalJoin.NONE.[](left=rel#250:Subset#20.NONE.[],right=rel#169:Subset#1.ENUMERABLE.[0],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#380:LogicalJoin.NONE.[](left=rel#250:Subset#20.NONE.[],right=rel#169:Subset#1.ENUMERABLE.[0],condition==($6, $0),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#386:LogicalProject.NONE.[](input=rel#252:Subset#21.NONE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#421:Subset#29.ENUMERABLE.[], best=null, importance=0.6561
rel#430:EnumerableProject.ENUMERABLE.[](input=rel#426:Subset#21.ENUMERABLE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#459:EnumerableMergeJoin.ENUMERABLE.[[0 ASC-nulls-last], [6 ASC-nulls-last]](left=rel#458:Subset#20.ENUMERABLE.[0 ASC-nulls-last],right=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#514:EnumerableJoin.ENUMERABLE.[](left=rel#513:Subset#20.ENUMERABLE.[],right=rel#169:Subset#1.ENUMERABLE.[0],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
Set#30, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER, TIMESTAMP(0) ROWTIME, INTEGER ID0, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4)
rel#285:Subset#30.NONE.[], best=null, importance=0.5904900000000001
rel#284:LogicalJoin.NONE.[](left=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],right=rel#265:Subset#26.NONE.[4 ASC-nulls-last],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#359:LogicalJoin.NONE.[](left=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],right=rel#265:Subset#26.NONE.[4 ASC-nulls-last],condition==($6, $0),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#365:LogicalProject.NONE.[](input=rel#267:Subset#27.NONE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#417:Subset#30.ENUMERABLE.[], best=null, importance=0.6561
rel#439:EnumerableProject.ENUMERABLE.[](input=rel#424:Subset#27.ENUMERABLE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#468:EnumerableMergeJoin.ENUMERABLE.[[0 ASC-nulls-last], [6 ASC-nulls-last]](left=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],right=rel#467:Subset#26.ENUMERABLE.[4 ASC-nulls-last],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#518:EnumerableJoin.ENUMERABLE.[](left=rel#186:Subset#2.ENUMERABLE.[0 ASC-nulls-last],right=rel#467:Subset#26.ENUMERABLE.[4 ASC-nulls-last],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
Set#31, type: RecordType(VARCHAR(32) ID, INTEGER SUPPLIER, TIMESTAMP(0) ROWTIME, INTEGER ID0, VARCHAR(10) PRODUCT, INTEGER UNITS, VARCHAR(32) PRODUCT4)
rel#287:Subset#31.NONE.[], best=null, importance=0.5904900000000001
rel#286:LogicalJoin.NONE.[](left=rel#262:Subset#24.NONE.[0 ASC-nulls-last],right=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#366:LogicalJoin.NONE.[](left=rel#262:Subset#24.NONE.[0 ASC-nulls-last],right=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],condition==($6, $0),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#372:LogicalProject.NONE.[](input=rel#264:Subset#25.NONE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#418:Subset#31.ENUMERABLE.[], best=null, importance=0.6561
rel#436:EnumerableProject.ENUMERABLE.[](input=rel#423:Subset#25.ENUMERABLE.[],ID=$5,SUPPLIER=$6,ROWTIME=$0,ID0=$1,PRODUCT=$2,UNITS=$3,PRODUCT4=$4), rowcount=3000.0, cumulative cost={inf}
rel#466:EnumerableMergeJoin.ENUMERABLE.[[0 ASC-nulls-last], [6 ASC-nulls-last]](left=rel#465:Subset#24.ENUMERABLE.[0 ASC-nulls-last],right=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
rel#517:EnumerableJoin.ENUMERABLE.[](left=rel#465:Subset#24.ENUMERABLE.[0 ASC-nulls-last],right=rel#187:Subset#1.ENUMERABLE.[4 ASC-nulls-last],condition==($0, $6),joinType=inner), rowcount=3000.0, cumulative cost={inf}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment