Changeset: e621d36a335b for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e621d36a335b
Added Files:
sql/test/BugTracker-2016/Tests/storagemodel.stable.out.int128
Modified Files:
sql/backends/monet5/UDF/cudf/Tests/udf-fuse.stable.out
sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out
sql/benchmarks/ssbm/Tests/01-explain.stable.out
sql/benchmarks/ssbm/Tests/02-explain.stable.out
sql/benchmarks/ssbm/Tests/03-explain.stable.out
sql/benchmarks/tpch/Tests/01-plan.stable.out
sql/benchmarks/tpch/Tests/03-plan.stable.out
sql/benchmarks/tpch/Tests/05-plan.stable.out
sql/benchmarks/tpch/Tests/06-explain.stable.out
sql/benchmarks/tpch/Tests/06-plan.stable.out
sql/benchmarks/tpch/Tests/07-plan.stable.out
sql/benchmarks/tpch/Tests/08-explain.stable.out
sql/benchmarks/tpch/Tests/08-plan.stable.out
sql/benchmarks/tpch/Tests/09-plan.stable.out
sql/benchmarks/tpch/Tests/10-plan.stable.out
sql/benchmarks/tpch/Tests/11-explain.stable.out
sql/benchmarks/tpch/Tests/11-plan.stable.out
sql/benchmarks/tpch/Tests/14-explain.stable.out
sql/benchmarks/tpch/Tests/14-plan.stable.out
sql/benchmarks/tpch/Tests/15-plan.stable.out
sql/benchmarks/tpch/Tests/17-explain.stable.out
sql/benchmarks/tpch/Tests/17-plan.stable.out
sql/benchmarks/tpch/Tests/19-explain.stable.out
sql/benchmarks/tpch/Tests/19-plan.stable.out
sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out
sql/test/BugDay_2005-10-06_2.9.3/Tests/max_min_sum_null.SF-1123132.stable.out
sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out
sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.stable.out
sql/test/BugTracker-2009/Tests/avg-bug.SF-2132666.stable.out
sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.out
sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.stable.out
sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out
sql/test/BugTracker-2011/Tests/non-stable-select-bug.Bug-2894.stable.out
sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out
sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out
sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out
sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.single
sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out
sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out
sql/test/BugTracker-2014/Tests/union_with_subqueries.Bug-3518.stable.out
sql/test/BugTracker-2015/Tests/incorrect_result_type.Bug-3687.stable.out
sql/test/BugTracker-2016/Tests/cast_and_floor.Bug-6071.sql
sql/test/BugTracker-2016/Tests/cast_and_floor.Bug-6071.stable.out
sql/test/BugTracker-2016/Tests/storagemodel.stable.out
sql/test/BugTracker-2016/Tests/storagemodel.stable.out.32bit
sql/test/BugTracker/Tests/case_with_aggr.SF-1876779.stable.out
sql/test/BugTracker/Tests/groupby_with_alias.SF-1520575.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit
sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out
sql/test/SQLite_regress/sqllogictest/Tests/select2.test.stable.out
sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out
sql/test/Tests/zones.stable.out
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/leaks/Tests/check0.stable.out
sql/test/leaks/Tests/check1.stable.out
sql/test/leaks/Tests/check2.stable.out
sql/test/leaks/Tests/check3.stable.out
sql/test/leaks/Tests/check4.stable.out
sql/test/leaks/Tests/check5.stable.out
sql/test/leaks/Tests/drop3.stable.out
sql/test/leaks/Tests/select1.stable.out
sql/test/leaks/Tests/select2.stable.out
sql/test/leaks/Tests/temp1.stable.out
sql/test/leaks/Tests/temp2.stable.out
sql/test/leaks/Tests/temp3.stable.out
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: default
Log Message:
merged with jun2016
diffs (truncated from 2366 to 300 lines):
diff --git a/sql/benchmarks/ssbm/Tests/02-explain.stable.out
b/sql/benchmarks/ssbm/Tests/02-explain.stable.out
--- a/sql/benchmarks/ssbm/Tests/02-explain.stable.out
+++ b/sql/benchmarks/ssbm/Tests/02-explain.stable.out
@@ -78,7 +78,7 @@ function user.s2_1():void;
X_54 := algebra.projection(X_41,X_53);
X_55:bat[:lng] := batcalc.*(X_52,X_54);
X_56:lng := aggr.sum(X_55);
- sql.resultSet("sys.L1","revenue","bigint",64,0,7,X_56);
+ sql.resultSet("sys.L2","revenue","bigint",64,0,7,X_56);
end user.s2_1;
# 23:10:45 >
diff --git a/sql/benchmarks/ssbm/Tests/03-explain.stable.out
b/sql/benchmarks/ssbm/Tests/03-explain.stable.out
--- a/sql/benchmarks/ssbm/Tests/03-explain.stable.out
+++ b/sql/benchmarks/ssbm/Tests/03-explain.stable.out
@@ -85,7 +85,7 @@ function user.s2_1():void;
X_61 := algebra.projection(X_48,X_60);
X_62:bat[:lng] := batcalc.*(X_59,X_61);
X_63:lng := aggr.sum(X_62);
- sql.resultSet("sys.L1","revenue","bigint",64,0,7,X_63);
+ sql.resultSet("sys.L2","revenue","bigint",64,0,7,X_63);
end user.s2_1;
# 23:10:45 >
diff --git a/sql/benchmarks/tpch/Tests/15-plan.stable.out
b/sql/benchmarks/tpch/Tests/15-plan.stable.out
--- a/sql/benchmarks/tpch/Tests/15-plan.stable.out
+++ b/sql/benchmarks/tpch/Tests/15-plan.stable.out
@@ -78,11 +78,11 @@ project (
| | | | | | select (
| | | | | | | table(sys.lineitem) [ lineitem.l_suppkey NOT NULL,
lineitem.l_extendedprice NOT NULL, lineitem.l_discount NOT NULL,
lineitem.l_shipdate NOT NULL ] COUNT
| | | | | | ) [ date "1996-01-01" <= lineitem.l_shipdate NOT NULL <
sys.sql_add(date "1996-01-01", month_interval "3") ]
-| | | | | ) [ lineitem.l_suppkey NOT NULL ] [ lineitem.l_suppkey NOT NULL,
sys.sum no nil (sys.sql_mul(lineitem.l_extendedprice NOT NULL,
sys.sql_sub(decimal(15,2)[tinyint "1"], lineitem.l_discount NOT NULL))) as
L2.L2 ]
-| | | | ) [ L2 as revenue0.total_revenue ]
-| | | ) [ ] [ sys.max no nil (revenue0.total_revenue) as L3.L3 ]
-| | ) [ L3 as L3.L3 ]
-| ) [ revenue0.total_revenue = L3.L3 ]
+| | | | | ) [ lineitem.l_suppkey NOT NULL ] [ lineitem.l_suppkey NOT NULL,
sys.sum no nil (sys.sql_mul(lineitem.l_extendedprice NOT NULL,
sys.sql_sub(decimal(15,2)[tinyint "1"], lineitem.l_discount NOT NULL))) as
L3.L3 ]
+| | | | ) [ L3 as revenue0.total_revenue ]
+| | | ) [ ] [ sys.max no nil (revenue0.total_revenue) as L5.L5 ]
+| | ) [ L5 as L6.L5 ]
+| ) [ revenue0.total_revenue = L6.L5 ]
) [ supplier.s_suppkey NOT NULL HASHCOL , supplier.s_name NOT NULL,
supplier.s_address NOT NULL, supplier.s_phone NOT NULL, revenue0.total_revenue
] [ supplier.s_suppkey ASC NOT NULL HASHCOL ]
#drop view revenue0;
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out
---
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out
+++
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out
@@ -26,8 +26,8 @@ Ready.
# 16:51:10 >
#select
1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+
(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(
1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1
+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+
(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(
1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1
+(1+(1+(1+(1+(1+(1+(1+(1+(1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
)))))))))))))))))))))))))))))))));
-% .L # table_name
-% sql_add_single_value # name
+% .L1 # table_name
+% L1 # name
% bigint # type
% 4 # length
[ 2001 ]
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/max_min_sum_null.SF-1123132.stable.out
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/max_min_sum_null.SF-1123132.stable.out
---
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/max_min_sum_null.SF-1123132.stable.out
+++
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/max_min_sum_null.SF-1123132.stable.out
@@ -25,8 +25,8 @@ Ready.
[ 3 ]
#SELECT MIN(aap),MAX(aap),SUM(aap) FROM t1123132;
-% sys.L1, sys.L2, sys.L3 # table_name
-% L1, L2, L3 # name
+% sys.L2, sys.L4, sys.L6 # table_name
+% L1, L3, L5 # name
% int, int, bigint # type
% 1, 1, 1 # length
[ 1, 2, 3 ]
diff --git a/sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out
b/sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out
--- a/sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out
+++ b/sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out
@@ -29,14 +29,14 @@ Ready.
[ 1 ]
#SELECT EXTRACT (SECOND FROM FIPS2)
#* 1000000 - 999990 FROM A;
-% sys.L # table_name
-% sql_mul_second_fips2 # name
+% sys.L1 # table_name
+% L1 # name
% decimal # type
% 21 # length
[ -990.000000 ]
#select EXTRACT (SECOND FROM FIPS2) FROM A;
-% sys.L # table_name
-% second_fips2 # name
+% sys.L1 # table_name
+% L1 # name
% decimal # type
% 11 # length
[ 0.999 ]
diff --git a/sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.out
b/sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.out
--- a/sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.out
+++ b/sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.out
@@ -25,15 +25,15 @@ Ready.
# 22:31:14 >
#select bit_and(3749090034127126942, -1);
-% .L # table_name
-% bit_and_single_value # name
+% .L1 # table_name
+% L1 # name
% bigint # type
% 19 # length
[ 3749090034127126942 ]
#select bit_and(3749090034127126942, 0x7fffffffffffffff);
-% .L # table_name
-% bit_and_single_value # name
+% .L1 # table_name
+% L1 # name
% bigint # type
% 19 # length
[ 3749090034127126942 ]
diff --git
a/sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.stable.out
b/sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.stable.out
--- a/sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.stable.out
+++ b/sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.stable.out
@@ -33,8 +33,8 @@ Ready.
#rank() over (order by sum(score) desc) -- cannot use alias 'totalscore' here
#from score_table
#group by s_name;
-% sys.score_table, sys.L1, sys.L3 # table_name
-% s_name, totalscore, L3 # name
+% sys.score_table, sys.L2, sys.L4 # table_name
+% s_name, totalscore, L4 # name
% varchar, bigint, int # type
% 3, 3, 1 # length
[ "foo", 180, 1 ]
diff --git
a/sql/test/BugTracker-2011/Tests/non-stable-select-bug.Bug-2894.stable.out
b/sql/test/BugTracker-2011/Tests/non-stable-select-bug.Bug-2894.stable.out
--- a/sql/test/BugTracker-2011/Tests/non-stable-select-bug.Bug-2894.stable.out
+++ b/sql/test/BugTracker-2011/Tests/non-stable-select-bug.Bug-2894.stable.out
@@ -49,24 +49,24 @@ Ready.
#insert into table2894 values (1,1.0),(2,2.0),(3,3.0),(4,4.0);
[ 4 ]
#select i,1/(i-1) from table2894 where i > 1;
-% sys.table2894, .L # table_name
-% i, sql_div_single_value # name
+% sys.table2894, .L1 # table_name
+% i, L1 # name
% int, bigint # type
% 1, 1 # length
[ 2, 1 ]
[ 3, 0 ]
[ 4, 0 ]
#select i,1/(i-1.0) from table2894 where i > 1;
-% sys.table2894, .L # table_name
-% i, sql_div_single_value # name
+% sys.table2894, .L1 # table_name
+% i, L1 # name
% int, decimal # type
% 1, 21 # length
[ 2, 1.000 ]
[ 3, 0.500 ]
[ 4, 0.333 ]
#select i,1/(i-1) from table2894 where i > 1;
-% sys.table2894, .L # table_name
-% i, sql_div_single_value # name
+% sys.table2894, .L1 # table_name
+% i, L1 # name
% int, bigint # type
% 1, 1 # length
[ 2, 1 ]
diff --git
a/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out
b/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out
---
a/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out
+++
b/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out
@@ -46,9 +46,9 @@ Ready.
# 14:36:23 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=riga"
"--port=32568"
# 14:36:23 >
-#select convert (10000000 * 100000 * 11.51,decimal(15)) +convert (51.097 *
100000, decimal(15));
-% . # table_name
-% sql_mul_single_value # name
+#select convert ( 10000000 * 100000
* 11.51 , decimal(15)) + convert (51.097 * 100000 , decimal(15));
+% .L3 # table_name
+% L3 # name
% decimal # type
% 20 # length
[ 11510005109700 ]
diff --git
a/sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out
b/sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out
---
a/sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out
+++
b/sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out
@@ -78,32 +78,32 @@ Ready.
[ 6, 0 ]
[ 8, 0 ]
#select median( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% bigint # type
% 1 # length
[ 3 ]
#select prod( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% bigint # type
% 1 # length
[ 0 ]
#select stddev_pop( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% double # type
% 24 # length
[ 3.337497399 ]
#select stddev_samp( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% double # type
% 24 # length
[ 3.656045222 ]
#select sign( prob1 ) from mtcars2;
-% sys.L # table_name
-% sign_prob1 # name
+% sys.L1 # table_name
+% L1 # name
% tinyint # type
% 1 # length
[ 1 ]
@@ -126,32 +126,32 @@ Ready.
[ 6, 0 ]
[ 8, 0 ]
#select median( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% tinyint # type
% 1 # length
[ 3 ]
#select prod( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% bigint # type
% 1 # length
[ 0 ]
#select stddev_pop( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% double # type
% 24 # length
[ 3.337497399 ]
#select stddev_samp( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% double # type
% 24 # length
[ 3.656045222 ]
#select sign( prob1 ) from mtcars2;
-% sys.L # table_name
-% sign_prob1 # name
+% sys.L1 # table_name
+% L1 # name
% tinyint # type
% 1 # length
[ 1 ]
@@ -174,32 +174,32 @@ Ready.
[ 6, 0 ]
[ 8, 0 ]
#select median( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% smallint # type
% 1 # length
[ 3 ]
#select prod( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% bigint # type
% 1 # length
[ 0 ]
#select stddev_pop( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% double # type
% 24 # length
[ 3.337497399 ]
#select stddev_samp( prob1 ) from mtcars2;
-% sys.L1 # table_name
+% sys.L2 # table_name
% L1 # name
% double # type
% 24 # length
[ 3.656045222 ]
#select sign( prob1 ) from mtcars2;
-% sys.L # table_name
-% sign_prob1 # name
+% sys.L1 # table_name
+% L1 # name
% tinyint # type
% 1 # length
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
