Changeset: 22419d3d2f20 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=22419d3d2f20
Modified Files:
sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128
sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
sql/benchmarks/tpch/Tests/02-explain.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
sql/benchmarks/tpch/Tests/04-explain.stable.out
sql/benchmarks/tpch/Tests/05-explain.stable.out.int128
sql/benchmarks/tpch/Tests/06-explain.stable.out.int128
sql/benchmarks/tpch/Tests/07-explain.stable.out.int128
sql/benchmarks/tpch/Tests/08-explain.stable.out.int128
sql/benchmarks/tpch/Tests/09-explain.stable.out.int128
sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
sql/benchmarks/tpch/Tests/12-explain.stable.out.int128
sql/benchmarks/tpch/Tests/13-explain.stable.out
sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/14-explain.stable.out.int128
sql/benchmarks/tpch/Tests/15-explain.stable.out.int128
sql/benchmarks/tpch/Tests/16-explain.stable.out
sql/benchmarks/tpch/Tests/17-explain.stable.out.int128
sql/benchmarks/tpch/Tests/18-explain.stable.out.int128
sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
sql/benchmarks/tpch/Tests/20-explain.stable.out.int128
sql/benchmarks/tpch/Tests/21-explain.stable.out
sql/benchmarks/tpch/Tests/22-explain.stable.out.int128
sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out
sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128
sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out
sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.stable.err
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
Branch: jit
Log Message:
Approve output
diffs (truncated from 3265 to 300 lines):
diff --git a/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
@@ -37,7 +37,7 @@ Ready.
% mal # name
% clob # type
% 254 # length
-function user.s2_1():void;
+function user.s4_1():void;
X_48:void := querylog.define("explain\nselect
sum(lo_extendedprice*lo_discount) as revenue\n from lineorder, dwdate\n where
lo_orderdate = d_datekey\n and d_year = 1993\n and lo_discount between 1 and
3\n and lo_quantity < 25;","sequential_pipe",24);
X_5 := sql.mvc();
X_9:bat[:int] := sql.bind(X_5,"sys","lineorder","lo_quantity",0);
@@ -60,7 +60,32 @@ function user.s2_1():void;
X_40:bat[:lng] := batcalc.*(X_38,X_39);
X_41:hge := aggr.sum(X_40);
sql.resultSet("sys.L1","revenue","hugeint",128,0,7,X_41);
-end user.s2_1;
+end user.s4_1;
+#inline actions= 0 time=9 usec
+#candidates actions= 1 time=71 usec
+#remap actions= 1 time=166 usec
+#costModel actions= 1 time=66 usec
+#coercions actions= 0 time=6 usec
+#evaluate actions= 4 time=108 usec
+#emptybind actions= 0 time=8 usec
+#pushselect actions= 9 time=103 usec
+#aliases actions=14 time=75 usec
+#mergetable actions= 0 time=79 usec
+#deadcode actions= 9 time=63 usec
+#aliases actions= 0 time=14 usec
+#constants actions= 8 time=71 usec
+#commonTerms actions= 0 time=13 usec
+#projectionpath actions= 2 time=61 usec
+#reorder actions= 1 time=90 usec
+#deadcode actions= 2 time=52 usec
+#reduce actions=63 time=90 usec
+#matpack actions= 0 time=7 usec
+#querylog actions= 0 time=2 usec
+#multiplex actions= 0 time=6 usec
+#generator actions= 0 time=3 usec
+#profiler actions= 1 time=49 usec
+#garbageCollector actions= 1 time=56 usec
+#total actions= 1 time=1422 usec
# 23:10:45 >
# 23:10:45 > "Done."
diff --git a/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
@@ -37,7 +37,7 @@ Ready.
% mal # name
% clob # type
% 277 # length
-function user.s2_1():void;
+function user.s4_1():void;
X_49:void := querylog.define("explain\nselect
sum(lo_extendedprice*lo_discount) as revenue\n from lineorder, dwdate\n where
lo_orderdate = d_datekey\n and d_yearmonthnum = 199401\n and lo_discount
between 4 and 6\n and lo_quantity between 26 and 35;","sequential_pipe",24);
X_6 := sql.mvc();
X_10:bat[:int] := sql.bind(X_6,"sys","lineorder","lo_quantity",0);
@@ -60,7 +60,32 @@ function user.s2_1():void;
X_41:bat[:lng] := batcalc.*(X_39,X_40);
X_42:hge := aggr.sum(X_41);
sql.resultSet("sys.L1","revenue","hugeint",128,0,7,X_42);
-end user.s2_1;
+end user.s4_1;
+#inline actions= 0 time=6 usec
+#candidates actions= 1 time=56 usec
+#remap actions= 1 time=144 usec
+#costModel actions= 1 time=57 usec
+#coercions actions= 0 time=4 usec
+#evaluate actions= 5 time=86 usec
+#emptybind actions= 0 time=7 usec
+#pushselect actions= 9 time=80 usec
+#aliases actions=15 time=59 usec
+#mergetable actions= 0 time=61 usec
+#deadcode actions= 9 time=49 usec
+#aliases actions= 0 time=10 usec
+#constants actions= 8 time=55 usec
+#commonTerms actions= 0 time=10 usec
+#projectionpath actions= 2 time=43 usec
+#reorder actions= 1 time=67 usec
+#deadcode actions= 2 time=43 usec
+#reduce actions=64 time=73 usec
+#matpack actions= 0 time=6 usec
+#querylog actions= 0 time=1 usec
+#multiplex actions= 0 time=5 usec
+#generator actions= 0 time=3 usec
+#profiler actions= 1 time=39 usec
+#garbageCollector actions= 1 time=47 usec
+#total actions= 1 time=1123 usec
# 23:10:45 >
# 23:10:45 > "Done."
diff --git a/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
@@ -37,7 +37,7 @@ Ready.
% mal # name
% clob # type
% 291 # length
-function user.s2_1():void;
+function user.s4_1():void;
X_52:void := querylog.define("explain\nselect
sum(lo_extendedprice*lo_discount) as revenue\n from lineorder, dwdate\n where
lo_orderdate = d_datekey\n and d_weeknuminyear = 6 and d_year = 1994\n and
lo_discount between 5 and 7\n and lo_quantity between 36 and
40;","sequential_pipe",26);
X_7 := sql.mvc();
X_11:bat[:int] := sql.bind(X_7,"sys","lineorder","lo_quantity",0);
@@ -62,7 +62,32 @@ function user.s2_1():void;
X_45:bat[:lng] := batcalc.*(X_43,X_44);
X_46:hge := aggr.sum(X_45);
sql.resultSet("sys.L1","revenue","hugeint",128,0,7,X_46);
-end user.s2_1;
+end user.s4_1;
+#inline actions= 0 time=6 usec
+#candidates actions= 1 time=52 usec
+#remap actions= 1 time=132 usec
+#costModel actions= 1 time=61 usec
+#coercions actions= 0 time=4 usec
+#evaluate actions= 6 time=86 usec
+#emptybind actions= 0 time=6 usec
+#pushselect actions=10 time=78 usec
+#aliases actions=18 time=58 usec
+#mergetable actions= 0 time=59 usec
+#deadcode actions=11 time=46 usec
+#aliases actions= 0 time=10 usec
+#constants actions=11 time=54 usec
+#commonTerms actions= 0 time=10 usec
+#projectionpath actions= 2 time=44 usec
+#reorder actions= 1 time=65 usec
+#deadcode actions= 2 time=40 usec
+#reduce actions=74 time=71 usec
+#matpack actions= 0 time=6 usec
+#querylog actions= 0 time=1 usec
+#multiplex actions= 0 time=5 usec
+#generator actions= 0 time=2 usec
+#profiler actions= 1 time=39 usec
+#garbageCollector actions= 1 time=45 usec
+#total actions= 1 time=1081 usec
# 23:10:45 >
# 23:10:45 > "Done."
diff --git a/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
@@ -40,7 +40,7 @@ Ready.
% mal # name
% clob # type
% 362 # length
-function user.s2_1():void;
+function user.s4_1():void;
X_112:void := querylog.define("explain\nselect sum(lo_revenue), d_year,
p_brand1\n from lineorder, dwdate, part, supplier\n where lo_orderdate =
d_datekey\n and lo_partkey = p_partkey\n and lo_suppkey = s_suppkey\n and
p_category = \\'MFGR#12\\' \n and s_region = \\'AMERICA\\'\n group by d_year,
p_brand1\n order by d_year, p_brand1;","sequential_pipe",66);
X_80 := bat.new(nil:oid,nil:str);
X_88 := bat.append(X_80,"sys.L1");
@@ -105,7 +105,32 @@ function user.s2_1():void;
X_77 := algebra.projection(r1_106,X_65);
X_78 := algebra.projection(r1_106,X_64);
sql.resultSet(X_105,X_107,X_108,X_110,X_111,X_76,X_77,X_78);
-end user.s2_1;
+end user.s4_1;
+#inline actions= 0 time=3 usec
+#candidates actions= 1 time=46 usec
+#remap actions= 0 time=4 usec
+#costModel actions= 1 time=41 usec
+#coercions actions= 0 time=4 usec
+#evaluate actions= 2 time=62 usec
+#emptybind actions= 0 time=5 usec
+#pushselect actions=10 time=64 usec
+#aliases actions=12 time=46 usec
+#mergetable actions= 0 time=50 usec
+#deadcode actions=13 time=39 usec
+#aliases actions= 0 time=11 usec
+#constants actions=15 time=48 usec
+#commonTerms actions= 0 time=12 usec
+#projectionpath actions= 8 time=40 usec
+#reorder actions= 1 time=70 usec
+#deadcode actions= 8 time=36 usec
+#reduce actions=76 time=65 usec
+#matpack actions= 0 time=4 usec
+#querylog actions= 0 time=1 usec
+#multiplex actions= 0 time=4 usec
+#generator actions= 0 time=2 usec
+#profiler actions= 1 time=31 usec
+#garbageCollector actions= 1 time=38 usec
+#total actions= 1 time=791 usec
# 23:10:46 >
# 23:10:46 > "Done."
diff --git a/sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
@@ -42,7 +42,7 @@ Ready.
% mal # name
% clob # type
% 390 # length
-function user.s2_1():void;
+function user.s4_1():void;
X_111:void := querylog.define("explain\nselect sum(lo_revenue), d_year,
p_brand1\n from lineorder, dwdate, part, supplier\n where lo_orderdate =
d_datekey\n and lo_partkey = p_partkey\n and lo_suppkey = s_suppkey\n \n \n and
p_brand1 between \\'MFGR#2221\\' and \\'MFGR#2228\\'\n and s_region =
\\'ASIA\\'\n group by d_year, p_brand1\n order by d_year,
p_brand1;","sequential_pipe",65);
X_79 := bat.new(nil:oid,nil:str);
X_87 := bat.append(X_79,"sys.L1");
@@ -106,7 +106,32 @@ function user.s2_1():void;
X_76 := algebra.projection(r1_101,X_64);
X_77 := algebra.projection(r1_101,X_63);
sql.resultSet(X_104,X_106,X_107,X_109,X_110,X_75,X_76,X_77);
-end user.s2_1;
+end user.s4_1;
+#inline actions= 0 time=7 usec
+#candidates actions= 1 time=100 usec
+#remap actions= 0 time=9 usec
+#costModel actions= 1 time=89 usec
+#coercions actions= 0 time=8 usec
+#evaluate actions= 3 time=138 usec
+#emptybind actions= 0 time=10 usec
+#pushselect actions= 9 time=158 usec
+#aliases actions=11 time=101 usec
+#mergetable actions= 0 time=111 usec
+#deadcode actions=11 time=87 usec
+#aliases actions= 0 time=24 usec
+#constants actions=14 time=108 usec
+#commonTerms actions= 0 time=25 usec
+#projectionpath actions= 8 time=90 usec
+#reorder actions= 1 time=144 usec
+#deadcode actions= 8 time=77 usec
+#reduce actions=70 time=156 usec
+#matpack actions= 0 time=10 usec
+#querylog actions= 0 time=2 usec
+#multiplex actions= 0 time=8 usec
+#generator actions= 0 time=4 usec
+#profiler actions= 1 time=66 usec
+#garbageCollector actions= 1 time=85 usec
+#total actions= 1 time=1766 usec
# 23:10:46 >
# 23:10:46 > "Done."
diff --git a/sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
@@ -42,7 +42,7 @@ Ready.
% mal # name
% clob # type
% 366 # length
-function user.s2_1():void;
+function user.s4_1():void;
X_110:void := querylog.define("explain\nselect sum(lo_revenue), d_year,
p_brand1\n from lineorder, dwdate, part, supplier\n where lo_orderdate =
d_datekey\n and lo_partkey = p_partkey\n and lo_suppkey = s_suppkey\n \n \n and
p_brand1 = \\'MFGR#2221\\'\n and s_region = \\'EUROPE\\'\n group by d_year,
p_brand1\n order by d_year, p_brand1;","sequential_pipe",65);
X_78 := bat.new(nil:oid,nil:str);
X_86 := bat.append(X_78,"sys.L1");
@@ -106,7 +106,32 @@ function user.s2_1():void;
X_75 := algebra.projection(r1_99,X_63);
X_76 := algebra.projection(r1_99,X_62);
sql.resultSet(X_103,X_105,X_106,X_108,X_109,X_74,X_75,X_76);
-end user.s2_1;
+end user.s4_1;
+#inline actions= 0 time=5 usec
+#candidates actions= 1 time=73 usec
+#remap actions= 0 time=7 usec
+#costModel actions= 1 time=65 usec
+#coercions actions= 0 time=6 usec
+#evaluate actions= 2 time=105 usec
+#emptybind actions= 0 time=8 usec
+#pushselect actions= 9 time=99 usec
+#aliases actions=10 time=72 usec
+#mergetable actions= 0 time=82 usec
+#deadcode actions=11 time=63 usec
+#aliases actions= 0 time=17 usec
+#constants actions=13 time=77 usec
+#commonTerms actions= 0 time=17 usec
+#projectionpath actions= 8 time=65 usec
+#reorder actions= 1 time=105 usec
+#deadcode actions= 8 time=56 usec
+#reduce actions=68 time=105 usec
+#matpack actions= 0 time=6 usec
+#querylog actions= 0 time=1 usec
+#multiplex actions= 0 time=6 usec
+#generator actions= 0 time=3 usec
+#profiler actions= 1 time=50 usec
+#garbageCollector actions= 1 time=69 usec
+#total actions= 1 time=1266 usec
# 23:10:46 >
# 23:10:46 > "Done."
diff --git a/sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
@@ -41,7 +41,7 @@ Ready.
% mal # name
% clob # type
% 436 # length
-function user.s2_1():void;
+function user.s4_1():void;
X_126:void := querylog.define("explain\nselect c_nation, s_nation, d_year,
sum(lo_revenue) as revenue\n from customer, lineorder, supplier, dwdate\n where
lo_custkey = c_custkey\n and lo_suppkey = s_suppkey\n and lo_orderdate =
d_datekey\n and c_region = \\'ASIA\\'\n and s_region = \\'ASIA\\'\n and d_year
>= 1992 and d_year <= 1997\n group by c_nation, s_nation, d_year\n order by
d_year asc, revenue desc;","sequential_pipe",75);
X_88 := bat.new(nil:oid,nil:str);
X_96 := bat.append(X_88,"sys.customer");
@@ -115,7 +115,32 @@ function user.s2_1():void;
X_85 := algebra.projection(r1_142,X_76);
X_86 := algebra.projection(r1_142,X_75);
sql.resultSet(X_117,X_119,X_121,X_123,X_125,X_83,X_84,X_85,X_86);
-end user.s2_1;
+end user.s4_1;
+#inline actions= 0 time=3 usec
+#candidates actions= 1 time=53 usec
+#remap actions= 0 time=5 usec
+#costModel actions= 1 time=46 usec
+#coercions actions= 0 time=5 usec
+#evaluate actions= 4 time=71 usec
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
