Changeset: ac24b3003498 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ac24b3003498
Modified Files:
sql/backends/monet5/generator/Tests/generator01.stable.err
sql/benchmarks/tpch/Tests/19-explain.stable.out
sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
sql/benchmarks/tpch/Tests/19-plan.stable.out
sql/benchmarks/tpch/Tests/19-plan.stable.out.int128
sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out
sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.stable.out
sql/test/BugTracker-2009/Tests/Division_by_zero_error.SF-2791361.stable.out
sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
sql/test/BugTracker-2014/Tests/orderby_on_constant.Bug-3554.stable.out
sql/test/BugTracker-2014/Tests/round.Bug-3542.stable.out.int128
sql/test/BugTracker-2015/Tests/operator-priority.Bug-3686.stable.out
sql/test/BugTracker/Tests/insert_date.SF-1838785.stable.err
sql/test/BugTracker/Tests/select_mod.SF-1838813.stable.out
sql/test/Tests/coalesce.stable.out
sql/test/Tests/round.stable.out
sql/test/Via-m/Tests/event_s11.stable.err
sql/test/bugs/Tests/create_insert_select_aggr-bug-00001.stable.out
sql/test/pg_regress/Tests/int4.stable.out
sql/test/pg_regress/Tests/int4.stable.out.int128
sql/test/pg_regress/Tests/numeric.stable.err
sql/test/pg_regress/Tests/strings.stable.err.int128
Branch: default
Log Message:
approved output
diffs (truncated from 471 to 300 lines):
diff --git a/sql/backends/monet5/generator/Tests/generator01.stable.err
b/sql/backends/monet5/generator/Tests/generator01.stable.err
--- a/sql/backends/monet5/generator/Tests/generator01.stable.err
+++ b/sql/backends/monet5/generator/Tests/generator01.stable.err
@@ -85,14 +85,14 @@ QUERY = select * from generate_series(ca
ERROR = !Illegal generator range
MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300
QUERY = select * from generate_series(cast(null as timestamp),10,1) ;
-ERROR = !types tinyint(8,0) and timestamp(7,0) are not equal for column 'L2'
-MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300
+ERROR = !types tinyint(4,0) and timestamp(7,0) are not equal for column 'L2'
+MAPI = (monetdb) /var/tmp/mtest-11592/.s.monetdb.39445
QUERY = select * from generate_series(null,cast(10 as timestamp),cast(1 as
interval second)) ;
-ERROR = !types tinyint(8,0) and timestamp(7,0) are not equal
-MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300
+ERROR = !types tinyint(4,0) and timestamp(7,0) are not equal
+MAPI = (monetdb) /var/tmp/mtest-11592/.s.monetdb.39445
QUERY = select * from generate_series(cast(null as timestamp),cast(10 as
timestamp),cast(1 as interval second)) ;
-ERROR = !types tinyint(8,0) and timestamp(7,0) are not equal
-MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300
+ERROR = !types tinyint(4,0) and timestamp(7,0) are not equal
+MAPI = (monetdb) /var/tmp/mtest-11592/.s.monetdb.39445
QUERY = select * from generate_series(10,null,1) ;
ERROR = !Illegal generator range
MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300
diff --git a/sql/benchmarks/tpch/Tests/19-explain.stable.out
b/sql/benchmarks/tpch/Tests/19-explain.stable.out
--- a/sql/benchmarks/tpch/Tests/19-explain.stable.out
+++ b/sql/benchmarks/tpch/Tests/19-explain.stable.out
@@ -51,7 +51,7 @@ Ready.
% mal # name
% clob # type
% 1117 # length
-function
user.s2_1(A0:bte,A1:str,A2:str,A3:str,A4:str,A5:str,A6:bte,A7:sht,A8:sht,A9:int,A10:int,A11:str,A12:str,A13:str,A14:str,A15:str,A16:str,A17:str,A18:str,A19:bte,A20:sht,A21:sht,A22:int,A23:int,A24:str,A25:str,A26:str,A27:str,A28:str,A29:str,A30:str,A31:str,A32:bte,A33:sht,A34:sht,A35:int,A36:int,A37:str,A38:str,A39:str):void;
+function
user.s2_1(A0:bte,A1:str,A2:str,A3:str,A4:str,A5:str,A6:bte,A7:bte,A8:bte,A9:int,A10:int,A11:str,A12:str,A13:str,A14:str,A15:str,A16:str,A17:str,A18:str,A19:bte,A20:bte,A21:bte,A22:int,A23:int,A24:str,A25:str,A26:str,A27:str,A28:str,A29:str,A30:str,A31:str,A32:bte,A33:bte,A34:bte,A35:int,A36:int,A37:str,A38:str,A39:str):void;
X_250:void := querylog.define("explain select\n sum(l_extendedprice* (1 -
l_discount)) as revenue\nfrom\n lineitem,\n part\nwhere\n (\n p_partkey =
l_partkey\n and p_brand = \\'Brand#12\\'\n and p_container in (\\'SM CASE\\',
\\'SM BOX\\', \\'SM PACK\\', \\'SM PKG\\')\n and l_quantity >= 1 and l_quantity
<= 1 + 10\n and p_size between 1 and 5\n and l_shipmode in (\\'AIR\\', \\'AIR
REG\\')\n and l_shipinstruct = \\'DELIVER IN PERSON\\'\n )\n or\n (\n p_partkey
= l_partkey\n and p_brand = \\'Brand#23\\'\n and p_container in (\\'MED BAG\\',
\\'MED BOX\\', \\'MED PKG\\', \\'MED PACK\\')\n and l_quantity >= 10 and
l_quantity <= 10 + 10\n and p_size between 1 and 10\n and l_shipmode in
(\\'AIR\\', \\'AIR REG\\')\n and l_shipinstruct = \\'DELIVER IN PERSON\\'\n )\n
or\n (\n p_partkey = l_partkey\n and p_brand = \\'Brand#34\\'\n and p_container
in (\\'LG CASE\\', \\'LG BOX\\', \\'LG PACK\\', \\'LG PKG\\')\n and l_quantity
>= 20 and l_quantity <= 20 + 10\n and p_size between 1 and 15\n a
nd l_shipmode in (\\'AIR\\', \\'AIR REG\\')\n and l_shipinstruct = \\'DELIVER
IN PERSON\\'\n );","sequential_pipe",172);
X_41 := sql.mvc();
C_42:bat[:oid] := sql.tid(X_41,"sys","part");
@@ -161,7 +161,7 @@ function user.s2_1(A0:bte,A1:str,A2:str,
X_177 := bat.mergecand(X_175,C_176);
X_167 := calc.lng(A6,15,2);
C_178 := algebra.thetasubselect(X_163,X_177,X_167,">=");
- X_164:sht := calc.+(A7,A8);
+ X_164:bte := calc.+(A7,A8);
X_165 := calc.lng(X_164,15,2);
C_180 := algebra.thetasubselect(X_163,C_178,X_165,"<=");
C_182 := algebra.subselect(X_156,C_180,A9,A10,true,true,false);
@@ -179,7 +179,7 @@ function user.s2_1(A0:bte,A1:str,A2:str,
X_197 := bat.mergecand(X_195,C_196);
X_189 := calc.lng(A19,15,2);
C_198 := algebra.thetasubselect(X_163,X_197,X_189,">=");
- X_187:sht := calc.+(A20,A21);
+ X_187:bte := calc.+(A20,A21);
X_188 := calc.lng(X_187,15,2);
C_199 := algebra.thetasubselect(X_163,C_198,X_188,"<=");
C_200 := algebra.subselect(X_156,C_199,A22,A23,true,true,false);
@@ -197,7 +197,7 @@ function user.s2_1(A0:bte,A1:str,A2:str,
X_215 := bat.mergecand(X_213,C_214);
X_207 := calc.lng(A32,15,2);
C_216 := algebra.thetasubselect(X_163,X_215,X_207,">=");
- X_205:sht := calc.+(A33,A34);
+ X_205:bte := calc.+(A33,A34);
X_206 := calc.lng(X_205,15,2);
C_217 := algebra.thetasubselect(X_163,C_216,X_206,"<=");
C_218 := algebra.subselect(X_156,C_217,A35,A36,true,true,false);
diff --git a/sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
b/sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
--- a/sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
+++ b/sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
@@ -51,7 +51,7 @@ Ready.
% mal # name
% clob # type
% 1117 # length
-function
user.s2_1(A0:bte,A1:str,A2:str,A3:str,A4:str,A5:str,A6:bte,A7:sht,A8:sht,A9:int,A10:int,A11:str,A12:str,A13:str,A14:str,A15:str,A16:str,A17:str,A18:str,A19:bte,A20:sht,A21:sht,A22:int,A23:int,A24:str,A25:str,A26:str,A27:str,A28:str,A29:str,A30:str,A31:str,A32:bte,A33:sht,A34:sht,A35:int,A36:int,A37:str,A38:str,A39:str):void;
+function
user.s2_1(A0:bte,A1:str,A2:str,A3:str,A4:str,A5:str,A6:bte,A7:bte,A8:bte,A9:int,A10:int,A11:str,A12:str,A13:str,A14:str,A15:str,A16:str,A17:str,A18:str,A19:bte,A20:bte,A21:bte,A22:int,A23:int,A24:str,A25:str,A26:str,A27:str,A28:str,A29:str,A30:str,A31:str,A32:bte,A33:bte,A34:bte,A35:int,A36:int,A37:str,A38:str,A39:str):void;
X_250:void := querylog.define("explain select\n sum(l_extendedprice* (1 -
l_discount)) as revenue\nfrom\n lineitem,\n part\nwhere\n (\n p_partkey =
l_partkey\n and p_brand = \\'Brand#12\\'\n and p_container in (\\'SM CASE\\',
\\'SM BOX\\', \\'SM PACK\\', \\'SM PKG\\')\n and l_quantity >= 1 and l_quantity
<= 1 + 10\n and p_size between 1 and 5\n and l_shipmode in (\\'AIR\\', \\'AIR
REG\\')\n and l_shipinstruct = \\'DELIVER IN PERSON\\'\n )\n or\n (\n p_partkey
= l_partkey\n and p_brand = \\'Brand#23\\'\n and p_container in (\\'MED BAG\\',
\\'MED BOX\\', \\'MED PKG\\', \\'MED PACK\\')\n and l_quantity >= 10 and
l_quantity <= 10 + 10\n and p_size between 1 and 10\n and l_shipmode in
(\\'AIR\\', \\'AIR REG\\')\n and l_shipinstruct = \\'DELIVER IN PERSON\\'\n )\n
or\n (\n p_partkey = l_partkey\n and p_brand = \\'Brand#34\\'\n and p_container
in (\\'LG CASE\\', \\'LG BOX\\', \\'LG PACK\\', \\'LG PKG\\')\n and l_quantity
>= 20 and l_quantity <= 20 + 10\n and p_size between 1 and 15\n a
nd l_shipmode in (\\'AIR\\', \\'AIR REG\\')\n and l_shipinstruct = \\'DELIVER
IN PERSON\\'\n );","sequential_pipe",172);
X_41 := sql.mvc();
C_42:bat[:oid] := sql.tid(X_41,"sys","part");
@@ -161,7 +161,7 @@ function user.s2_1(A0:bte,A1:str,A2:str,
X_177 := bat.mergecand(X_175,C_176);
X_167 := calc.lng(A6,15,2);
C_178 := algebra.thetasubselect(X_163,X_177,X_167,">=");
- X_164:sht := calc.+(A7,A8);
+ X_164:bte := calc.+(A7,A8);
X_165 := calc.lng(X_164,15,2);
C_180 := algebra.thetasubselect(X_163,C_178,X_165,"<=");
C_182 := algebra.subselect(X_156,C_180,A9,A10,true,true,false);
@@ -179,7 +179,7 @@ function user.s2_1(A0:bte,A1:str,A2:str,
X_197 := bat.mergecand(X_195,C_196);
X_189 := calc.lng(A19,15,2);
C_198 := algebra.thetasubselect(X_163,X_197,X_189,">=");
- X_187:sht := calc.+(A20,A21);
+ X_187:bte := calc.+(A20,A21);
X_188 := calc.lng(X_187,15,2);
C_199 := algebra.thetasubselect(X_163,C_198,X_188,"<=");
C_200 := algebra.subselect(X_156,C_199,A22,A23,true,true,false);
@@ -197,7 +197,7 @@ function user.s2_1(A0:bte,A1:str,A2:str,
X_215 := bat.mergecand(X_213,C_214);
X_207 := calc.lng(A32,15,2);
C_216 := algebra.thetasubselect(X_163,X_215,X_207,">=");
- X_205:sht := calc.+(A33,A34);
+ X_205:bte := calc.+(A33,A34);
X_206 := calc.lng(X_205,15,2);
C_217 := algebra.thetasubselect(X_163,C_216,X_206,"<=");
C_218 := algebra.subselect(X_156,C_217,A35,A36,true,true,false);
diff --git a/sql/benchmarks/tpch/Tests/19-plan.stable.out
b/sql/benchmarks/tpch/Tests/19-plan.stable.out
--- a/sql/benchmarks/tpch/Tests/19-plan.stable.out
+++ b/sql/benchmarks/tpch/Tests/19-plan.stable.out
@@ -49,7 +49,7 @@ Ready.
% .plan # table_name
% rel # name
% clob # type
-% 1070 # length
+% 1064 # length
project (
| group by (
| | select (
diff --git a/sql/benchmarks/tpch/Tests/19-plan.stable.out.int128
b/sql/benchmarks/tpch/Tests/19-plan.stable.out.int128
--- a/sql/benchmarks/tpch/Tests/19-plan.stable.out.int128
+++ b/sql/benchmarks/tpch/Tests/19-plan.stable.out.int128
@@ -49,7 +49,7 @@ Ready.
% .plan # table_name
% rel # name
% clob # type
-% 1070 # length
+% 1064 # length
project (
| group by (
| | select (
@@ -61,7 +61,7 @@ project (
| | | | | table(sys.lineitem) [ lineitem.l_partkey NOT NULL,
lineitem.l_quantity NOT NULL, lineitem.l_extendedprice NOT NULL,
lineitem.l_discount NOT NULL, lineitem.l_shipinstruct NOT NULL,
lineitem.l_shipmode NOT NULL ] COUNT
| | | | ) [ lineitem.l_shipinstruct NOT NULL = char(25) "DELIVER IN PERSON",
lineitem.l_shipmode NOT NULL in (char(10) "AIR", char(10) "AIR REG") ]
| | | ) [ part.p_partkey NOT NULL HASHCOL = lineitem.l_partkey NOT NULL ]
-| | ) [ (part.p_brand NOT NULL = char(10) "Brand#12", part.p_container NOT
NULL in (char(10) "SM CASE", char(10) "SM BOX", char(10) "SM PACK", char(10)
"SM PKG"), lineitem.l_quantity NOT NULL >= decimal(15,2)[tinyint "1"],
lineitem.l_quantity NOT NULL <= decimal(15,2)[sys.sql_add(smallint "1",
smallint "10")], int "1" <= part.p_size NOT NULL <= int "5") or ((part.p_brand
NOT NULL = char(10) "Brand#23", part.p_container NOT NULL in (char(10) "MED
BAG", char(10) "MED BOX", char(10) "MED PKG", char(10) "MED PACK"),
lineitem.l_quantity NOT NULL >= decimal(15,2)[tinyint "10"],
lineitem.l_quantity NOT NULL <= decimal(15,2)[sys.sql_add(smallint "10",
smallint "10")], int "1" <= part.p_size NOT NULL <= int "10") or (part.p_brand
NOT NULL = char(10) "Brand#34", part.p_container NOT NULL in (char(10) "LG
CASE", char(10) "LG BOX", char(10) "LG PACK", char(10) "LG PKG"),
lineitem.l_quantity NOT NULL >= decimal(15,2)[tinyint "20"],
lineitem.l_quantity NOT NULL <= decimal(15,2)[sys.sql_add(smalli
nt "20", smallint "10")], int "1" <= part.p_size NOT NULL <= int "15")) ]
+| | ) [ (part.p_brand NOT NULL = char(10) "Brand#12", part.p_container NOT
NULL in (char(10) "SM CASE", char(10) "SM BOX", char(10) "SM PACK", char(10)
"SM PKG"), lineitem.l_quantity NOT NULL >= decimal(15,2)[tinyint "1"],
lineitem.l_quantity NOT NULL <= decimal(15,2)[sys.sql_add(tinyint "1", tinyint
"10")], int "1" <= part.p_size NOT NULL <= int "5") or ((part.p_brand NOT NULL
= char(10) "Brand#23", part.p_container NOT NULL in (char(10) "MED BAG",
char(10) "MED BOX", char(10) "MED PKG", char(10) "MED PACK"),
lineitem.l_quantity NOT NULL >= decimal(15,2)[tinyint "10"],
lineitem.l_quantity NOT NULL <= decimal(15,2)[sys.sql_add(tinyint "10", tinyint
"10")], int "1" <= part.p_size NOT NULL <= int "10") or (part.p_brand NOT NULL
= char(10) "Brand#34", part.p_container NOT NULL in (char(10) "LG CASE",
char(10) "LG BOX", char(10) "LG PACK", char(10) "LG PKG"), lineitem.l_quantity
NOT NULL >= decimal(15,2)[tinyint "20"], lineitem.l_quantity NOT NULL <=
decimal(15,2)[sys.sql_add(tinyint "2
0", tinyint "10")], int "1" <= part.p_size NOT NULL <= int "15")) ]
| ) [ ] [ sys.sum no nil (sys.sql_mul(decimal(33,2)[lineitem.l_extendedprice
NOT NULL] as lineitem.l_extendedprice, sys.sql_sub(decimal(15,2)[tinyint "1"],
lineitem.l_discount NOT NULL))) as L1.L1 ]
) [ L1 as L1.revenue ]
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out
--- a/sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out
+++ b/sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out
@@ -40,13 +40,13 @@ Ready.
% .L1 # table_name
% isnull_=_single_value # name
% char # type
-% 3 # length
+% 1 # length
[ "2" ]
#select CASE WHEN 2=0 THEN 2 else cast(null as char) end;
% .L1 # table_name
% isnull_=_single_value # name
% char # type
-% 3 # length
+% 1 # length
[ NULL ]
#select CASE WHEN 3=3 THEN 3 else cast(null as int) end;
% .L1 # table_name
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.stable.out
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.stable.out
---
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.stable.out
+++
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.stable.out
@@ -25,7 +25,7 @@ Ready.
% 7, 4, 1, 0, 3, 5 # length
[ "varchar", 1024, 0, "", "env", "name" ]
[ "varchar", 2048, 0, "", "env", "value" ]
-[ "tinyint", 8, 0, NULL, NULL, NULL ]
+[ "tinyint", 1, 0, NULL, NULL, NULL ]
#prepare select * from env() as env where name in (?);
#prepare select * from env() as env where name in (?);
% .prepare, .prepare, .prepare, .prepare, .prepare,
.prepare # table_name
diff --git
a/sql/test/BugTracker-2009/Tests/Division_by_zero_error.SF-2791361.stable.out
b/sql/test/BugTracker-2009/Tests/Division_by_zero_error.SF-2791361.stable.out
---
a/sql/test/BugTracker-2009/Tests/Division_by_zero_error.SF-2791361.stable.out
+++
b/sql/test/BugTracker-2009/Tests/Division_by_zero_error.SF-2791361.stable.out
@@ -69,7 +69,7 @@ Ready.
#select case when (2 - 2) > 0 then (3 - 2)/(2 - 2) else 0 end as "test";
% .L # table_name
% test # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 0 ]
diff --git
a/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
b/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
---
a/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
+++
b/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
@@ -22,7 +22,7 @@ Ready.
#debug select * from tables;
mdb>#X_1=0@0:void := user.s1_1();
-mdb>#X_159=0@0:void := querylog.define("debug select * from
tables;","default_pipe",2166);
+mdb>#X_160=0@0:void := querylog.define("debug select * from
tables;","default_pipe",2167);
# 16:24:01 >
# 16:24:01 > "Done."
diff --git
a/sql/test/BugTracker-2014/Tests/orderby_on_constant.Bug-3554.stable.out
b/sql/test/BugTracker-2014/Tests/orderby_on_constant.Bug-3554.stable.out
--- a/sql/test/BugTracker-2014/Tests/orderby_on_constant.Bug-3554.stable.out
+++ b/sql/test/BugTracker-2014/Tests/orderby_on_constant.Bug-3554.stable.out
@@ -28,14 +28,14 @@ Ready.
#select a+b from (select 1 as a,1 as b) as q order by a limit 1;
% .L1 # table_name
% L1 # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 2 ]
#select a+b from (select 1 as a,1 as b union select 1,1) as q order by a limit
#1;
% .L3 # table_name
% L3 # name
-% smallint # type
+% tinyint # type
% 1 # length
[ 2 ]
diff --git a/sql/test/BugTracker-2014/Tests/round.Bug-3542.stable.out.int128
b/sql/test/BugTracker-2014/Tests/round.Bug-3542.stable.out.int128
--- a/sql/test/BugTracker-2014/Tests/round.Bug-3542.stable.out.int128
+++ b/sql/test/BugTracker-2014/Tests/round.Bug-3542.stable.out.int128
@@ -50,7 +50,7 @@ Ready.
% sys.t1, sys.t2, sys.L # table_name
% id, id, round_sql_mul_val # name
% int, int, decimal # type
-% 1, 1, 10 # length
+% 1, 1, 7 # length
[ 1, 1, 0.00000000000000000000 ]
[ 1, 2, 0.00000000000000000000 ]
[ 2, 1, 0.00000000000000000000 ]
diff --git
a/sql/test/BugTracker-2015/Tests/operator-priority.Bug-3686.stable.out
b/sql/test/BugTracker-2015/Tests/operator-priority.Bug-3686.stable.out
--- a/sql/test/BugTracker-2015/Tests/operator-priority.Bug-3686.stable.out
+++ b/sql/test/BugTracker-2015/Tests/operator-priority.Bug-3686.stable.out
@@ -28,7 +28,7 @@ Ready.
#select 12*5/3;
% .L # table_name
% sql_mul_single_value # name
-% smallint # type
+% tinyint # type
% 2 # length
[ 20 ]
diff --git a/sql/test/BugTracker/Tests/insert_date.SF-1838785.stable.err
b/sql/test/BugTracker/Tests/insert_date.SF-1838785.stable.err
--- a/sql/test/BugTracker/Tests/insert_date.SF-1838785.stable.err
+++ b/sql/test/BugTracker/Tests/insert_date.SF-1838785.stable.err
@@ -13,7 +13,7 @@ stderr of test 'insert_date.SF-1838785`
MAPI = (monetdb) /var/tmp/mtest-27483/.s.monetdb.35395
QUERY = insert into test1838785(id,name,date33)
values(669207071,'hlwP94fhemRqP7bpmvM5fbhlr855Q42yO5TTaafgMbm5pKiZskvclg3MkvcN2cpTOfOf1iOf0Wa98ddioVdU2xjdj47zYOpLbNagahw0v37Kjq0n5aOWKd1hc4jsQegTabzSZTfQlrUrSghmUrc7hj5znvk5glg06ht4jYbRPKcm4OxUzsVkP3iMa8SdZPgjsNPnTSP8eP2syaSWNldk0tshj4OyqwOcn5sgeNe7Qzcdeg4bv80NWneMi701eaamna2gXVhjitMQ5Zew9c4iVnSWV9P0ZgRoM8PjYaZP1M5u6qylYZL6dYa7Uj9qcgiZLqkkz8Z93udrN3ajahVughPqPTUZidP43f5RtiysbWimPXZx84TVcURZ52tWpYsc8oqnf0roQTVTjWO8viMR6o0mreQqMPcKhwr0LajKeb2PTgXufLijL3XvaaN0PVzudNzdwUs0bdU4R1ejVfjNaPa16q3pnfx3eaXVviUf8tz3M9bnf3sSnqxiPUf5XaOvuyrekssqenndbUycgh1QefhWiQgdzj5qWTb7kWe4SY7Zb0q5nTiWQoahcm6ibWaPLa7k0fUMTuf8KMk46fbpcqpwq3TzeQZh4tOyWf5sXuuKmUqeqTzeWbuTif9fi5agau4VgOLxgUqwhXSRixf69KPcrbUbbbrazTleVQrn3lXVTgxVOTbpeLpb6oiUVwfad5eeiLVf1TKiY5vbY5bghcsnN2ZV9Wx0dKus4zzVcsnxg8eSe0Teh6iczhLxmT0VKz3bOMu2R0yc5cLi9ue25eofMfs66dcoglrzogghfjfNNi15TkbMVUZw2yqhdyLy4i51el1geOVSQiXOSh0eK7PeQrb1T32YV25ThqishhxWiZnbdNf6frmaiSZ52utNrVlgsXdx8l1hb7p7NeeoqomXiflMWmmaLbr4rtOcgmv6gg5XizoNjOfuYu8PPSmfQRiglh05iNM
Zim1KefLzvxi853uZv5d96ixrNVazyO42rfv7W8R1bV62y8zcc2qm',1957-08-01);
-ERROR = !types bigint(64,0) and date(0,0) are not equal
+ERROR = !types int(32,0) and date(0,0) are not equal
# 00:53:56 >
# 00:53:56 > Done.
diff --git a/sql/test/BugTracker/Tests/select_mod.SF-1838813.stable.out
b/sql/test/BugTracker/Tests/select_mod.SF-1838813.stable.out
--- a/sql/test/BugTracker/Tests/select_mod.SF-1838813.stable.out
+++ b/sql/test/BugTracker/Tests/select_mod.SF-1838813.stable.out
@@ -33,7 +33,7 @@ Ready.
% .L # table_name
% mod_single_value # name
% decimal # type
-% 6 # length
+% 4 # length
[ 2.0 ]
# 00:15:33 >
diff --git a/sql/test/Tests/coalesce.stable.out
b/sql/test/Tests/coalesce.stable.out
--- a/sql/test/Tests/coalesce.stable.out
+++ b/sql/test/Tests/coalesce.stable.out
@@ -82,7 +82,7 @@ Ready.
% sys.coalescetest, sys.L # table_name
% id, isnull_not_isnull_name # name
% int, char # type
-% 1, 10 # length
+% 1, 32 # length
[ 1, "a" ]
[ 2, "26" ]
[ 3, "c" ]
diff --git a/sql/test/Tests/round.stable.out b/sql/test/Tests/round.stable.out
--- a/sql/test/Tests/round.stable.out
+++ b/sql/test/Tests/round.stable.out
@@ -28,25 +28,25 @@ Ready.
% .L1, .L2, .L3, .L3 # table_name
% L1, L2, L3, round_single_value # name
% decimal, decimal, decimal, decimal # type
-% 10, 10, 10, 10 # length
+% 3, 4, 4, 5 # length
[ 750.00, 700.00, 1000.00, 0.00 ]
#SELECT ROUND(123.9994, 3),ROUND(123.9995, 3);
% .L1, .L1 # table_name
% L1, round_single_value # name
% decimal, decimal # type
-% 10, 10 # length
+% 4, 4 # length
[ 123.9990, 124.0000 ]
#SELECT ROUND(123.4545, 2);
% .L # table_name
% round_single_value # name
% decimal # type
-% 10 # length
+% 4 # length
[ 123.4500 ]
#SELECT ROUND(123.45, -2);
% .L # table_name
% round_single_value # name
% decimal # type
-% 10 # length
+% 4 # length
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
