MonetDB: default - Non-hge approval of tests after removal of ge...
Changeset: 7325f1dd4d1c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/7325f1dd4d1c
Modified Files:
clients/Tests/MAL-signatures.test
sql/test/emptydb/Tests/check.stable.out
Branch: default
Log Message:
Non-hge approval of tests after removal of geometryA type.
diffs (51 lines):
diff --git a/clients/Tests/MAL-signatures.test
b/clients/Tests/MAL-signatures.test
--- a/clients/Tests/MAL-signatures.test
+++ b/clients/Tests/MAL-signatures.test
@@ -33849,11 +33849,6 @@ command geom.InteriorRingN(X_0:wkb, X_1:
wkbInteriorRingN;
Return the Nth interior linestring ring of the polygon geometry. Return NULL
if the geometry is not a polygon or the given N is out of range.
geom
-InteriorRings
-command geom.InteriorRings(X_0:wkb):wkba
-wkbInteriorRings;
-Returns an 'array' with all the interior rings of the polygon
-geom
Intersection
command geom.Intersection(X_0:wkb, X_1:wkb):wkb
wkbIntersection;
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -535,7 +535,7 @@ select 'null in fkeys.delete_action', de
[ "sys._tables", "sys", "function_languages", NULL, "TABLE",
true, "COMMIT", "READONLY", NULL]
[ "sys._tables", "sys", "function_types", NULL, "TABLE",
true, "COMMIT", "READONLY", NULL]
[ "sys._tables", "sys", "functions",NULL, "TABLE",true,
"COMMIT", "WRITABLE", NULL]
-[ "sys._tables", "sys", "geometry_columns", "create view
sys.geometry_columns as select cast(null as varchar(1)) as f_table_catalog,
s.name as f_table_schema, t.name as f_table_name, c.name as f_geometry_column,
cast(has_z(c.type_digits) + has_m(c.type_digits) +2 as integer) as
coord_dimension, c.type_scale as srid, get_type(c.type_digits, 0) as
geometry_type from sys.columns c, sys.tables t, sys.schemas s where c.table_id
= t.id and t.schema_id = s.id and c.type in (select sqlname from sys.types
where systemname in ('wkb', 'wkba'));", "VIEW", true, "COMMIT",
"WRITABLE", NULL]
+[ "sys._tables", "sys", "geometry_columns", "create view
sys.geometry_columns as select cast(null as varchar(1)) as f_table_catalog,
s.name as f_table_schema, t.name as f_table_name, c.name as f_geometry_column,
cast(has_z(c.type_digits) + has_m(c.type_digits) +2 as integer) as
coord_dimension, c.type_scale as srid, get_type(c.type_digits, 0) as
geometry_type from sys.columns c, sys.tables t, sys.schemas s where c.table_id
= t.id and t.schema_id = s.id and c.type in (select sqlname from sys.types
where systemname = 'wkb');", "VIEW", true, "COMMIT", "WRITABLE",
NULL]
[ "sys._tables", "sys", "ids", "create view sys.ids (id, name,
schema_id, table_id, table_name, obj_type, sys_table, system) as select id,
name, cast(null as int) as schema_id, cast(null as int) as table_id, cast(null
as varchar(124)) as table_name, 'author' as obj_type, 'sys.auths' as sys_table,
(name in ('public','sysadmin','monetdb','.snapshot')) as system from sys.auths
union all select id, name, cast(null as int) as schema_id, cast(null as int) as
table_id, cast(null as varchar(124)) as table_name, ifthenelse(system, 'system
schema', 'schema'), 'sys.schemas', system from sys.schemas union all select
t.id, name, t.schema_id, t.id as table_id, t.name as table_name,
cast(lower(tt.table_type_name) as varchar(40)), 'sys.tables', t.system from
sys.tables t left outer join sys.table_types tt on t.type = tt.table_type_id
union all select c.id, c.name, t.schema_id, c.table_id, t.name as table_name,
ifthenelse(t.system, 'system column', 'column'), 'sys._columns', t.system from
sys._colum
ns c join sys._tables t on c.table_id = t.id union all select c.id, c.name,
t.schema_id, c.table_id, t.name as table_name, 'column', 'tmp._columns',
t.system from tmp._columns c join tmp._tables t on c.table_id = t.id union all
select k.id, k.name, t.schema_id, k.table_id, t.name as table_name,
ifthenelse(t.system, 'system key', 'key'), 'sys.keys', t.system from sys.keys k
join sys._tables t on k.table_id = t.id union all select k.id, k.name,
t.schema_id, k.table_id, t.name as table_name, 'key', 'tmp.keys', t.system from
tmp.keys k join tmp._tables t on k.table_id = t.id union all select i.id,
i.name, t.schema_id, i.table_id, t.name as table_name, ifthenelse(t.system,
'system index', 'index'), 'sys.idxs', t.system from sys.idxs i join sys._tables
t on i.table_id = t.id union all select i.id, i.name, t.schema_id, i.table_id,
t.name as table_name, 'index' , 'tmp.idxs', t.system from tmp.idxs i join
tmp._tables t on i.table_id = t.id union all select g.id, g.name, t.schema_id,
g.table_
id, t.name as table_name, ifthenelse(t.system, 'system trigger', 'trigger'),
'sys.triggers', t.system from sys.triggers g join sys._tables t on g.table_id =
t.i
MonetDB: Aug2024 - order test results order for analytics02
Changeset: cecf7d6cbcb2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/cecf7d6cbcb2 Modified Files: sql/test/analytics/Tests/analytics02.test Branch: Aug2024 Log Message: order test results order for analytics02 diffs (truncated from 556 to 300 lines): diff --git a/sql/test/analytics/Tests/analytics02.test b/sql/test/analytics/Tests/analytics02.test --- a/sql/test/analytics/Tests/analytics02.test +++ b/sql/test/analytics/Tests/analytics02.test @@ -42,21 +42,21 @@ 32 38 query I nosort -select cast(sum(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) as bigint) from analytics +select cast(sum(aa) over (partition by bb order by bb, aa rows between 5 preceding and 0 following) as bigint) from analytics -3 +2 5 9 NULL 3 11 -15 -20 +5 +11 26 NULL query I nosort -select cast(sum(aa) over (partition by bb order by bb rows between 5 preceding and 2 following) as bigint) from analytics +select cast(sum(aa) over (partition by bb order by bb, aa rows between 5 preceding and 2 following) as bigint) from analytics 9 9 @@ -70,49 +70,49 @@ 26 NULL query I rowsort -select cast(prod(aa) over (rows between 5 preceding and 0 following) as bigint) from analytics +select cast(prod(aa) over (order by aa rows between 5 preceding and 0 following) as bigint) from analytics -1350 -15 -2880 +18 +2 +2160 360 -45 -450 -450 -576 -720 -90 +43200 +6 +72 +8640 +NULL +NULL query I rowsort -select cast(prod(aa) over (rows between 5 preceding and 2 following) as bigint) from analytics +select cast(prod(aa) over (order by aa rows between 5 preceding and 2 following) as bigint) from analytics -1350 +129600 17280 -2880 -32400 -450 -450 -5400 -576 -5760 -90 +18 +2 +2160 +259200 +360 +43200 +6 +72 query I nosort -select cast(prod(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) as bigint) from analytics +select cast(prod(aa) over (partition by bb order by bb, aa rows between 5 preceding and 0 following) as bigint) from analytics -3 +2 6 24 NULL 3 24 -15 -75 +5 +30 450 NULL query I nosort -select cast(prod(aa) over (partition by bb order by bb rows between 5 preceding and 2 following) as bigint) from analytics +select cast(prod(aa) over (partition by bb order by bb, aa rows between 5 preceding and 2 following) as bigint) from analytics 24 24 @@ -154,21 +154,21 @@ 6.250 6.667 query R nosort -select avg(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) from analytics +select avg(aa) over (partition by bb order by bb, aa rows between 5 preceding and 0 following) from analytics -3.000 +2.000 2.500 3.000 NULL 3.000 5.500 -15.000 -10.000 +5.000 +5.500 8.667 NULL query R nosort -select avg(aa) over (partition by bb order by bb rows between 5 preceding and 2 following) from analytics +select avg(aa) over (partition by bb order by bb, aa rows between 5 preceding and 2 following) from analytics 3.000 3.000 @@ -210,21 +210,21 @@ 3 3 query I nosort -select min(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) from analytics +select min(aa) over (partition by bb order by bb, aa rows between 5 preceding and 0 following) from analytics -3 +2 2 2 NULL 3 3 -15 +5 5 5 NULL query I nosort -select min(aa) over (partition by bb order by bb rows between 5 preceding and 2 following) from analytics +select min(aa) over (partition by bb order by bb, aa rows between 5 preceding and 2 following) from analytics 2 2 @@ -266,16 +266,16 @@ 8 8 query I nosort -select max(aa) over (partition by bb order by bb rows between 5 preceding and 0 following) from analytics +select max(aa) over (partition by bb order by bb, aa rows between 5 preceding and 0 following) from analytics -3 +2 3 4 NULL 3 8 -15 -15 +5 +6 15 NULL @@ -322,7 +322,7 @@ 1 1 query I nosort -select min(bb) over (partition by aa order by aa rows between 5 preceding and 0 following) from analytics +select min(bb) over (partition by aa order by aa, bb rows between 5 preceding and 0 following) from analytics 2 2 @@ -336,7 +336,7 @@ 2 3 query I nosort -select min(bb) over (partition by aa order by aa rows between 5 preceding and 2 following) from analytics +select min(bb) over (partition by aa order by aa, bb rows between 5 preceding and 2 following) from analytics 2 2 @@ -378,7 +378,7 @@ 4 4 query I nosort -select max(bb) over (partition by aa order by aa rows between 5 preceding and 0 following) from analytics +select max(bb) over (partition by aa order by aa, bb rows between 5 preceding and 0 following) from analytics 2 4 @@ -392,7 +392,7 @@ 2 3 query I nosort -select max(bb) over (partition by aa order by aa rows between 5 preceding and 2 following) from analytics +select max(bb) over (partition by aa order by aa, bb rows between 5 preceding and 2 following) fr
MonetDB: Aug2024 - merge upstream
Changeset: 35d6809ebfa7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/35d6809ebfa7
Branch: Aug2024
Log Message:
merge upstream
diffs (truncated from 441 to 300 lines):
diff --git a/monetdb5/modules/mal/Tests/toy_events
b/monetdb5/modules/mal/Tests/toy_events
deleted file mode 100644
--- a/monetdb5/modules/mal/Tests/toy_events
+++ /dev/null
@@ -1,208 +0,0 @@
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
-1,1
-2,4
-3,9
-4,16
-5,25
-6,36
-7,49
-8,64
-9,81
-10,100
-11,121
-12,144
-13,169
diff --git a/monetdb5/tools/Tests/All b/monetdb5/tools/Tests/All
--- a/monetdb5/tools/Tests/All
+++ b/monetdb5/tools/Tests/All
@@ -1,2 +1,1 @@
-mclient-t-s
HAVE_IPV6?mserver5-ipv6
diff --git a/monetdb5/tools/Tests/mclient-t-s.MAL.py
b/monetdb5/tools/Tests/mclient-t-s.MAL.py
deleted file mode 100644
--- a/monetdb5/tools/Tests/mclient-t-s.MAL.py
+++ /dev/null
@@ -1,13 +0,0 @@
-import os, sys
-try:
-from MonetDBtesting import process
-except ImportError:
-import process
-
-def client(args):
-clt = process.client('mal', args = args,
- stdout = process.PIPE, stderr = process.PIPE)
-out, err = clt.communicate()
-sys.stderr.write(err)
-
-client(['-s', 'io.print(123);'])
diff --git a/monetdb5/tools/Tests/mserver5-ipv6.py
b/monetdb5/tools/Tests/mserver5-ipv6.py
--- a/monetdb5/tools/Tests/mserver5-ipv6.py
+++ b/monetdb5/tools/Tests/mserver5-ipv6.py
@@ -5,7 +5,7 @@ except ImportError:
import process
with process.server(stdin=process.PIPE, stdout=process.PIPE,
-stderr=process.PIPE, ipv6=True) as server:
+stderr=process.PIPE, ipv6=True, mapiport=0) as server:
with process.client('sql', host='::1', server=server,
stdin=process.PIPE, stdout=process.PIPE,
stderr=process.PIPE) as client:
diff --git a/sql/test/datetime/Tests/str_to_date.test
b/sql/test/datetime/Tests/str_to_date.test
--- a/sql/test/datetime/Tests/str_to_date.test
+++ b/sql/test/datetime/Tests/str_to_date.test
@@ -1,8 +1,8 @@
statement ok
-create table idt (n int, d varchar(10), p varchar(10));
+create table idt (n int, d varchar(10), p varchar(10))
statement ok
-insert into idt values
+insert into idt values
(1, '2019-01-11', '%Y-%m-%d'),
(2, '2020-01-11', '%Y-%d-%m'),
(3, '2021-01-11', '%F')
@@ -20,11 +20,11 @@ 2021-01-11
# the CASE clause assures that we use a bat version of str_to_date which
# accept oid as arguments for the case of CASE condition (see the MAL)
query IT rowsort
-select n,
-case when n < 2 then
+select n,
+case when n < 2 then
str_to_date(d,'%Y-%m-%d')
-else
-str_to_date(d,'%Y-%m-%d')
+else
+str_to_date(d,'%Y-%m-%d')
end
from idt
@@ -35,7 +35,6 @@ 2020-01-11
3
2021-01-11
-
query IT rowsort
select n, str_to_date('1999-01-12', p) from idt
@@ -49,11 +48,11 @@ 1999-01-12
# the CASE clause assures that we use a bat version of str_to_date which
# accept oid as arguments for the case of CASE condition (see the MAL)
query IT rowsort
-select n,
-case when n < 2 then
+select n,
+case when n < 2 then
str_to_date('1999-01-12', p)
-else
-str_to_date('1999-01-12', p)
+else
+str_to_date('1999-01-12', p)
___
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
MonetDB: Aug2024 - Add *.reqtests files so that it is easier to ...
Changeset: 65912d4f9405 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/65912d4f9405 Added Files: sql/benchmarks/tpcds/Tests/alter.reqtests sql/benchmarks/tpcds/Tests/check.reqtests sql/benchmarks/tpcds/Tests/counts.reqtests sql/benchmarks/tpcds/Tests/load.reqtests sql/benchmarks/tpcds/Tests/q1.reqtests sql/benchmarks/tpcds/Tests/q10.reqtests sql/benchmarks/tpcds/Tests/q10a.reqtests sql/benchmarks/tpcds/Tests/q11.reqtests sql/benchmarks/tpcds/Tests/q12.reqtests sql/benchmarks/tpcds/Tests/q13.reqtests sql/benchmarks/tpcds/Tests/q14-1.reqtests sql/benchmarks/tpcds/Tests/q14-2.reqtests sql/benchmarks/tpcds/Tests/q14a-1.reqtests sql/benchmarks/tpcds/Tests/q14a-2.reqtests sql/benchmarks/tpcds/Tests/q15.reqtests sql/benchmarks/tpcds/Tests/q16.reqtests sql/benchmarks/tpcds/Tests/q17.reqtests sql/benchmarks/tpcds/Tests/q18.reqtests sql/benchmarks/tpcds/Tests/q18a.reqtests sql/benchmarks/tpcds/Tests/q19.reqtests sql/benchmarks/tpcds/Tests/q2.reqtests sql/benchmarks/tpcds/Tests/q20.reqtests sql/benchmarks/tpcds/Tests/q21.reqtests sql/benchmarks/tpcds/Tests/q22.reqtests sql/benchmarks/tpcds/Tests/q22a.reqtests sql/benchmarks/tpcds/Tests/q23-1.reqtests sql/benchmarks/tpcds/Tests/q23-2.reqtests sql/benchmarks/tpcds/Tests/q24-1.reqtests sql/benchmarks/tpcds/Tests/q24-2.reqtests sql/benchmarks/tpcds/Tests/q25.reqtests sql/benchmarks/tpcds/Tests/q26.reqtests sql/benchmarks/tpcds/Tests/q27.reqtests sql/benchmarks/tpcds/Tests/q27a.reqtests sql/benchmarks/tpcds/Tests/q28.reqtests sql/benchmarks/tpcds/Tests/q29.reqtests sql/benchmarks/tpcds/Tests/q3.reqtests sql/benchmarks/tpcds/Tests/q30.reqtests sql/benchmarks/tpcds/Tests/q31.reqtests sql/benchmarks/tpcds/Tests/q32.reqtests sql/benchmarks/tpcds/Tests/q33.reqtests sql/benchmarks/tpcds/Tests/q34.reqtests sql/benchmarks/tpcds/Tests/q35.reqtests sql/benchmarks/tpcds/Tests/q35a.reqtests sql/benchmarks/tpcds/Tests/q36.reqtests sql/benchmarks/tpcds/Tests/q36a.reqtests sql/benchmarks/tpcds/Tests/q37.reqtests sql/benchmarks/tpcds/Tests/q38.reqtests sql/benchmarks/tpcds/Tests/q39-1.reqtests sql/benchmarks/tpcds/Tests/q39-2.reqtests sql/benchmarks/tpcds/Tests/q4.reqtests sql/benchmarks/tpcds/Tests/q40.reqtests sql/benchmarks/tpcds/Tests/q41.reqtests sql/benchmarks/tpcds/Tests/q42.reqtests sql/benchmarks/tpcds/Tests/q43.reqtests sql/benchmarks/tpcds/Tests/q44.reqtests sql/benchmarks/tpcds/Tests/q45.reqtests sql/benchmarks/tpcds/Tests/q46.reqtests sql/benchmarks/tpcds/Tests/q47.reqtests sql/benchmarks/tpcds/Tests/q48.reqtests sql/benchmarks/tpcds/Tests/q49.reqtests sql/benchmarks/tpcds/Tests/q5.reqtests sql/benchmarks/tpcds/Tests/q50.reqtests sql/benchmarks/tpcds/Tests/q51.reqtests sql/benchmarks/tpcds/Tests/q51a.reqtests sql/benchmarks/tpcds/Tests/q52.reqtests sql/benchmarks/tpcds/Tests/q53.reqtests sql/benchmarks/tpcds/Tests/q54.reqtests sql/benchmarks/tpcds/Tests/q55.reqtests sql/benchmarks/tpcds/Tests/q56.reqtests sql/benchmarks/tpcds/Tests/q57.reqtests sql/benchmarks/tpcds/Tests/q58.reqtests sql/benchmarks/tpcds/Tests/q59.reqtests sql/benchmarks/tpcds/Tests/q5a.reqtests sql/benchmarks/tpcds/Tests/q6.reqtests sql/benchmarks/tpcds/Tests/q60.reqtests sql/benchmarks/tpcds/Tests/q61.reqtests sql/benchmarks/tpcds/Tests/q62.reqtests sql/benchmarks/tpcds/Tests/q63.reqtests sql/benchmarks/tpcds/Tests/q64.reqtests sql/benchmarks/tpcds/Tests/q65.reqtests sql/benchmarks/tpcds/Tests/q66.reqtests sql/benchmarks/tpcds/Tests/q67.reqtests sql/benchmarks/tpcds/Tests/q67a.reqtests sql/benchmarks/tpcds/Tests/q68.reqtests sql/benchmarks/tpcds/Tests/q69.reqtests sql/benchmarks/tpcds/Tests/q7.reqtests sql/benchmarks/tpcds/Tests/q70.reqtests sql/benchmarks/tpcds/Tests/q70a.reqtests sql/benchmarks/tpcds/Tests/q71.reqtests sql/benchmarks/tpcds/Tests/q72.reqtests sql/benchmarks/tpcds/Tests/q73.reqtests sql/benchmarks/tpcds/Tests/q74.reqtests sql/benchmarks/tpcds/Tests/q75.reqtests sql/benchmarks/tpcds/Tests/q76.reqtests sql/benchmarks/tpcds/Tests/q77.reqtests sql/benchmarks/tpcds/Tests/q77a.reqtests sql/benchmarks/tpcds/Tests/q78.reqtests sql/benchmarks/tpcds/Tests/q79.reqtests sql/benchmarks/tpcds/Tests/q8.reqtests sql/benchmarks/tpcds/Tests/q80.reqtests sql/benchmarks/tpcds/Tests/q80a.reqtests sql/
