Changeset: 25735113e9c8 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=25735113e9c8 Modified Files: monetdb5/modules/mal/Tests/inspect05.stable.out sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out sql/benchmarks/tpch/LOCKED/Tests/01.stable.out sql/benchmarks/tpch/LOCKED/Tests/04.stable.out sql/benchmarks/tpch/LOCKED/Tests/13.stable.out sql/benchmarks/tpch/LOCKED/Tests/16.stable.out sql/benchmarks/tpch/LOCKED/Tests/21.stable.out sql/benchmarks/tpch/LOCKED/Tests/22.stable.out sql/test/Tests/median_stdev.stable.out Branch: no-wrd Log Message:
Approvals. diffs (160 lines): diff --git a/monetdb5/modules/mal/Tests/inspect05.stable.out b/monetdb5/modules/mal/Tests/inspect05.stable.out --- a/monetdb5/modules/mal/Tests/inspect05.stable.out +++ b/monetdb5/modules/mal/Tests/inspect05.stable.out @@ -34,7 +34,7 @@ Ready. [ 2@0, "append", "command", "bat", "(i:bat[:any_1],u:any_1,force:bit):bat[:any_1] ", "BKCappend_val_force_wrap;" ] [ 3@0, "append", "command", "bat", "(i:bat[:any_1],u:bat[:any_1],force:bit):bat[:any_1] ", "BKCappend_force_wrap;" ] [ 4@0, "attach", "command", "bat", "(i:bat[:any_1],u:bat[:any_1]):bat[:any_1] ", "BKCappend_wrap;" ] -[ 5@0, "delete", "command", "bat", "(sz:wrd):bat[:oid] ", "BKCdensebat;" ] +[ 5@0, "delete", "command", "bat", "(sz:lng):bat[:oid] ", "BKCdensebat;" ] [ 6@0, "delete", "command", "bat", "(b:bat[:any_1]):bat[:any_1] ", "BKCdelete_all;" ] [ 7@0, "delete", "command", "bat", "(b:bat[:any_1],d:bat[:oid]):bat[:any_1] ", "BKCdelete_multi;" ] [ 8@0, "densebat", "command", "bat", "(b:bat[:any_1],h:oid):bat[:any_1] ", "BKCdelete;" ] diff --git a/sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out b/sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out --- a/sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out +++ b/sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out @@ -51,7 +51,7 @@ Ready. # l_linestatus; % sys.lineitem, sys.lineitem, sys.L1, sys.L2, sys.L3, sys.L4, sys.L5, sys.L6, sys.L7, sys.L10 # table_name % l_returnflag, l_linestatus, sum_qty, sum_base_price, sum_disc_price, sum_charge, avg_qty, avg_price, avg_disc, count_order # name -% char, char, decimal, decimal, decimal, decimal, double, double, double, wrd # type +% char, char, decimal, decimal, decimal, decimal, double, double, double, bigint # type % 1, 1, 21, 21, 21, 21, 24, 24, 24, 5 # length [ "A", "F", 380456.00, 532348211.65, 505822441.4861, 526165934.000839, 25.57515461, 35785.70931, 0.05008133907, 14876 ] [ "N", "F", 8971.00, 12384801.37, 11798257.2080, 12282485.056933, 25.77873563, 35588.50968, 0.04775862069, 348 ] @@ -157,7 +157,7 @@ Ready. # o_orderpriority; % sys.orders, sys.L1 # table_name % o_orderpriority, order_count # name -% char, wrd # type +% char, bigint # type % 15, 3 # length [ "1-URGENT", 93 ] [ "2-HIGH", 103 ] @@ -716,7 +716,7 @@ Ready. # c_count desc; % .c_orders, .L2 # table_name % c_count, custdist # name -% wrd, wrd # type +% bigint, bigint # type % 2, 3 # length [ 0, 500 ] [ 11, 68 ] @@ -838,7 +838,7 @@ Ready. # p_size; % sys.part, sys.part, sys.part, sys.L4 # table_name % p_brand, p_type, p_size, supplier_cnt # name -% char, varchar, int, wrd # type +% char, varchar, int, bigint # type % 10, 25, 2, 1 # length [ "Brand#14", "PROMO BRUSHED STEEL", 9, 8 ] [ "Brand#35", "SMALL POLISHED COPPER", 14, 8 ] @@ -1312,7 +1312,7 @@ Ready. # and l3.l_receiptdate > l3.l_commitdate % sys.supplier, sys.L1 # table_name % s_name, numwait # name -% char, wrd # type +% char, bigint # type % 25, 1 # length [ "Supplier#000000074", 9 ] % .stats, .stats # table_name @@ -1355,7 +1355,7 @@ Ready. # from % sys.custsale, sys.L2, sys.L3 # table_name % cntrycode, numcust, totacctbal # name -% char, wrd, decimal # type +% char, bigint, decimal # type % 15, 2, 21 # length [ "13", 10, 75359.29 ] [ "17", 8, 62288.98 ] diff --git a/sql/benchmarks/tpch/LOCKED/Tests/01.stable.out b/sql/benchmarks/tpch/LOCKED/Tests/01.stable.out --- a/sql/benchmarks/tpch/LOCKED/Tests/01.stable.out +++ b/sql/benchmarks/tpch/LOCKED/Tests/01.stable.out @@ -50,7 +50,7 @@ Ready. # l_linestatus; % sys.lineitem, sys.lineitem, sys.L1, sys.L2, sys.L3, sys.L4, sys.L5, sys.L6, sys.L7, sys.L10 # table_name % l_returnflag, l_linestatus, sum_qty, sum_base_price, sum_disc_price, sum_charge, avg_qty, avg_price, avg_disc, count_order # name -% char, char, decimal, decimal, decimal, decimal, double, double, double, wrd # type +% char, char, decimal, decimal, decimal, decimal, double, double, double, bigint # type % 1, 1, 21, 21, 21, 21, 24, 24, 24, 5 # length [ "A", "F", 380456.00, 532348211.65, 505822441.4861, 526165934.000839, 25.57515461, 35785.70931, 0.05008133907, 14876 ] [ "N", "F", 8971.00, 12384801.37, 11798257.2080, 12282485.056933, 25.77873563, 35588.50968, 0.04775862069, 348 ] diff --git a/sql/benchmarks/tpch/LOCKED/Tests/04.stable.out b/sql/benchmarks/tpch/LOCKED/Tests/04.stable.out --- a/sql/benchmarks/tpch/LOCKED/Tests/04.stable.out +++ b/sql/benchmarks/tpch/LOCKED/Tests/04.stable.out @@ -50,7 +50,7 @@ Ready. # o_orderpriority; % sys.orders, sys.L1 # table_name % o_orderpriority, order_count # name -% char, wrd # type +% char, bigint # type % 15, 3 # length [ "1-URGENT", 93 ] [ "2-HIGH", 103 ] diff --git a/sql/benchmarks/tpch/LOCKED/Tests/13.stable.out b/sql/benchmarks/tpch/LOCKED/Tests/13.stable.out --- a/sql/benchmarks/tpch/LOCKED/Tests/13.stable.out +++ b/sql/benchmarks/tpch/LOCKED/Tests/13.stable.out @@ -49,7 +49,7 @@ Ready. # c_count desc; % .c_orders, .L2 # table_name % c_count, custdist # name -% wrd, wrd # type +% bigint, bigint # type % 2, 3 # length [ 0, 500 ] [ 11, 68 ] diff --git a/sql/benchmarks/tpch/LOCKED/Tests/16.stable.out b/sql/benchmarks/tpch/LOCKED/Tests/16.stable.out --- a/sql/benchmarks/tpch/LOCKED/Tests/16.stable.out +++ b/sql/benchmarks/tpch/LOCKED/Tests/16.stable.out @@ -55,7 +55,7 @@ Ready. # p_size; % sys.part, sys.part, sys.part, sys.L4 # table_name % p_brand, p_type, p_size, supplier_cnt # name -% char, varchar, int, wrd # type +% char, varchar, int, bigint # type % 10, 25, 2, 1 # length [ "Brand#14", "PROMO BRUSHED STEEL", 9, 8 ] [ "Brand#35", "SMALL POLISHED COPPER", 14, 8 ] diff --git a/sql/benchmarks/tpch/LOCKED/Tests/21.stable.out b/sql/benchmarks/tpch/LOCKED/Tests/21.stable.out --- a/sql/benchmarks/tpch/LOCKED/Tests/21.stable.out +++ b/sql/benchmarks/tpch/LOCKED/Tests/21.stable.out @@ -60,7 +60,7 @@ Ready. # and l3.l_receiptdate > l3.l_commitdate % sys.supplier, sys.L1 # table_name % s_name, numwait # name -% char, wrd # type +% char, bigint # type % 25, 1 # length [ "Supplier#000000074", 9 ] % .stats, .stats # table_name diff --git a/sql/benchmarks/tpch/LOCKED/Tests/22.stable.out b/sql/benchmarks/tpch/LOCKED/Tests/22.stable.out --- a/sql/benchmarks/tpch/LOCKED/Tests/22.stable.out +++ b/sql/benchmarks/tpch/LOCKED/Tests/22.stable.out @@ -57,7 +57,7 @@ Ready. # from % sys.custsale, sys.L2, sys.L3 # table_name % cntrycode, numcust, totacctbal # name -% char, wrd, decimal # type +% char, bigint, decimal # type % 15, 2, 21 # length [ "13", 10, 75359.29 ] [ "17", 8, 62288.98 ] diff --git a/sql/test/Tests/median_stdev.stable.out b/sql/test/Tests/median_stdev.stable.out --- a/sql/test/Tests/median_stdev.stable.out +++ b/sql/test/Tests/median_stdev.stable.out @@ -85,11 +85,11 @@ Ready. % groupid, medianvalue # name % int, double # type % 1, 24 # length +[ 1, 6 ] +[ 2, 5 ] +[ 3, 34.5 ] +[ 4, 18 ] [ 5, 0 ] -[ 4, 18 ] -[ 3, 34.5 ] -[ 2, 5 ] -[ 1, 6 ] #SELECT R.groupID, sqrt(SUM((R.n-G.a)*(R.n-G.a))/count(*)) AS stdev #FROM #( SELECT GroupID, NumValue as n _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
