Changeset: 9086a09c30dc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/9086a09c30dc
Modified Files:
sql/test/BugTracker-2023/Tests/misc-crashes-7390.test
sql/test/BugTracker-2025/Tests/7615_join_reordering_2.test
sql/test/SQLancer/Tests/sqlancer13.test
sql/test/Tests/window_functions.test
sql/test/rel-optimizers/Tests/isnull-isnotnull-equality-exp.test
testing/sqllogictest.py
Branch: default
Log Message:
Merge with Mar2025 branch.
diffs (truncated from 19692 to 300 lines):
diff --git a/sql/backends/monet5/UDF/capi/Tests/capi11.test
b/sql/backends/monet5/UDF/capi/Tests/capi11.test
--- a/sql/backends/monet5/UDF/capi/Tests/capi11.test
+++ b/sql/backends/monet5/UDF/capi/Tests/capi11.test
@@ -42,12 +42,12 @@ CREATE TABLE decimals(d DECIMAL(18,3))
statement ok
INSERT INTO decimals VALUES (10.3), (10.5), (NULL), (10.7)
-query R rowsort
+query D rowsort
SELECT capi11(d) FROM decimals
----
-10.300
-10.500
-10.700
+10.3
+10.5
+10.7
NULL
statement ok
@@ -95,7 +95,7 @@ CREATE TABLE doubles(d DOUBLE)
statement ok
INSERT INTO doubles VALUES (10.3), (10.5), (10.7)
-query R rowsort
+query D rowsort
SELECT _dbl2dec(d) FROM doubles
----
10.300
diff --git a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.test
b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.test
--- a/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.test
+++ b/sql/backends/monet5/UDF/pyapi3/Tests/pyapi3_18.test
@@ -138,7 +138,7 @@ LANGUAGE PYTHON
return result
}
-query R rowsort
+query D rowsort
SELECT * FROM pyapi_ret_decimal()
----
100.330
diff --git
a/sql/backends/monet5/generator/Tests/execute-privilege-for-public.test
b/sql/backends/monet5/generator/Tests/execute-privilege-for-public.test
--- a/sql/backends/monet5/generator/Tests/execute-privilege-for-public.test
+++ b/sql/backends/monet5/generator/Tests/execute-privilege-for-public.test
@@ -150,25 +150,25 @@ 5.000
3.000
@connection(id=c2, username=test, password=test)
-query R nosort
+query D nosort
SELECT * from generate_series(cast(1 as decimal(9)),3,1)
----
-1.000
-2.000
+1.00
+2.00
@connection(id=c2, username=test, password=test)
-query R nosort
+query D nosort
SELECT * from generate_series(1,cast(4 as decimal(9)),2)
----
-1.000
-3.000
+1.00
+3.00
@connection(id=c2, username=test, password=test)
-query R nosort
+query D nosort
SELECT * from generate_series(5,1,cast(-2 as decimal(9)))
----
-5.000
-3.000
+5.00
+3.00
@connection(id=c2, username=test, password=test)
query T nosort
diff --git a/sql/backends/monet5/generator/Tests/generator02.test
b/sql/backends/monet5/generator/Tests/generator02.test
--- a/sql/backends/monet5/generator/Tests/generator02.test
+++ b/sql/backends/monet5/generator/Tests/generator02.test
@@ -1,13 +1,13 @@
-query R rowsort
+query D rowsort
select * from generate_series(0.0,10.0,1.6)
----
-0.000
-1.600
-3.200
-4.800
-6.400
-8.000
-9.600
+0.00
+1.60
+3.20
+4.80
+6.40
+8.00
+9.60
query R rowsort
select * from generate_series(cast(0.0 as real),cast(10.0 as real),cast(1.6 as
real))
@@ -31,24 +31,24 @@ 6.400
8.000
9.600
-query R rowsort
+query D rowsort
select * from generate_series(cast(0.0 as decimal(10,2)),cast(10.0 as
decimal(10,2)),cast(1.6 as decimal(10,2)))
----
-0.000
-1.600
-3.200
-4.800
-6.400
-8.000
-9.600
+0.00
+1.60
+3.20
+4.80
+6.40
+8.00
+9.60
-query R rowsort
+query D rowsort
select * from generate_series(0.1,10.0,1.77)
where value <5.0
----
-0.100
-1.870
-3.640
+0.10
+1.87
+3.64
query R rowsort
select * from generate_series(cast(0.1 as real),cast(10.0 as real),cast(1.77
as real))
@@ -66,20 +66,20 @@ 0.100
1.870
3.640
-query R rowsort
+query D rowsort
select * from generate_series(cast(0.1 as decimal(10,2)),cast(10.0 as
decimal(10,2)),cast(1.77 as decimal(10,2)))
where value <5.0
----
-0.100
-1.870
-3.640
+0.10
+1.87
+3.64
-query R rowsort
+query D rowsort
select * from generate_series(0.2,10.0,1.9) as v
where value <7.0 and value >3.0
----
-4.000
-5.900
+4.00
+5.90
query R rowsort
select * from generate_series(cast(0.2 as real),cast(10.0 as real),cast(1.9 as
real)) as v
@@ -95,12 +95,12 @@ where value <7.0 and value >3.0
4.000
5.900
-query R rowsort
+query D rowsort
select * from generate_series(cast(0.2 as decimal(10,2)),cast(10.0 as
decimal(10,2)),cast(1.9 as decimal(10,2))) as v
where value <7.0 and value >3.0
----
-4.000
-5.900
+4.00
+5.90
query R rowsort
select * from generate_series(0.0e0,10.0e0,1.6e0)
diff --git a/sql/benchmarks/ATIS/Tests/one.test
b/sql/benchmarks/ATIS/Tests/one.test
--- a/sql/benchmarks/ATIS/Tests/one.test
+++ b/sql/benchmarks/ATIS/Tests/one.test
@@ -412,29 +412,29 @@ SHORTS 330 PASSENGER
USAIR
SHORTS 360
-query TRI nosort
+query TDI nosort
select day_name.day_name,day_name.day_code,count(*) from flight_day,day_name
where day_name.day_code=flight_day.day_code group by
day_name.day_name,day_name.day_code order by day_code
----
MONDAY
-1.000
+1
64
TUESDAY
-2.000
+2
64
WEDNESDAY
-3.000
+3
64
THURSDAY
-4.000
+4
64
FRIDAY
-5.000
+5
64
SATURDAY
-6.000
+6
64
SUNDAY
-7.000
+7
64
query TI rowsort
@@ -467,45 +467,45 @@ SATURDAY
MAY
FRIDAY
-query TRI nosort
+query TDI nosort
select day_name.day_name,flight_day.day_code,count(*) from flight_day,day_name
where day_name.day_code=flight_day.day_code group by
flight_day.day_code,day_name.day_name order by day_code
----
MONDAY
-1.000
+1
64
TUESDAY
-2.000
+2
64
WEDNESDAY
-3.000
+3
64
THURSDAY
-4.000
+4
64
FRIDAY
-5.000
+5
64
SATURDAY
-6.000
+6
64
SUNDAY
-7.000
+7
64
-query R rowsort
+query D rowsort
select sum(engines) from aircraft
----
-278.000
+278
-query R rowsort
+query D rowsort
select avg(engines) from aircraft
----
-2.000
+2
-query R rowsort
+query D rowsort
select avg(engines) from aircraft where engines>0
----
-2.000
+2
query III rowsort
select count(*),min(pay_load),max(pay_load) from aircraft where pay_load>0
@@ -541,12 +541,12 @@ select count(*) from flight where flight
----
279
-query TTR rowsort
+query TTD rowsort
SELECT from_airport,to_airport,avg(time_elapsed) FROM flight WHERE
from_airport='ATL' AND to_airport='BOS' group by from_airport,to_airport
----
ATL
BOS
-154.000
+154
query TR rowsort
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
