Changeset: e87b451b7b12 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e87b451b7b12
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/SQL-dump.stable.out
clients/Tests/SQL-dump.stable.out.int128
Branch: default
Log Message:
approved output
diffs (truncated from 1536 to 300 lines):
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -2735,6 +2735,10 @@ command batsql.round(v:bat[:oid,:bte],d:
address bte_bat_round_wrap;
comment round off the decimal v(d,s) to r digits behind the dot (if r < 0,
before the dot)
+command
batgeom.Contains(a:wkb,px:bat[:oid,:dbl],py:bat[:oid,:dbl]):bat[:oid,:bit]
+address wkbContains_point_bat;
+comment Returns true if the Geometry-BAT a 'spatially contains' Geometry-B b
+
command batgeom.point(x:bat[:oid,:dbl],y:bat[:oid,:dbl]):bat[:oid,:wkb]
address wkbcreatepoint_bat;
comment Construct a point-BAT from two geometry-BATs
@@ -38076,6 +38080,10 @@ command geom.ConvexHull(a:wkb):wkb
address wkbConvexHull;
comment Returns a geometry that represents the convex hull of this geometry.
+command geom.Contains(a:wkb,x:dbl,y:dbl):bit
+address wkbContains_point;
+comment Returns true if the Geometry a 'spatially contains' Geometry b
+
command geom.Contains(a:wkb,b:wkb):bit
address wkbContains;
comment Returns true if the Geometry a 'spatially contains' Geometry b
diff --git a/clients/Tests/MAL-signatures.stable.out.int128
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -3258,6 +3258,10 @@ command batsql.round(v:bat[:oid,:bte],d:
address bte_bat_round_wrap;
comment round off the decimal v(d,s) to r digits behind the dot (if r < 0,
before the dot)
+command
batgeom.Contains(a:wkb,px:bat[:oid,:dbl],py:bat[:oid,:dbl]):bat[:oid,:bit]
+address wkbContains_point_bat;
+comment Returns true if the Geometry-BAT a 'spatially contains' Geometry-B b
+
command batgeom.point(x:bat[:oid,:dbl],y:bat[:oid,:dbl]):bat[:oid,:wkb]
address wkbcreatepoint_bat;
comment Construct a point-BAT from two geometry-BATs
@@ -48995,6 +48999,10 @@ command geom.ConvexHull(a:wkb):wkb
address wkbConvexHull;
comment Returns a geometry that represents the convex hull of this geometry.
+command geom.Contains(a:wkb,x:dbl,y:dbl):bit
+address wkbContains_point;
+comment Returns true if the Geometry a 'spatially contains' Geometry b
+
command geom.Contains(a:wkb,b:wkb):bit
address wkbContains;
comment Returns true if the Geometry a 'spatially contains' Geometry b
diff --git a/clients/Tests/SQL-dump.stable.out
b/clients/Tests/SQL-dump.stable.out
--- a/clients/Tests/SQL-dump.stable.out
+++ b/clients/Tests/SQL-dump.stable.out
@@ -528,6 +528,7 @@ begin
end case;
end;
create function contains(a geometry, b geometry) returns boolean external name
geom."Contains";
+create function contains(a geometry, x double, y double) returns boolean
external name geom."Contains";
create function convexhull(a geometry) returns geometry external name
geom."ConvexHull";
create aggregate corr(e1 tinyint, e2 tinyint) returns tinyint
external name "aggr"."corr";
diff --git a/clients/Tests/SQL-dump.stable.out.int128
b/clients/Tests/SQL-dump.stable.out.int128
--- a/clients/Tests/SQL-dump.stable.out.int128
+++ b/clients/Tests/SQL-dump.stable.out.int128
@@ -524,6 +524,7 @@ begin
end case;
end;
create function contains(a geometry, b geometry) returns boolean external name
geom."Contains";
+create function contains(a geometry, x double, y double) returns boolean
external name geom."Contains";
create function convexhull(a geometry) returns geometry external name
geom."ConvexHull";
create aggregate corr(e1 tinyint, e2 tinyint) returns tinyint
external name "aggr"."corr";
@@ -1610,130 +1611,130 @@ 6246 "progress" "int" 32 0 6250
NULL tru
6247 "status" "clob" 0 0 6250 NULL true 5
NULL
6248 "tag" "oid" 63 0 6250 NULL true 6 NULL
6249 "query" "clob" 0 0 6250 NULL true 7 NULL
-6915 "keyword" "varchar" 40 0 6918 NULL false
0 NULL
-6920 "table_type_id" "smallint" 16 0 6926 NULL false
0 NULL
-6923 "table_type_name" "varchar" 25 0 6926 NULL
false 1 NULL
-6928 "dependency_type_id" "smallint" 16 0 6934 NULL
false 0 NULL
-6931 "dependency_type_name" "varchar" 15 0 6934 NULL
false 1 NULL
-6949 "file_id" "int" 32 0 6951 NULL true 0
NULL
-6950 "location" "char" 256 0 6951 NULL true 1
NULL
-6953 "dim_id" "int" 32 0 6957 NULL true 0
NULL
-6954 "file_id" "int" 32 0 6957 NULL true 1
NULL
-6955 "name" "varchar" 64 0 6957 NULL true 2
NULL
-6956 "length" "int" 32 0 6957 NULL true 3
NULL
-6959 "var_id" "int" 32 0 6965 NULL true 0
NULL
-6960 "file_id" "int" 32 0 6965 NULL true 1
NULL
-6961 "name" "varchar" 64 0 6965 NULL true 2
NULL
-6962 "vartype" "varchar" 64 0 6965 NULL true
3 NULL
-6963 "ndim" "int" 32 0 6965 NULL true 4 NULL
-6964 "coord_dim_id" "int" 32 0 6965 NULL true 5
NULL
-6967 "var_id" "int" 32 0 6971 NULL true 0
NULL
-6968 "dim_id" "int" 32 0 6971 NULL true 1
NULL
-6969 "file_id" "int" 32 0 6971 NULL true 2
NULL
-6970 "dimpos" "int" 32 0 6971 NULL true 3
NULL
-6973 "obj_name" "varchar" 256 0 6979 NULL true
0 NULL
-6974 "att_name" "varchar" 256 0 6979 NULL true
1 NULL
-6975 "att_type" "varchar" 64 0 6979 NULL true
2 NULL
-6976 "value" "clob" 0 0 6979 NULL true 3 NULL
-6977 "file_id" "int" 32 0 6979 NULL true 4
NULL
-6978 "gr_name" "varchar" 256 0 6979 NULL true
5 NULL
-7004 "schema" "clob" 0 0 7018 NULL true 0
NULL
-7005 "table" "clob" 0 0 7018 NULL true 1 NULL
-7006 "column" "clob" 0 0 7018 NULL true 2
NULL
-7007 "type" "clob" 0 0 7018 NULL true 3 NULL
-7008 "mode" "clob" 0 0 7018 NULL true 4 NULL
-7009 "location" "clob" 0 0 7018 NULL true 5
NULL
-7010 "count" "bigint" 64 0 7018 NULL true 6
NULL
-7011 "typewidth" "int" 32 0 7018 NULL true 7
NULL
-7012 "columnsize" "bigint" 64 0 7018 NULL true
8 NULL
-7013 "heapsize" "bigint" 64 0 7018 NULL true
9 NULL
-7014 "hashes" "bigint" 64 0 7018 NULL true
10 NULL
-7015 "phash" "boolean" 1 0 7018 NULL true 11
NULL
-7016 "imprints" "bigint" 64 0 7018 NULL true
12 NULL
-7017 "sorted" "boolean" 1 0 7018 NULL true
13 NULL
-7020 "schema" "clob" 0 0 7030 NULL true 0
NULL
-7021 "table" "clob" 0 0 7030 NULL true 1 NULL
-7022 "column" "clob" 0 0 7030 NULL true 2
NULL
-7023 "type" "clob" 0 0 7030 NULL true 3 NULL
-7024 "typewidth" "int" 32 0 7030 NULL true 4
NULL
-7025 "count" "bigint" 64 0 7030 NULL true 5
NULL
-7026 "distinct" "bigint" 64 0 7030 NULL true
6 NULL
-7027 "atomwidth" "int" 32 0 7030 NULL true 7
NULL
-7028 "reference" "boolean" 1 0 7030 NULL true
8 NULL
-7029 "sorted" "boolean" 1 0 7030 NULL true
9 NULL
-7068 "schema" "clob" 0 0 7078 NULL true 0
NULL
-7069 "table" "clob" 0 0 7078 NULL true 1 NULL
-7070 "column" "clob" 0 0 7078 NULL true 2
NULL
-7071 "type" "clob" 0 0 7078 NULL true 3 NULL
-7072 "count" "bigint" 64 0 7078 NULL true 4
NULL
-7073 "columnsize" "bigint" 64 0 7078 NULL true
5 NULL
-7074 "heapsize" "bigint" 64 0 7078 NULL true
6 NULL
-7075 "hashes" "bigint" 64 0 7078 NULL true
7 NULL
-7076 "imprints" "bigint" 64 0 7078 NULL true
8 NULL
-7077 "sorted" "boolean" 1 0 7078 NULL true
9 NULL
-7080 "schema" "clob" 0 0 7088 NULL true 0
NULL
-7081 "table" "clob" 0 0 7088 NULL true 1 NULL
-7082 "count" "bigint" 64 0 7088 NULL true 2
NULL
-7083 "columnsize" "hugeint" 128 0 7088 NULL true
3 NULL
-7084 "heapsize" "hugeint" 128 0 7088 NULL true
4 NULL
-7085 "hashes" "hugeint" 128 0 7088 NULL true
5 NULL
-7086 "imprints" "hugeint" 128 0 7088 NULL true
6 NULL
-7087 "auxiliary" "hugeint" 128 0 7088 NULL true
7 NULL
-7090 "column_id" "int" 32 0 7101 NULL true 0
NULL
-7091 "type" "clob" 0 0 7101 NULL true 1 NULL
-7092 "width" "int" 32 0 7101 NULL true 2 NULL
-7093 "stamp" "timestamp" 7 0 7101 NULL true 3
NULL
-7094 "sample" "bigint" 64 0 7101 NULL true
4 NULL
-7095 "count" "bigint" 64 0 7101 NULL true 5
NULL
-7096 "unique" "bigint" 64 0 7101 NULL true
6 NULL
-7097 "nils" "bigint" 64 0 7101 NULL true 7
NULL
-7098 "minval" "clob" 0 0 7101 NULL true 8
NULL
-7099 "maxval" "clob" 0 0 7101 NULL true 9
NULL
-7100 "sorted" "boolean" 1 0 7101 NULL true
10 NULL
-7191 "file_id" "bigint" 64 0 7199 NULL false
0 NULL
-7192 "file_location" "clob" 0 0 7199 NULL false 1
NULL
-7193 "dbschema" "smallint" 16 0 7199 NULL false
2 NULL
-7194 "format_version" "varchar" 7 0 7199 NULL
true 3 NULL
-7195 "sorting_order" "varchar" 10 0 7199 NULL true
4 NULL
-7196 "comments" "clob" 0 0 7199 NULL true 5
NULL
-7201 "sn" "clob" 0 0 7212 NULL false 0 NULL
-7202 "file_id" "bigint" 64 0 7212 NULL false
1 NULL
-7203 "ln" "int" 32 0 7212 NULL true 2 NULL
-7204 "as" "int" 32 0 7212 NULL true 3 NULL
-7205 "m5" "clob" 0 0 7212 NULL true 4 NULL
-7206 "sp" "clob" 0 0 7212 NULL true 5 NULL
-7207 "ur" "clob" 0 0 7212 NULL true 6 NULL
-7214 "id" "clob" 0 0 7231 NULL false 0 NULL
-7215 "file_id" "bigint" 64 0 7231 NULL false
1 NULL
-7216 "cn" "clob" 0 0 7231 NULL true 2 NULL
-7217 "ds" "clob" 0 0 7231 NULL true 3 NULL
-7218 "dt" "timestamp" 7 0 7231 NULL true 4
NULL
-7219 "fo" "clob" 0 0 7231 NULL true 5 NULL
-7220 "ks" "clob" 0 0 7231 NULL true 6 NULL
-7221 "lb" "clob" 0 0 7231 NULL true 7 NULL
-7222 "pg" "clob" 0 0 7231 NULL true 8 NULL
-7223 "pi" "int" 32 0 7231 NULL true 9 NULL
-7224 "pl" "clob" 0 0 7231 NULL true 10 NULL
-7225 "pu" "clob" 0 0 7231 NULL true 11 NULL
-7226 "sm" "clob" 0 0 7231 NULL true 12 NULL
-7233 "id" "clob" 0 0 7243 NULL false 0 NULL
-7234 "file_id" "bigint" 64 0 7243 NULL false
1 NULL
-7235 "pn" "clob" 0 0 7243 NULL true 2 NULL
-7236 "cl" "clob" 0 0 7243 NULL true 3 NULL
-7237 "pp" "clob" 0 0 7243 NULL true 4 NULL
-7238 "vn" "clob" 0 0 7243 NULL true 5 NULL
-7245 "qname" "clob" 0 0 7256 NULL false 0 NULL
-7246 "flag" "smallint" 16 0 7256 NULL false 1
NULL
-7247 "rname" "clob" 0 0 7256 NULL false 2 NULL
-7248 "pos" "int" 32 0 7256 NULL false 3 NULL
-7249 "mapq" "smallint" 16 0 7256 NULL false 4
NULL
-7250 "cigar" "clob" 0 0 7256 NULL false 5 NULL
-7251 "rnext" "clob" 0 0 7256 NULL false 6 NULL
-7252 "pnext" "int" 32 0 7256 NULL false 7 NULL
-7253 "tlen" "int" 32 0 7256 NULL false 8 NULL
-7254 "seq" "clob" 0 0 7256 NULL false 9 NULL
-7255 "qual" "clob" 0 0 7256 NULL false 10 NULL
-7337 "function_id" "int" 32 0 7338 NULL true 0
NULL
+6921 "keyword" "varchar" 40 0 6924 NULL false
0 NULL
+6926 "table_type_id" "smallint" 16 0 6932 NULL false
0 NULL
+6929 "table_type_name" "varchar" 25 0 6932 NULL
false 1 NULL
+6934 "dependency_type_id" "smallint" 16 0 6940 NULL
false 0 NULL
+6937 "dependency_type_name" "varchar" 15 0 6940 NULL
false 1 NULL
+6955 "file_id" "int" 32 0 6957 NULL true 0
NULL
+6956 "location" "char" 256 0 6957 NULL true 1
NULL
+6959 "dim_id" "int" 32 0 6963 NULL true 0
NULL
+6960 "file_id" "int" 32 0 6963 NULL true 1
NULL
+6961 "name" "varchar" 64 0 6963 NULL true 2
NULL
+6962 "length" "int" 32 0 6963 NULL true 3
NULL
+6965 "var_id" "int" 32 0 6971 NULL true 0
NULL
+6966 "file_id" "int" 32 0 6971 NULL true 1
NULL
+6967 "name" "varchar" 64 0 6971 NULL true 2
NULL
+6968 "vartype" "varchar" 64 0 6971 NULL true
3 NULL
+6969 "ndim" "int" 32 0 6971 NULL true 4 NULL
+6970 "coord_dim_id" "int" 32 0 6971 NULL true 5
NULL
+6973 "var_id" "int" 32 0 6977 NULL true 0
NULL
+6974 "dim_id" "int" 32 0 6977 NULL true 1
NULL
+6975 "file_id" "int" 32 0 6977 NULL true 2
NULL
+6976 "dimpos" "int" 32 0 6977 NULL true 3
NULL
+6979 "obj_name" "varchar" 256 0 6985 NULL true
0 NULL
+6980 "att_name" "varchar" 256 0 6985 NULL true
1 NULL
+6981 "att_type" "varchar" 64 0 6985 NULL true
2 NULL
+6982 "value" "clob" 0 0 6985 NULL true 3 NULL
+6983 "file_id" "int" 32 0 6985 NULL true 4
NULL
+6984 "gr_name" "varchar" 256 0 6985 NULL true
5 NULL
+7010 "schema" "clob" 0 0 7024 NULL true 0
NULL
+7011 "table" "clob" 0 0 7024 NULL true 1 NULL
+7012 "column" "clob" 0 0 7024 NULL true 2
NULL
+7013 "type" "clob" 0 0 7024 NULL true 3 NULL
+7014 "mode" "clob" 0 0 7024 NULL true 4 NULL
+7015 "location" "clob" 0 0 7024 NULL true 5
NULL
+7016 "count" "bigint" 64 0 7024 NULL true 6
NULL
+7017 "typewidth" "int" 32 0 7024 NULL true 7
NULL
+7018 "columnsize" "bigint" 64 0 7024 NULL true
8 NULL
+7019 "heapsize" "bigint" 64 0 7024 NULL true
9 NULL
+7020 "hashes" "bigint" 64 0 7024 NULL true
10 NULL
+7021 "phash" "boolean" 1 0 7024 NULL true 11
NULL
+7022 "imprints" "bigint" 64 0 7024 NULL true
12 NULL
+7023 "sorted" "boolean" 1 0 7024 NULL true
13 NULL
+7026 "schema" "clob" 0 0 7036 NULL true 0
NULL
+7027 "table" "clob" 0 0 7036 NULL true 1 NULL
+7028 "column" "clob" 0 0 7036 NULL true 2
NULL
+7029 "type" "clob" 0 0 7036 NULL true 3 NULL
+7030 "typewidth" "int" 32 0 7036 NULL true 4
NULL
+7031 "count" "bigint" 64 0 7036 NULL true 5
NULL
+7032 "distinct" "bigint" 64 0 7036 NULL true
6 NULL
+7033 "atomwidth" "int" 32 0 7036 NULL true 7
NULL
+7034 "reference" "boolean" 1 0 7036 NULL true
8 NULL
+7035 "sorted" "boolean" 1 0 7036 NULL true
9 NULL
+7074 "schema" "clob" 0 0 7084 NULL true 0
NULL
+7075 "table" "clob" 0 0 7084 NULL true 1 NULL
+7076 "column" "clob" 0 0 7084 NULL true 2
NULL
+7077 "type" "clob" 0 0 7084 NULL true 3 NULL
+7078 "count" "bigint" 64 0 7084 NULL true 4
NULL
+7079 "columnsize" "bigint" 64 0 7084 NULL true
5 NULL
+7080 "heapsize" "bigint" 64 0 7084 NULL true
6 NULL
+7081 "hashes" "bigint" 64 0 7084 NULL true
7 NULL
+7082 "imprints" "bigint" 64 0 7084 NULL true
8 NULL
+7083 "sorted" "boolean" 1 0 7084 NULL true
9 NULL
+7086 "schema" "clob" 0 0 7094 NULL true 0
NULL
+7087 "table" "clob" 0 0 7094 NULL true 1 NULL
+7088 "count" "bigint" 64 0 7094 NULL true 2
NULL
+7089 "columnsize" "hugeint" 128 0 7094 NULL true
3 NULL
+7090 "heapsize" "hugeint" 128 0 7094 NULL true
4 NULL
+7091 "hashes" "hugeint" 128 0 7094 NULL true
5 NULL
+7092 "imprints" "hugeint" 128 0 7094 NULL true
6 NULL
+7093 "auxiliary" "hugeint" 128 0 7094 NULL true
7 NULL
+7096 "column_id" "int" 32 0 7107 NULL true 0
NULL
+7097 "type" "clob" 0 0 7107 NULL true 1 NULL
+7098 "width" "int" 32 0 7107 NULL true 2 NULL
+7099 "stamp" "timestamp" 7 0 7107 NULL true 3
NULL
+7100 "sample" "bigint" 64 0 7107 NULL true
4 NULL
+7101 "count" "bigint" 64 0 7107 NULL true 5
NULL
+7102 "unique" "bigint" 64 0 7107 NULL true
6 NULL
+7103 "nils" "bigint" 64 0 7107 NULL true 7
NULL
+7104 "minval" "clob" 0 0 7107 NULL true 8
NULL
+7105 "maxval" "clob" 0 0 7107 NULL true 9
NULL
+7106 "sorted" "boolean" 1 0 7107 NULL true
10 NULL
+7197 "file_id" "bigint" 64 0 7205 NULL false
0 NULL
+7198 "file_location" "clob" 0 0 7205 NULL false 1
NULL
+7199 "dbschema" "smallint" 16 0 7205 NULL false
2 NULL
+7200 "format_version" "varchar" 7 0 7205 NULL
true 3 NULL
+7201 "sorting_order" "varchar" 10 0 7205 NULL true
4 NULL
+7202 "comments" "clob" 0 0 7205 NULL true 5
NULL
+7207 "sn" "clob" 0 0 7218 NULL false 0 NULL
+7208 "file_id" "bigint" 64 0 7218 NULL false
1 NULL
+7209 "ln" "int" 32 0 7218 NULL true 2 NULL
+7210 "as" "int" 32 0 7218 NULL true 3 NULL
+7211 "m5" "clob" 0 0 7218 NULL true 4 NULL
+7212 "sp" "clob" 0 0 7218 NULL true 5 NULL
+7213 "ur" "clob" 0 0 7218 NULL true 6 NULL
+7220 "id" "clob" 0 0 7237 NULL false 0 NULL
+7221 "file_id" "bigint" 64 0 7237 NULL false
1 NULL
+7222 "cn" "clob" 0 0 7237 NULL true 2 NULL
+7223 "ds" "clob" 0 0 7237 NULL true 3 NULL
+7224 "dt" "timestamp" 7 0 7237 NULL true 4
NULL
+7225 "fo" "clob" 0 0 7237 NULL true 5 NULL
+7226 "ks" "clob" 0 0 7237 NULL true 6 NULL
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
