Changeset: c76d5d5a1181 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c76d5d5a1181 Modified Files: sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out sql/test/BugTracker-2015/Tests/large_join.Bug-3809.stable.out Branch: Jul2015 Log Message:
approved output diffs (truncated from 436 to 300 lines): diff --git a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out --- a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out +++ b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out @@ -78,7 +78,6 @@ project ( | | | | | | table(sys.bidder) [ bidder.id NOT NULL as L6.id, bidder.open_auction_id NOT NULL as L6.open_auction_id ] COUNT , | | | | | | project ( | | | | | | | crossproduct ( -| | | | | | | | table(sys.bidder) [ bidder.id NOT NULL as L5.id, bidder.increase NOT NULL as L5.increase ] COUNT , | | | | | | | | project ( | | | | | | | | | select ( | | | | | | | | | | group by ( @@ -98,7 +97,8 @@ project ( | | | | | | | | | | | ) [ b3a.open_auction_id NOT NULL = o.open_auction_id NOT NULL ] | | | | | | | | | | ) [ L7.L7, L10.L10 ] [ L10.L10 HASHCOL , o.id NOT NULL HASHCOL , o.open_auction_id NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL, b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL, b3.id NOT NULL HASHCOL , b3.increase NOT NULL, L7.L7 HASHCOL , sys.min no nil (b3a.id NOT NULL HASHCOL ) NOT NULL as L1.L1 ] | | | | | | | | | ) [ b3.id NOT NULL HASHCOL = L1 NOT NULL ] -| | | | | | | | ) [ o.id NOT NULL HASHCOL , o.open_auction_id NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL, b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL, b3.increase NOT NULL as L2.L2, sys.identity(o.id NOT NULL HASHCOL ) HASHCOL as L12.L12 ] +| | | | | | | | ) [ o.id NOT NULL HASHCOL , o.open_auction_id NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL, b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL, b3.increase NOT NULL as L2.L2, sys.identity(o.id NOT NULL HASHCOL ) HASHCOL as L12.L12 ], +| | | | | | | | table(sys.bidder) [ bidder.id NOT NULL as L5.id, bidder.increase NOT NULL as L5.increase ] COUNT | | | | | | | ) [ ] | | | | | | ) [ L2.L2 NOT NULL, L12.L12 HASHCOL , o.id NOT NULL HASHCOL , o.open_auction_id NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL, b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL, L5.id NOT NULL, L5.increase NOT NULL, sys.identity(o.id NOT NULL HASHCOL ) HASHCOL as L11.L11 ] | | | | | ) [ L6.open_auction_id NOT NULL = o.open_auction_id NOT NULL ] diff --git a/sql/test/BugTracker-2015/Tests/large_join.Bug-3809.stable.out b/sql/test/BugTracker-2015/Tests/large_join.Bug-3809.stable.out --- a/sql/test/BugTracker-2015/Tests/large_join.Bug-3809.stable.out +++ b/sql/test/BugTracker-2015/Tests/large_join.Bug-3809.stable.out @@ -1533,20 +1533,20 @@ project ( % .plan # table_name % rel # name % clob # type -% 375 # length +% 212 # length project ( | join ( | | join ( -| | | crossproduct ( -| | | | crossproduct ( -| | | | | crossproduct ( -| | | | | | crossproduct ( -| | | | | | | crossproduct ( -| | | | | | | | crossproduct ( -| | | | | | | | | crossproduct ( -| | | | | | | | | | crossproduct ( -| | | | | | | | | | | crossproduct ( -| | | | | | | | | | | | crossproduct ( +| | | join ( +| | | | join ( +| | | | | join ( +| | | | | | join ( +| | | | | | | join ( +| | | | | | | | join ( +| | | | | | | | | join ( +| | | | | | | | | | join ( +| | | | | | | | | | | join ( +| | | | | | | | | | | | join ( | | | | | | | | | | | | | join ( | | | | | | | | | | | | | | join ( | | | | | | | | | | | | | | | join ( @@ -1583,31 +1583,60 @@ project ( | | | | | | | | | | | | | | ) [ t47.a47 NOT NULL HASHCOL = t37.b37 ], | | | | | | | | | | | | | | table(sys.t54) [ t54.a54 NOT NULL HASHCOL , t54.b54, t54.x54 ] COUNT | | | | | | | | | | | | | ) [ t37.a37 NOT NULL HASHCOL = t54.b54 ], -| | | | | | | | | | | | | table(sys.t50) [ t50.a50 NOT NULL HASHCOL , t50.b50, t50.x50 ] COUNT -| | | | | | | | | | | | ) [ ], -| | | | | | | | | | | | table(sys.t30) [ t30.a30 NOT NULL HASHCOL , t30.b30, t30.x30 ] COUNT -| | | | | | | | | | | ) [ ], +| | | | | | | | | | | | | table(sys.t8) [ t8.a8 NOT NULL HASHCOL , t8.b8, t8.x8 ] COUNT +| | | | | | | | | | | | ) [ t54.a54 NOT NULL HASHCOL = t8.b8 ], +| | | | | | | | | | | | table(sys.t20) [ t20.a20 NOT NULL HASHCOL , t20.b20, t20.x20 ] COUNT +| | | | | | | | | | | ) [ t8.a8 NOT NULL HASHCOL = t20.b20 ], | | | | | | | | | | | table(sys.t55) [ t55.a55 NOT NULL HASHCOL , t55.b55, t55.x55 ] COUNT -| | | | | | | | | | ) [ ], -| | | | | | | | | | table(sys.t21) [ t21.a21 NOT NULL HASHCOL , t21.b21, t21.x21 ] COUNT -| | | | | | | | | ) [ ], -| | | | | | | | | table(sys.t32) [ t32.a32 NOT NULL HASHCOL , t32.b32, t32.x32 ] COUNT -| | | | | | | | ) [ ], -| | | | | | | | table(sys.t63) [ t63.a63 NOT NULL HASHCOL , t63.b63, t63.x63 ] COUNT -| | | | | | | ) [ ], -| | | | | | | table(sys.t9) [ t9.a9 NOT NULL HASHCOL , t9.b9, t9.x9 ] COUNT -| | | | | | ) [ ], -| | | | | | table(sys.t20) [ t20.a20 NOT NULL HASHCOL , t20.b20, t20.x20 ] COUNT -| | | | | ) [ ], +| | | | | | | | | | ) [ t20.a20 NOT NULL HASHCOL = t55.b55 ], +| | | | | | | | | | table(sys.t9) [ t9.a9 NOT NULL HASHCOL , t9.b9, t9.x9 ] COUNT +| | | | | | | | | ) [ t55.a55 NOT NULL HASHCOL = t9.b9 ], +| | | | | | | | | table(sys.t30) [ t30.a30 NOT NULL HASHCOL , t30.b30, t30.x30 ] COUNT +| | | | | | | | ) [ t30.b30 = t9.a9 NOT NULL HASHCOL ], +| | | | | | | | table(sys.t32) [ t32.a32 NOT NULL HASHCOL , t32.b32, t32.x32 ] COUNT +| | | | | | | ) [ t32.b32 = t30.a30 NOT NULL HASHCOL ], +| | | | | | | table(sys.t22) [ t22.a22 NOT NULL HASHCOL , t22.b22, t22.x22 ] COUNT +| | | | | | ) [ t22.b22 = t32.a32 NOT NULL HASHCOL ], +| | | | | | table(sys.t43) [ t43.a43 NOT NULL HASHCOL , t43.b43, t43.x43 ] COUNT +| | | | | ) [ t22.a22 NOT NULL HASHCOL = t43.b43 ], | | | | | table(sys.t29) [ t29.a29 NOT NULL HASHCOL , t29.b29, t29.x29 ] COUNT -| | | | ) [ ], -| | | | table(sys.t22) [ t22.a22 NOT NULL HASHCOL , t22.b22, t22.x22 ] COUNT -| | | ) [ ], -| | | table(sys.t43) [ t43.a43 NOT NULL HASHCOL , t43.b43, t43.x43 ] COUNT -| | ) [ t32.b32 = t30.a30 NOT NULL HASHCOL , t30.b30 = t9.a9 NOT NULL HASHCOL , t21.a21 NOT NULL HASHCOL = t50.b50, t50.a50 NOT NULL HASHCOL = t63.b63, t20.a20 NOT NULL HASHCOL = t55.b55, t55.a55 NOT NULL HASHCOL = t9.b9, t43.a43 NOT NULL HASHCOL = t29.b29, t22.a22 NOT NULL HASHCOL = t43.b43, t29.a29 NOT NULL HASHCOL = t21.b21, t22.b22 = t32.a32 NOT NULL HASHCOL ], -| | table(sys.t8) [ t8.a8 NOT NULL HASHCOL , t8.b8, t8.x8 ] COUNT -| ) [ t54.a54 NOT NULL HASHCOL = t8.b8, t8.a8 NOT NULL HASHCOL = t20.b20 ] +| | | | ) [ t43.a43 NOT NULL HASHCOL = t29.b29 ], +| | | | table(sys.t21) [ t21.a21 NOT NULL HASHCOL , t21.b21, t21.x21 ] COUNT +| | | ) [ t29.a29 NOT NULL HASHCOL = t21.b21 ], +| | | table(sys.t50) [ t50.a50 NOT NULL HASHCOL , t50.b50, t50.x50 ] COUNT +| | ) [ t21.a21 NOT NULL HASHCOL = t50.b50 ], +| | table(sys.t63) [ t63.b63, t63.x63 ] COUNT +| ) [ t50.a50 NOT NULL HASHCOL = t63.b63 ] ) [ t20.x20, t47.x47, t38.x38, t18.x18, t10.x10, t22.x22, t37.x37, t3.x3, t63.x63, t8.x8, t30.x30, t43.x43, t54.x54, t9.x9, t21.x21, t25.x25, t2.x2, t61.x61, t55.x55, t32.x32, t52.x52, t29.x29, t50.x50, t12.x12 ] +#SELECT x20,x47,x38,x18,x10,x22,x37,x3,x63,x8,x30,x43,x54,x9,x21,x25,x2,x61,x55,x32,x52,x29,x50,x12 +# FROM t2,t9,t20,t63,t54,t32,t22,t52,t25,t47,t29,t12,t18,t10,t21,t43,t37,t61,t55,t3,t38,t50,t30,t8 +# WHERE b3=a18 +# AND a25=b38 +# AND a54=b8 +# AND a61=b47 +# AND a43=b29 +# AND b18=a12 +# AND b32=a30 +# AND a22=b43 +# AND a29=b21 +# AND a10=b25 +# AND a12=4 +# AND b22=a32 +# AND a20=b55 +# AND b30=a9 +# AND a2=b61 +# AND a38=b52 +# AND a55=b9 +# AND a21=b50 +# AND a37=b54 +# AND b10=a3 +# AND a52=b2 +# AND a50=b63 +% sys.t20, sys.t47, sys.t38, sys.t18, sys.t10, sys.t22, sys.t37, sys.t3, sys.t63, sys.t8, sys.t30, sys.t43, sys.t54, sys.t9, sys.t21, sys.t25, sys.t2, sys.t61, sys.t55, sys.t32, sys.t52, sys.t29, sys.t50, sys.t12 # table_name +% x20, x47, x38, x18, x10, x22, x37, x3, x63, x8, x30, x43, x54, x9, x21, x25, x2, x61, x55, x32, x52, x29, x50, x12 # name +% varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar # type +% 15, 16, 15, 16, 15, 15, 15, 14, 15, 14, 15, 15, 15, 14, 15, 15, 15, 15, 15, 15, 15, 16, 15, 15 # length +[ "table t20 row 5", "table t47 row 10", "table t38 row 5", "table t18 row 10", "table t10 row 1", "table t22 row 2", "table t37 row 9", "table t3 row 8", "table t63 row 3", "table t8 row 6", "table t30 row 6", "table t43 row 1", "table t54 row 4", "table t9 row 4", "table t21 row 8", "table t25 row 4", "table t2 row 10", "table t61 row 8", "table t55 row 5", "table t32 row 3", "table t52 row 1", "table t29 row 10", "table t50 row 1", "table t12 row 4" ] #plan #SELECT x20,x47,x38,x18,x10,x22,x37,x3,x63,x8,x30,x43,x54,x9,x21,x25,x2,x61,x55,x32,x52,x29,x50,x12 # FROM t61,t9,t20,t63,t54,t32,t22,t52,t25,t47,t29,t12,t18,t10,t21,t43,t37,t2,t55,t3,t38,t50,t30,t8 @@ -1636,20 +1665,20 @@ project ( % .plan # table_name % rel # name % clob # type -% 375 # length +% 212 # length project ( | join ( | | join ( -| | | crossproduct ( -| | | | crossproduct ( -| | | | | crossproduct ( -| | | | | | crossproduct ( -| | | | | | | crossproduct ( -| | | | | | | | crossproduct ( -| | | | | | | | | crossproduct ( -| | | | | | | | | | crossproduct ( -| | | | | | | | | | | crossproduct ( -| | | | | | | | | | | | crossproduct ( +| | | join ( +| | | | join ( +| | | | | join ( +| | | | | | join ( +| | | | | | | join ( +| | | | | | | | join ( +| | | | | | | | | join ( +| | | | | | | | | | join ( +| | | | | | | | | | | join ( +| | | | | | | | | | | | join ( | | | | | | | | | | | | | join ( | | | | | | | | | | | | | | join ( | | | | | | | | | | | | | | | join ( @@ -1686,31 +1715,60 @@ project ( | | | | | | | | | | | | | | ) [ t47.a47 NOT NULL HASHCOL = t37.b37 ], | | | | | | | | | | | | | | table(sys.t54) [ t54.a54 NOT NULL HASHCOL , t54.b54, t54.x54 ] COUNT | | | | | | | | | | | | | ) [ t37.a37 NOT NULL HASHCOL = t54.b54 ], -| | | | | | | | | | | | | table(sys.t50) [ t50.a50 NOT NULL HASHCOL , t50.b50, t50.x50 ] COUNT -| | | | | | | | | | | | ) [ ], -| | | | | | | | | | | | table(sys.t30) [ t30.a30 NOT NULL HASHCOL , t30.b30, t30.x30 ] COUNT -| | | | | | | | | | | ) [ ], +| | | | | | | | | | | | | table(sys.t8) [ t8.a8 NOT NULL HASHCOL , t8.b8, t8.x8 ] COUNT +| | | | | | | | | | | | ) [ t54.a54 NOT NULL HASHCOL = t8.b8 ], +| | | | | | | | | | | | table(sys.t20) [ t20.a20 NOT NULL HASHCOL , t20.b20, t20.x20 ] COUNT +| | | | | | | | | | | ) [ t8.a8 NOT NULL HASHCOL = t20.b20 ], | | | | | | | | | | | table(sys.t55) [ t55.a55 NOT NULL HASHCOL , t55.b55, t55.x55 ] COUNT -| | | | | | | | | | ) [ ], -| | | | | | | | | | table(sys.t21) [ t21.a21 NOT NULL HASHCOL , t21.b21, t21.x21 ] COUNT -| | | | | | | | | ) [ ], -| | | | | | | | | table(sys.t32) [ t32.a32 NOT NULL HASHCOL , t32.b32, t32.x32 ] COUNT -| | | | | | | | ) [ ], -| | | | | | | | table(sys.t63) [ t63.a63 NOT NULL HASHCOL , t63.b63, t63.x63 ] COUNT -| | | | | | | ) [ ], -| | | | | | | table(sys.t9) [ t9.a9 NOT NULL HASHCOL , t9.b9, t9.x9 ] COUNT -| | | | | | ) [ ], -| | | | | | table(sys.t20) [ t20.a20 NOT NULL HASHCOL , t20.b20, t20.x20 ] COUNT -| | | | | ) [ ], +| | | | | | | | | | ) [ t20.a20 NOT NULL HASHCOL = t55.b55 ], +| | | | | | | | | | table(sys.t9) [ t9.a9 NOT NULL HASHCOL , t9.b9, t9.x9 ] COUNT +| | | | | | | | | ) [ t55.a55 NOT NULL HASHCOL = t9.b9 ], +| | | | | | | | | table(sys.t30) [ t30.a30 NOT NULL HASHCOL , t30.b30, t30.x30 ] COUNT +| | | | | | | | ) [ t30.b30 = t9.a9 NOT NULL HASHCOL ], +| | | | | | | | table(sys.t32) [ t32.a32 NOT NULL HASHCOL , t32.b32, t32.x32 ] COUNT +| | | | | | | ) [ t32.b32 = t30.a30 NOT NULL HASHCOL ], +| | | | | | | table(sys.t22) [ t22.a22 NOT NULL HASHCOL , t22.b22, t22.x22 ] COUNT +| | | | | | ) [ t22.b22 = t32.a32 NOT NULL HASHCOL ], +| | | | | | table(sys.t43) [ t43.a43 NOT NULL HASHCOL , t43.b43, t43.x43 ] COUNT +| | | | | ) [ t22.a22 NOT NULL HASHCOL = t43.b43 ], | | | | | table(sys.t29) [ t29.a29 NOT NULL HASHCOL , t29.b29, t29.x29 ] COUNT -| | | | ) [ ], -| | | | table(sys.t22) [ t22.a22 NOT NULL HASHCOL , t22.b22, t22.x22 ] COUNT -| | | ) [ ], -| | | table(sys.t43) [ t43.a43 NOT NULL HASHCOL , t43.b43, t43.x43 ] COUNT -| | ) [ t32.b32 = t30.a30 NOT NULL HASHCOL , t30.b30 = t9.a9 NOT NULL HASHCOL , t21.a21 NOT NULL HASHCOL = t50.b50, t50.a50 NOT NULL HASHCOL = t63.b63, t20.a20 NOT NULL HASHCOL = t55.b55, t55.a55 NOT NULL HASHCOL = t9.b9, t43.a43 NOT NULL HASHCOL = t29.b29, t22.a22 NOT NULL HASHCOL = t43.b43, t29.a29 NOT NULL HASHCOL = t21.b21, t22.b22 = t32.a32 NOT NULL HASHCOL ], -| | table(sys.t8) [ t8.a8 NOT NULL HASHCOL , t8.b8, t8.x8 ] COUNT -| ) [ t54.a54 NOT NULL HASHCOL = t8.b8, t8.a8 NOT NULL HASHCOL = t20.b20 ] +| | | | ) [ t43.a43 NOT NULL HASHCOL = t29.b29 ], +| | | | table(sys.t21) [ t21.a21 NOT NULL HASHCOL , t21.b21, t21.x21 ] COUNT +| | | ) [ t29.a29 NOT NULL HASHCOL = t21.b21 ], +| | | table(sys.t50) [ t50.a50 NOT NULL HASHCOL , t50.b50, t50.x50 ] COUNT +| | ) [ t21.a21 NOT NULL HASHCOL = t50.b50 ], +| | table(sys.t63) [ t63.b63, t63.x63 ] COUNT +| ) [ t50.a50 NOT NULL HASHCOL = t63.b63 ] ) [ t20.x20, t47.x47, t38.x38, t18.x18, t10.x10, t22.x22, t37.x37, t3.x3, t63.x63, t8.x8, t30.x30, t43.x43, t54.x54, t9.x9, t21.x21, t25.x25, t2.x2, t61.x61, t55.x55, t32.x32, t52.x52, t29.x29, t50.x50, t12.x12 ] +#SELECT x20,x47,x38,x18,x10,x22,x37,x3,x63,x8,x30,x43,x54,x9,x21,x25,x2,x61,x55,x32,x52,x29,x50,x12 +# FROM t61,t9,t20,t63,t54,t32,t22,t52,t25,t47,t29,t12,t18,t10,t21,t43,t37,t2,t55,t3,t38,t50,t30,t8 +# WHERE b3=a18 +# AND a25=b38 +# AND a54=b8 +# AND a61=b47 +# AND a43=b29 +# AND b18=a12 +# AND b32=a30 +# AND a22=b43 +# AND a29=b21 +# AND a10=b25 +# AND a12=4 +# AND b22=a32 +# AND a20=b55 +# AND b30=a9 +# AND a2=b61 +# AND a38=b52 +# AND a55=b9 +# AND a21=b50 +# AND a37=b54 +# AND b10=a3 +# AND a52=b2 +# AND a50=b63 +% sys.t20, sys.t47, sys.t38, sys.t18, sys.t10, sys.t22, sys.t37, sys.t3, sys.t63, sys.t8, sys.t30, sys.t43, sys.t54, sys.t9, sys.t21, sys.t25, sys.t2, sys.t61, sys.t55, sys.t32, sys.t52, sys.t29, sys.t50, sys.t12 # table_name +% x20, x47, x38, x18, x10, x22, x37, x3, x63, x8, x30, x43, x54, x9, x21, x25, x2, x61, x55, x32, x52, x29, x50, x12 # name +% varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar # type +% 15, 16, 15, 16, 15, 15, 15, 14, 15, 14, 15, 15, 15, 14, 15, 15, 15, 15, 15, 15, 15, 16, 15, 15 # length +[ "table t20 row 5", "table t47 row 10", "table t38 row 5", "table t18 row 10", "table t10 row 1", "table t22 row 2", "table t37 row 9", "table t3 row 8", "table t63 row 3", "table t8 row 6", "table t30 row 6", "table t43 row 1", "table t54 row 4", "table t9 row 4", "table t21 row 8", "table t25 row 4", "table t2 row 10", "table t61 row 8", "table t55 row 5", "table t32 row 3", "table t52 row 1", "table t29 row 10", "table t50 row 1", "table t12 row 4" ] #plan #SELECT x20,x47,x38,x18,x10,x22,x37,x3,x63,x8,x30,x43,x54,x9,x21,x25,x2,x61,x55,x32,x52,x29,x50,x12 # FROM t2,t3,t8,t9,t10,t12,t18,t20,t21,t22,t25,t29,t30,t32,t37,t38,t43,t47,t50,t52,t54,t55,t61,t63 @@ -1814,6 +1872,35 @@ project ( | | table(sys.t63) [ t63.b63, t63.x63 ] COUNT | ) [ t50.a50 NOT NULL HASHCOL = t63.b63 ] ) [ t20.x20, t47.x47, t38.x38, t18.x18, t10.x10, t22.x22, t37.x37, t3.x3, t63.x63, t8.x8, t30.x30, t43.x43, t54.x54, t9.x9, t21.x21, t25.x25, t2.x2, t61.x61, t55.x55, t32.x32, t52.x52, t29.x29, t50.x50, t12.x12 ] +#SELECT x20,x47,x38,x18,x10,x22,x37,x3,x63,x8,x30,x43,x54,x9,x21,x25,x2,x61,x55,x32,x52,x29,x50,x12 +# FROM t2,t3,t8,t9,t10,t12,t18,t20,t21,t22,t25,t29,t30,t32,t37,t38,t43,t47,t50,t52,t54,t55,t61,t63 +# WHERE b3=a18 +# AND a25=b38 +# AND a54=b8 +# AND a61=b47 +# AND a43=b29 +# AND b18=a12 +# AND b32=a30 +# AND a22=b43 +# AND a29=b21 +# AND a10=b25 +# AND a12=4 +# AND b22=a32 +# AND a20=b55 +# AND b30=a9 +# AND a2=b61 +# AND a38=b52 +# AND a55=b9 +# AND a21=b50 +# AND a37=b54 +# AND b10=a3 +# AND a52=b2 +# AND a50=b63 +% sys.t20, sys.t47, sys.t38, sys.t18, sys.t10, sys.t22, sys.t37, sys.t3, sys.t63, sys.t8, sys.t30, sys.t43, sys.t54, sys.t9, sys.t21, sys.t25, sys.t2, sys.t61, sys.t55, sys.t32, sys.t52, sys.t29, sys.t50, sys.t12 # table_name +% x20, x47, x38, x18, x10, x22, x37, x3, x63, x8, x30, x43, x54, x9, x21, x25, x2, x61, x55, x32, x52, x29, x50, x12 # name +% varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar, varchar # type +% 15, 16, 15, 16, 15, 15, 15, 14, 15, 14, 15, 15, 15, 14, 15, 15, 15, 15, 15, 15, 15, 16, 15, 15 # length +[ "table t20 row 5", "table t47 row 10", "table t38 row 5", "table t18 row 10", "table t10 row 1", "table t22 row 2", "table t37 row 9", "table t3 row 8", "table t63 row 3", "table t8 row 6", "table t30 row 6", "table t43 row 1", "table t54 row 4", "table t9 row 4", "table t21 row 8", "table t25 row 4", "table t2 row 10", "table t61 row 8", "table t55 row 5", "table t32 row 3", "table t52 row 1", "table t29 row 10", "table t50 row 1", "table t12 row 4" ] #plan #SELECT x20,x47,x38,x18,x10,x22,x37,x3,x63,x8,x30,x43,x54,x9,x21,x25,x2,x61,x55,x32,x52,x29,x50,x12 # FROM t63,t61,t55,t54,t52,t50,t47,t43,t38,t37,t32,t30,t29,t25,t22,t21,t20,t18,t12,t10,t9,t8,t3,t2 @@ -1842,26 +1929,25 @@ project ( % .plan # table_name % rel # name % clob # type -% 555 # length +% 212 # length project ( | join ( -| | table(sys.t2) [ t2.a2 NOT NULL HASHCOL , t2.b2, t2.x2 ] COUNT , | | join ( _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
