Changeset: 5f2955eb36b8 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5f2955eb36b8
Modified Files:
sql/benchmarks/tpch/LOCKED/Tests/01-22.stable.out
sql/benchmarks/tpch/LOCKED/Tests/12.stable.out
sql/benchmarks/tpch/LOCKED/Tests/16.stable.out
sql/benchmarks/tpch/LOCKED/Tests/18.stable.out
sql/benchmarks/tpch/LOCKED/Tests/19.stable.out
sql/benchmarks/tpch/LOCKED/Tests/22.stable.out
sql/benchmarks/tpch/Tests/01-22.stable.out
sql/benchmarks/tpch/Tests/12.stable.out
sql/benchmarks/tpch/Tests/16.stable.out
sql/benchmarks/tpch/Tests/18.stable.out
sql/benchmarks/tpch/Tests/19.stable.out
sql/benchmarks/tpch/Tests/22.stable.out
Branch: Jul2017
Log Message:
Approved after changeset fa09cb21a5c8.
diffs (168 lines):
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
@@ -1225,10 +1225,10 @@ Ready.
# select
# *
# from
-% sys.custsale, sys.L17, sys.L22 # table_name
+% sys.custsale, sys.L21, sys.L24 # table_name
% cntrycode, numcust, totacctbal # name
-% char, bigint, decimal # type
-% 15, 2, 20 # length
+% clob, bigint, decimal # type
+% 2, 2, 20 # length
[ "13", 10, 75359.29 ]
[ "17", 8, 62288.98 ]
[ "18", 14, 111072.45 ]
diff --git a/sql/benchmarks/tpch/LOCKED/Tests/12.stable.out
b/sql/benchmarks/tpch/LOCKED/Tests/12.stable.out
--- a/sql/benchmarks/tpch/LOCKED/Tests/12.stable.out
+++ b/sql/benchmarks/tpch/LOCKED/Tests/12.stable.out
@@ -52,7 +52,7 @@ Ready.
# and l_shipdate < l_commitdate
# and l_receiptdate >= date '1994-01-01'
# and l_receiptdate < date '1994-01-01' + interval '1' year
-% sys.lineitem, sys.L4, sys.L7 # table_name
+% sys.lineitem, sys.L6, sys.L11 # table_name
% l_shipmode, high_line_count, low_line_count # name
% char, bigint, bigint # type
% 10, 2, 2 # length
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
@@ -53,7 +53,7 @@ Ready.
# p_brand,
# p_type,
# p_size;
-% sys.part, sys.part, sys.part, sys.L15 # table_name
+% sys.part, sys.part, sys.part, sys.L13 # table_name
% p_brand, p_type, p_size, supplier_cnt # name
% char, varchar, int, bigint # type
% 10, 25, 2, 1 # length
diff --git a/sql/benchmarks/tpch/LOCKED/Tests/18.stable.out
b/sql/benchmarks/tpch/LOCKED/Tests/18.stable.out
--- a/sql/benchmarks/tpch/LOCKED/Tests/18.stable.out
+++ b/sql/benchmarks/tpch/LOCKED/Tests/18.stable.out
@@ -60,8 +60,8 @@ Ready.
# o_totalprice desc,
# o_orderdate
#limit 100;
-% sys.customer, sys.customer, sys.orders, sys.orders,
sys.orders, sys.L22 # table_name
-% c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice,
L21 # name
+% sys.customer, sys.customer, sys.orders, sys.orders,
sys.orders, sys.L17 # table_name
+% c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice,
L16 # name
% varchar, int, int, date, decimal, decimal # type
% 18, 3, 5, 10, 17, 20 # length
[ "Customer#000000667", 667, 29158, 1995-10-21, 439687.23,
305.00 ]
diff --git a/sql/benchmarks/tpch/LOCKED/Tests/19.stable.out
b/sql/benchmarks/tpch/LOCKED/Tests/19.stable.out
--- a/sql/benchmarks/tpch/LOCKED/Tests/19.stable.out
+++ b/sql/benchmarks/tpch/LOCKED/Tests/19.stable.out
@@ -49,7 +49,7 @@ Ready.
# and p_brand = 'Brand#23'
# and p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
# and l_quantity >= 10 and l_quantity <= 10 + 10
-% sys.L4 # table_name
+% sys.L33 # table_name
% revenue # name
% decimal # type
% 20 # length
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
@@ -55,10 +55,10 @@ Ready.
# select
# *
# from
-% sys.custsale, sys.L17, sys.L22 # table_name
+% sys.custsale, sys.L21, sys.L24 # table_name
% cntrycode, numcust, totacctbal # name
-% char, bigint, decimal # type
-% 15, 2, 20 # length
+% clob, bigint, decimal # type
+% 2, 2, 20 # length
[ "13", 10, 75359.29 ]
[ "17", 8, 62288.98 ]
[ "18", 14, 111072.45 ]
diff --git a/sql/benchmarks/tpch/Tests/01-22.stable.out
b/sql/benchmarks/tpch/Tests/01-22.stable.out
--- a/sql/benchmarks/tpch/Tests/01-22.stable.out
+++ b/sql/benchmarks/tpch/Tests/01-22.stable.out
@@ -1221,10 +1221,10 @@ Ready.
# select
# *
# from
-% sys.custsale, sys.L17, sys.L22 # table_name
+% sys.custsale, sys.L21, sys.L24 # table_name
% cntrycode, numcust, totacctbal # name
-% char, bigint, decimal # type
-% 15, 2, 20 # length
+% clob, bigint, decimal # type
+% 2, 2, 20 # length
[ "13", 10, 75359.29 ]
[ "17", 8, 62288.98 ]
[ "18", 14, 111072.45 ]
diff --git a/sql/benchmarks/tpch/Tests/12.stable.out
b/sql/benchmarks/tpch/Tests/12.stable.out
--- a/sql/benchmarks/tpch/Tests/12.stable.out
+++ b/sql/benchmarks/tpch/Tests/12.stable.out
@@ -52,7 +52,7 @@ Ready.
# and l_shipdate < l_commitdate
# and l_receiptdate >= date '1994-01-01'
# and l_receiptdate < date '1994-01-01' + interval '1' year
-% sys.lineitem, sys.L4, sys.L7 # table_name
+% sys.lineitem, sys.L6, sys.L11 # table_name
% l_shipmode, high_line_count, low_line_count # name
% char, bigint, bigint # type
% 10, 2, 2 # length
diff --git a/sql/benchmarks/tpch/Tests/16.stable.out
b/sql/benchmarks/tpch/Tests/16.stable.out
--- a/sql/benchmarks/tpch/Tests/16.stable.out
+++ b/sql/benchmarks/tpch/Tests/16.stable.out
@@ -53,7 +53,7 @@ Ready.
# p_brand,
# p_type,
# p_size;
-% sys.part, sys.part, sys.part, sys.L15 # table_name
+% sys.part, sys.part, sys.part, sys.L13 # table_name
% p_brand, p_type, p_size, supplier_cnt # name
% char, varchar, int, bigint # type
% 10, 25, 2, 1 # length
diff --git a/sql/benchmarks/tpch/Tests/18.stable.out
b/sql/benchmarks/tpch/Tests/18.stable.out
--- a/sql/benchmarks/tpch/Tests/18.stable.out
+++ b/sql/benchmarks/tpch/Tests/18.stable.out
@@ -60,8 +60,8 @@ Ready.
# o_totalprice desc,
# o_orderdate
#limit 100;
-% sys.customer, sys.customer, sys.orders, sys.orders,
sys.orders, sys.L22 # table_name
-% c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice,
L21 # name
+% sys.customer, sys.customer, sys.orders, sys.orders,
sys.orders, sys.L17 # table_name
+% c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice,
L16 # name
% varchar, int, int, date, decimal, decimal # type
% 18, 3, 5, 10, 17, 20 # length
[ "Customer#000000667", 667, 29158, 1995-10-21, 439687.23,
305.00 ]
diff --git a/sql/benchmarks/tpch/Tests/19.stable.out
b/sql/benchmarks/tpch/Tests/19.stable.out
--- a/sql/benchmarks/tpch/Tests/19.stable.out
+++ b/sql/benchmarks/tpch/Tests/19.stable.out
@@ -49,7 +49,7 @@ Ready.
# and p_brand = 'Brand#23'
# and p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
# and l_quantity >= 10 and l_quantity <= 10 + 10
-% sys.L4 # table_name
+% sys.L33 # table_name
% revenue # name
% decimal # type
% 20 # length
diff --git a/sql/benchmarks/tpch/Tests/22.stable.out
b/sql/benchmarks/tpch/Tests/22.stable.out
--- a/sql/benchmarks/tpch/Tests/22.stable.out
+++ b/sql/benchmarks/tpch/Tests/22.stable.out
@@ -55,10 +55,10 @@ Ready.
# select
# *
# from
-% sys.custsale, sys.L17, sys.L22 # table_name
+% sys.custsale, sys.L21, sys.L24 # table_name
% cntrycode, numcust, totacctbal # name
-% char, bigint, decimal # type
-% 15, 2, 20 # length
+% clob, bigint, decimal # type
+% 2, 2, 20 # length
[ "13", 10, 75359.29 ]
[ "17", 8, 62288.98 ]
[ "18", 14, 111072.45 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
