geospatial

statement ok
CREATE TABLE geo_table(
  id int primary key,
  geog geography(geometry, 4326),
  geom geometry(point),
  orphan geography,
  FAMILY f (orphan)
)

statement ok
INSERT INTO geo_table VALUES
  (1, 'POINT(1.0 1.0)', 'POINT(2.0 2.0)', 'POINT(3.0 3.0)'),
  (2, 'LINESTRING(1.0 1.0, 2.0 2.0)', 'POINT(1.0 1.0)', 'POINT(3.0 3.0)')

statement error SRID 4004 does not match column SRID 4326
INSERT INTO geo_table (id, geog) VALUES
  (3, 'SRID=4004;POINT(1.0 2.0)')

statement error type LineString does not match column type Point
INSERT INTO geo_table (id, geom) VALUES
  (3, 'SRID=4004;LINESTRING(0.0 0.0, 1.0 2.0)')

statement error unknown SRID for Geometry: 404
SELECT 'SRID=404;POINT(1.0 2.0)'::geometry

statement error unknown SRID for Geography: 404
SELECT 'SRID=404;POINT(1.0 2.0)'::geography

statement ok
CREATE INDEX geo_table_geom_idx ON geo_table USING GIST(geom)

statement ok
CREATE INDEX geo_table_geog_idx ON geo_table USING GIST(geog)

statement ok
CREATE TABLE geom_table_negative_values(
  a geometry(geometry, -1)
)

statement ok
CREATE TABLE geom_table_public_schema (
  geom public.geometry,
  geog public.geography
)

statement ok
INSERT INTO geom_table_public_schema VALUES ('POINT(1 0)', 'POINT(3 2)')

query TT
SELECT ST_AsText(geom), ST_AsText(geog) FROM geom_table_public_schema
----
POINT (1 0)  POINT (3 2)

statement ok
SET experimental_enable_enums = true

statement error type .*geometry.* already exists
CREATE TYPE geometry AS enum('no')

statement error type .*geography.* already exists
CREATE TYPE geography AS enum('no')

statement error type .*geometry.* already exists
CREATE TABLE geometry (a geometry)

statement error type .*geography.* already exists
CREATE TABLE geography (a geography)

query T
SELECT create_statement FROM [SHOW CREATE TABLE geom_table_negative_values]
----
CREATE TABLE public.geom_table_negative_values (
   a GEOMETRY(GEOMETRY) NULL,
   FAMILY "primary" (a, rowid)
)

statement ok
CREATE TABLE geog_table_negative_values(
  a geography(geometry, -1)
)

query T
SELECT create_statement FROM [SHOW CREATE TABLE geog_table_negative_values]
----
CREATE TABLE public.geog_table_negative_values (
   a GEOGRAPHY(GEOMETRY) NULL,
   FAMILY "primary" (a, rowid)
)

statement error SRID 3857 cannot be used for geography as it is not in a lon/lat coordinate system
SELECT 'SRID=3857;POINT(1.0 2.0)'::geography

query BTT
SELECT
  PostGIS_HasBBox(geom),
  PostGIS_AddBBox(geom),
  PostGIS_DropBBox(geom)
FROM geo_table
ORDER BY id ASC
----
false  010100000000000000000000400000000000000040  010100000000000000000000400000000000000040
false  0101000000000000000000F03F000000000000F03F  0101000000000000000000F03F000000000000F03F

query ITTT rowsort
SELECT * FROM geo_table
----
1  0101000020E6100000000000000000F03F000000000000F03F                                          010100000000000000000000400000000000000040  0101000020E610000000000000000008400000000000000840
2  0102000020E610000002000000000000000000F03F000000000000F03F00000000000000400000000000000040  0101000000000000000000F03F000000000000F03F  0101000020E610000000000000000008400000000000000840

query T rowsort
SELECT orphan FROM geo_table
----
0101000020E610000000000000000008400000000000000840
0101000020E610000000000000000008400000000000000840

query TTBTTTB rowsort
SHOW COLUMNS FROM geo_table
----
id      INT8                      false  NULL  ·  {primary,geo_table_geom_idx,geo_table_geog_idx}  false
geog    GEOGRAPHY(GEOMETRY,4326)  true   NULL  ·  {geo_table_geog_idx}                             false
geom    GEOMETRY(POINT)           true   NULL  ·  {geo_table_geom_idx}                             false
orphan  GEOGRAPHY                 true   NULL  ·  {}                                               false

statement error column bad_pk is of type geography and thus is not indexable
CREATE TABLE bad_geog_table(bad_pk geography primary key)

statement error column bad_pk is of type geometry and thus is not indexable
CREATE TABLE bad_geom_table(bad_pk geometry primary key)

statement error column geog is of type geography and thus is not indexable
CREATE INDEX geog_idx ON geo_table(geog)

statement error column geom is of type geometry and thus is not indexable
CREATE INDEX geom_idx ON geo_table(geom)

statement ok
CREATE INVERTED INDEX geog_idx ON geo_table(geog)

statement ok
CREATE INVERTED INDEX geom_idx ON geo_table(geom)

statement ok
INSERT INTO geo_table VALUES
  (3, 'POINT(-1.25 3.375)', 'POINT(2.220 -2.445)', 'POINT(3.0 -3.710)')

query ITTT rowsort
SELECT * FROM geo_table
----
1  0101000020E6100000000000000000F03F000000000000F03F                                          010100000000000000000000400000000000000040  0101000020E610000000000000000008400000000000000840
2  0102000020E610000002000000000000000000F03F000000000000F03F00000000000000400000000000000040  0101000000000000000000F03F000000000000F03F  0101000020E610000000000000000008400000000000000840
3  0101000020E6100000000000000000F4BF0000000000000B40                                          0101000000C3F5285C8FC201408FC2F5285C8F03C0  0101000020E61000000000000000000840AE47E17A14AE0DC0

statement ok
CREATE TABLE geo_array_table(id int, geog geography array, geom geometry array)

statement ok
INSERT INTO geo_array_table VALUES (
  1,
  array['POINT(1.0 1.0)'::geography, 'LINESTRING(2.0 2.0, 3.0 3.0)'::geography],
  array['POINT(1.0 1.0)'::geometry, 'LINESTRING(2.0 2.0, 3.0 3.0)'::geometry]
)

query ITT
SELECT * FROM geo_array_table
----
1  {0101000020E6100000000000000000F03F000000000000F03F,0102000020E6100000020000000000000000000040000000000000004000000000000008400000000000000840}  {0101000000000000000000F03F000000000000F03F,0102000000020000000000000000000040000000000000004000000000000008400000000000000840}

query TT
SELECT NULL::geometry, NULL::geography
----
NULL  NULL

query T
SELECT ST_AsText(p) FROM (VALUES
  (ST_Point(1, 2)),
  (ST_Point(3, 4))
) tbl(p)
----
POINT (1 2)
POINT (3 4)

query T
SELECT ST_AsText(p) FROM (VALUES
  ('POINT(200 200)'::geography),
  ('POLYGON((200 200, 200 200, 200 200, 200 200))'::geography),
  ('GEOMETRYCOLLECTION(POINT (200 200), POLYGON((200 200, 200 200, 200 200, 200 200, 200 200)))'::geography),
  ('MULTIPOLYGON(((200 200,200 200, 200 200, 200 200)),((200 200,200 200,200 200,200 200)))'::geography)
) tbl(p)
----
POINT (-160 -20)
POLYGON ((-160 -20, -160 -20, -160 -20, -160 -20))
GEOMETRYCOLLECTION (POINT (-160 -20), POLYGON ((-160 -20, -160 -20, -160 -20, -160 -20, -160 -20)))
MULTIPOLYGON (((-160 -20, -160 -20, -160 -20, -160 -20)), ((-160 -20, -160 -20, -160 -20, -160 -20)))

query T
SELECT ST_AsText(p) FROM (VALUES
  ('POINT(200 200)'::geometry),
  ('POLYGON((200 200, 200 200, 200 200, 200 200))'::geometry),
  ('GEOMETRYCOLLECTION(POINT (200 200), POLYGON((200 200, 200 200, 200 200, 200 200, 200 200)))'::geometry),
  ('MULTIPOLYGON(((200 200,200 200, 200 200, 200 200)),((200 200,200 200,200 200,200 200)))'::geometry)
) tbl(p)
----
POINT (200 200)
POLYGON ((200 200, 200 200, 200 200, 200 200))
GEOMETRYCOLLECTION (POINT (200 200), POLYGON ((200 200, 200 200, 200 200, 200 200, 200 200)))
MULTIPOLYGON (((200 200, 200 200, 200 200, 200 200)), ((200 200, 200 200, 200 200, 200 200)))

query T
SELECT ST_AsText(ST_Project('POINT(0 0)'::geography, 100000, radians(45.0)))
----
POINT (0.635231029125537 0.639472334729198)

statement error arguments must be POINT geometries
SELECT ST_Azimuth('POLYGON((0 0, 0 0, 0 0, 0 0))'::geometry, 'POLYGON((0 0, 0 0, 0 0, 0 0))'::geometry)

query RR
SELECT
	degrees(ST_Azimuth(ST_Point(25, 45), ST_Point(75, 100))) AS degA_B,
	degrees(ST_Azimuth(ST_Point(75, 100), ST_Point(25, 45))) AS degB_A
----
42.2736890060937  222.273689006094

query R
SELECT ST_Azimuth(ST_Point(0, 0), ST_Point(0, 0))
----
NULL

subtest json_test

# All values here should be true.
query BB
SELECT
  to_json(g::geometry) = st_asgeojson(g::geometry)::jsonb,
  to_json(g::geography) = st_asgeojson(g::geography)::jsonb
FROM ( VALUES
  ('POINT (30 10)'),
  ('LINESTRING (30 10, 10 30, 40 40)'),
  ('POLYGON ((35 10, 45 45, 15 40, 10 20, 35 10),(20 30, 35 35, 30 20, 20 30))'),
  ('MULTIPOINT (10 40, 40 30, 20 20, 30 10)'),
  ('MULTILINESTRING ((10 10, 20 20, 10 40), (40 40, 30 30, 40 20, 30 10))'),
  ('MULTIPOLYGON (((40 40, 20 45, 45 30, 40 40)), ((20 35, 10 30, 10 10, 30 5, 45 20, 20 35), (30 20, 20 15, 20 25, 30 20)))'),
  ('GEOMETRYCOLLECTION (POINT (40 10), LINESTRING (10 10, 20 20, 10 40), POLYGON ((40 40, 20 45, 45 30, 40 40)))')
) tbl(g)
----
true  true
true  true
true  true
true  true
true  true
true  true
true  true

subtest cast_test

query T
SELECT ST_AsEWKT(geom) FROM (VALUES
  ('SRID=4326;POINT(1.0 2.0)'::geometry::geometry(point, 4326)),
  ('SRID=4326;POINT(1.0 2.0)'::geometry::geometry(geometry, 4326)),
  ('SRID=4326;POINT(1.0 2.0)'::geography::geometry)
) t(geom)
----
SRID=4326;POINT (1 2)
SRID=4326;POINT (1 2)
SRID=4326;POINT (1 2)

query T
SELECT ST_AsEWKT(geog) FROM (VALUES
  ('POINT(1.0 2.0)'::geography::geography(point, 4326)),
  ('POINT(1.0 2.0)'::geometry::geography(point, 4326)),
  ('SRID=4004;POINT(1.0 2.0)'::geometry::geography(point, 4004)),
  ('SRID=4004;POINT(1.0 2.0)'::geometry::geography),
  ('SRID=4004;POINT(1.0 2.0)'::geography::geography(point, 4004)),
  ('SRID=4004;POINT(1.0 2.0)'::geography::geography(geometry, 4004)),
  ('POINT(1.0 2.0)'::geometry::geography),
  ('POINT(1.0 2.0)'::geometry::geography(geometry, 4326))
) t(geog)
----
SRID=4326;POINT (1 2)
SRID=4326;POINT (1 2)
SRID=4004;POINT (1 2)
SRID=4004;POINT (1 2)
SRID=4004;POINT (1 2)
SRID=4004;POINT (1 2)
SRID=4326;POINT (1 2)
SRID=4326;POINT (1 2)

statement error SRID 4004 does not match column SRID 4326
SELECT 'SRID=4004;POINT(2.0 3.0)'::geometry::geography(point, 4326)

statement error SRID 4326 does not match column SRID 4004
SELECT 'SRID=4326;POINT(2.0 3.0)'::geometry::geography(point, 4004)

statement error SRID 4326 does not match column SRID 4004
SELECT 'SRID=4326;POINT(2.0 3.0)'::geography::geography(point, 4004)

statement error SRID 4004 does not match column SRID 4326
SELECT 'SRID=4004;POINT(2.0 3.0)'::geometry::geometry(point, 4326)

statement error SRID 4004 does not match column SRID 4326
SELECT 'SRID=4004;POINT(2.0 3.0)'::geography::geometry(point, 4326)

statement error SRID 4326 does not match column SRID 4004
SELECT 'POINT(1.0 2.0)'::geometry::geography(geometry, 4004)

statement error type Point does not match column type LineString
SELECT 'SRID=4004;POINT(2.0 3.0)'::geometry::geometry(linestring)

statement error type Point does not match column type LineString
SELECT 'SRID=4004;POINT(2.0 3.0)'::geometry::geography(linestring)

statement error type Point does not match column type LineString
SELECT 'SRID=4004;POINT(2.0 3.0)'::geography::geography(linestring)

statement error type Point does not match column type LineString
SELECT 'SRID=4004;POINT(2.0 3.0)'::geography::geometry(linestring)

subtest parse_and_unparse

statement ok
CREATE TABLE parse_test (
  id SERIAL PRIMARY KEY,
  geom GEOMETRY,
  geog GEOGRAPHY
)

# These values cannot be inserted into the database due to mismatching SRIDs.
query TT
SELECT
  ST_AsEWKT(geom),
  ST_AsEWKT(geog)
FROM ( VALUES
  (ST_GeometryFromText('SRID=4326;POINT(1.0 2.0)', 4004), ST_GeographyFromText('SRID=4326;POINT(1.0 2.0)', 4004)),
  (ST_GeomFromText('SRID=4326;POINT(1.0 2.0)', 4004), ST_GeogFromText('SRID=4326;POINT(1.0 2.0)', 4004)),
  (ST_GeometryFromText('SRID=4326;POINT(1.0 2.0)'), ST_GeographyFromText('POINT(1.0 2.0)', 4004)),
  (ST_GeomFromEWKT('SRID=4004;POINT(1.0 2.0)'), ST_GeogFromEWKT('SRID=4004;POINT(1.0 2.0)')),
  (ST_GeomFromWKB(decode('0101000000000000000000F03F000000000000F03F', 'hex'), 4004), ST_GeogFromWKB(decode('0101000000000000000000F03F000000000000F03F', 'hex'), 4004)),
  (ST_GeomFromWKB(decode('0101000020E6100000000000000000F03F0000000000000040', 'hex'), 4004), ST_GeogFromWKB(decode('0101000020E6100000000000000000F03F0000000000000040', 'hex'), 4004)),
  (ST_GeomFromWKB(decode('0101000020A40F0000000000000000F03F0000000000000040', 'hex')), ST_GeogFromWKB(decode('0101000020A40F0000000000000000F03F0000000000000040', 'hex')))
) t(geom, geog)
----
SRID=4004;POINT (1 2)  SRID=4004;POINT (1 2)
SRID=4004;POINT (1 2)  SRID=4004;POINT (1 2)
SRID=4326;POINT (1 2)  SRID=4004;POINT (1 2)
SRID=4004;POINT (1 2)  SRID=4004;POINT (1 2)
SRID=4004;POINT (1 1)  SRID=4004;POINT (1 1)
SRID=4004;POINT (1 2)  SRID=4004;POINT (1 2)
SRID=4004;POINT (1 2)  SRID=4004;POINT (1 2)

statement ok
INSERT INTO parse_test (geom, geog) VALUES
  (ST_GeomFromText('POINT(1.555 -2.0)'), ST_GeogFromText('POINT(1.555 -2.0)')),
  (ST_GeomFromText('SRID=4326;POINT(1.0 2.0)'), ST_GeogFromText('SRID=4326;POINT(1.0 2.0)')),
  (ST_GeometryFromText('SRID=4004;POINT(1.0 2.0)'), ST_GeographyFromText('POINT(1.0 2.0)')),
  (ST_GeomFromGeoJSON('{"type":"Point","coordinates":[1,2]}'), ST_GeogFromGeoJSON('{"type":"Point","coordinates":[1,2]}')),
  (ST_GeomFromGeoJSON('{"type":"Point","coordinates":[1,2]}'::jsonb), ST_GeogFromGeoJSON('{"type":"Point","coordinates":[1,2]}'::jsonb)),
  (ST_GeomFromWKB(decode('0101000000000000000000F03F000000000000F03F', 'hex')), ST_GeogFromWKB(decode('0101000000000000000000F03F000000000000F03F', 'hex'))),
  (ST_GeomFromEWKB(decode('0101000000000000000000F03F000000000000F03F', 'hex')), ST_GeogFromEWKB(decode('0101000000000000000000F03F000000000000F03F', 'hex'))),
  (ST_GeomFromText('POINT EMPTY'), ST_GeogFromText('POINT EMPTY')),
  (ST_GeomFromGeoJSON('null':::jsonb), ST_GeogFromGeoJSON('null':::jsonb))

query BB
SELECT
  st_geomfromwkb(decode('0101000000000000000000F03F000000000000F03F', 'hex')) = st_wkbtosql(decode('0101000000000000000000F03F000000000000F03F', 'hex')),
  st_geomfromtext('POINT(1.0 2.0)') = st_wkttosql('POINT(1.0 2.0)')
----
true  true

query TTTTTTT
SELECT
  ST_AsText(geom),
  ST_AsEWKT(geom),
  ST_AsBinary(geom),
  ST_AsBinary(geom, 'ndr'),
  ST_AsBinary(geom, 'xdr'),
  ST_AsEWKB(geom),
  ST_AsKML(geom)
FROM parse_test ORDER BY id ASC
----
POINT (1.555 -2)                                    POINT (1.555 -2)  [1 1 0 0 0 225 122 20 174 71 225 248 63 0 0 0 0 0 0 0 192]  [1 1 0 0 0 225 122 20 174 71 225 248 63 0 0 0 0 0 0 0 192]  [0 0 0 0 1 63 248 225 71 174 20 122 225 192 0 0 0 0 0 0 0]  [1 1 0 0 0 225 122 20 174 71 225 248 63 0 0 0 0 0 0 0 192]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1.555,-2</coordinates></Point>
POINT (1 2)                                         SRID=4326;POINT (1 2)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [0 0 0 0 1 63 240 0 0 0 0 0 0 64 0 0 0 0 0 0 0]  [1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,2</coordinates></Point>
POINT (1 2)                                         SRID=4004;POINT (1 2)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [0 0 0 0 1 63 240 0 0 0 0 0 0 64 0 0 0 0 0 0 0]  [1 1 0 0 32 164 15 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,2</coordinates></Point>
POINT (1 2)                                         POINT (1 2)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [0 0 0 0 1 63 240 0 0 0 0 0 0 64 0 0 0 0 0 0 0]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,2</coordinates></Point>
POINT (1 2)                                         POINT (1 2)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [0 0 0 0 1 63 240 0 0 0 0 0 0 64 0 0 0 0 0 0 0]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,2</coordinates></Point>
POINT (1 1)                                         POINT (1 1)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  [0 0 0 0 1 63 240 0 0 0 0 0 0 63 240 0 0 0 0 0 0]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,1</coordinates></Point>
POINT (1 1)                                         POINT (1 1)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  [0 0 0 0 1 63 240 0 0 0 0 0 0 63 240 0 0 0 0 0 0]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,1</coordinates></Point>
POINT EMPTY                                         POINT EMPTY  [1 1 0 0 0 0 0 0 0 0 0 248 127 0 0 0 0 0 0 248 127]  [1 1 0 0 0 0 0 0 0 0 0 248 127 0 0 0 0 0 0 248 127]  [0 0 0 0 1 127 248 0 0 0 0 0 0 127 248 0 0 0 0 0 0]  [1 1 0 0 0 0 0 0 0 0 0 248 127 0 0 0 0 0 0 248 127]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates></coordinates></Point>
NULL                                                NULL  NULL  NULL  NULL  NULL  NULL

query TTT
SELECT ST_AsEWKT(g), ST_GeoHash(g), ST_GeoHash(g, 8) FROM ( VALUES
  ('POINT (0 0)'::geometry),
  ('LINESTRING(0 0, 1 0)'::geometry)
) t(g)
----
POINT (0 0)            s0000000000000000000  s0000000
LINESTRING (0 0, 1 0)  ·                     s00252h0

query TTT
SELECT
  ST_AsGeoJSON(geom),
  ST_AsGeoJSON(geom, 6, 8),
  ST_AsGeoJSON(geom, 6, 5)
FROM parse_test ORDER BY id ASC
----
{"type":"Point","coordinates":[1.555,-2]}                                                     {"type":"Point","coordinates":[1.555,-2]}                                                     {"type":"Point","bbox":[1.555,-2,1.555,-2],"coordinates":[1.555,-2]}
{"type":"Point","coordinates":[1,2]}                                                          {"type":"Point","coordinates":[1,2]}                                                          {"type":"Point","bbox":[1,2,1,2],"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::4326"}},"coordinates":[1,2]}
{"type":"Point","crs":{"type":"name","properties":{"name":"EPSG:4004"}},"coordinates":[1,2]}  {"type":"Point","crs":{"type":"name","properties":{"name":"EPSG:4004"}},"coordinates":[1,2]}  {"type":"Point","bbox":[1,2,1,2],"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::4004"}},"coordinates":[1,2]}
{"type":"Point","coordinates":[1,2]}                                                          {"type":"Point","coordinates":[1,2]}                                                          {"type":"Point","bbox":[1,2,1,2],"coordinates":[1,2]}
{"type":"Point","coordinates":[1,2]}                                                          {"type":"Point","coordinates":[1,2]}                                                          {"type":"Point","bbox":[1,2,1,2],"coordinates":[1,2]}
{"type":"Point","coordinates":[1,1]}                                                          {"type":"Point","coordinates":[1,1]}                                                          {"type":"Point","bbox":[1,1,1,1],"coordinates":[1,1]}
{"type":"Point","coordinates":[1,1]}                                                          {"type":"Point","coordinates":[1,1]}                                                          {"type":"Point","bbox":[1,1,1,1],"coordinates":[1,1]}
{"type":"Point","coordinates":[]}                                                             {"type":"Point","coordinates":[]}                                                             {"type":"Point","coordinates":[]}
NULL                                                                                          NULL                                                                                          NULL

statement ok
CREATE TABLE parse_test_geojson AS
  SELECT
    row_number() OVER (ORDER BY id) as id,
    geom,
    geog
  FROM parse_test

query TTT
SELECT
  ST_AsGeoJSON(parse_test_geojson.*),
  ST_AsGeoJSON(parse_test_geojson.*, 'geom'),
  ST_AsGeoJSON(parse_test_geojson.*, 'geog')
FROM parse_test_geojson ORDER BY id ASC
----
{"geometry": {"coordinates": [1.555, -2], "type": "Point"}, "properties": {"geog": {"coordinates": [1.555, -2], "type": "Point"}, "id": 1}, "type": "Feature"}  {"geometry": {"coordinates": [1.555, -2], "type": "Point"}, "properties": {"geog": {"coordinates": [1.555, -2], "type": "Point"}, "id": 1}, "type": "Feature"}  {"geometry": {"coordinates": [1.555, -2], "type": "Point"}, "properties": {"geom": {"coordinates": [1.555, -2], "type": "Point"}, "id": 1}, "type": "Feature"}
{"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 2], "type": "Point"}, "id": 2}, "type": "Feature"}            {"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 2], "type": "Point"}, "id": 2}, "type": "Feature"}            {"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geom": {"coordinates": [1, 2], "type": "Point"}, "id": 2}, "type": "Feature"}
{"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 2], "type": "Point"}, "id": 3}, "type": "Feature"}            {"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 2], "type": "Point"}, "id": 3}, "type": "Feature"}            {"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geom": {"coordinates": [1, 2], "type": "Point"}, "id": 3}, "type": "Feature"}
{"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 2], "type": "Point"}, "id": 4}, "type": "Feature"}            {"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 2], "type": "Point"}, "id": 4}, "type": "Feature"}            {"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geom": {"coordinates": [1, 2], "type": "Point"}, "id": 4}, "type": "Feature"}
{"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 2], "type": "Point"}, "id": 5}, "type": "Feature"}            {"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 2], "type": "Point"}, "id": 5}, "type": "Feature"}            {"geometry": {"coordinates": [1, 2], "type": "Point"}, "properties": {"geom": {"coordinates": [1, 2], "type": "Point"}, "id": 5}, "type": "Feature"}
{"geometry": {"coordinates": [1, 1], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 1], "type": "Point"}, "id": 6}, "type": "Feature"}            {"geometry": {"coordinates": [1, 1], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 1], "type": "Point"}, "id": 6}, "type": "Feature"}            {"geometry": {"coordinates": [1, 1], "type": "Point"}, "properties": {"geom": {"coordinates": [1, 1], "type": "Point"}, "id": 6}, "type": "Feature"}
{"geometry": {"coordinates": [1, 1], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 1], "type": "Point"}, "id": 7}, "type": "Feature"}            {"geometry": {"coordinates": [1, 1], "type": "Point"}, "properties": {"geog": {"coordinates": [1, 1], "type": "Point"}, "id": 7}, "type": "Feature"}            {"geometry": {"coordinates": [1, 1], "type": "Point"}, "properties": {"geom": {"coordinates": [1, 1], "type": "Point"}, "id": 7}, "type": "Feature"}
{"geometry": {"coordinates": [], "type": "Point"}, "properties": {"geog": {"coordinates": [], "type": "Point"}, "id": 8}, "type": "Feature"}                    {"geometry": {"coordinates": [], "type": "Point"}, "properties": {"geog": {"coordinates": [], "type": "Point"}, "id": 8}, "type": "Feature"}                    {"geometry": {"coordinates": [], "type": "Point"}, "properties": {"geom": {"coordinates": [], "type": "Point"}, "id": 8}, "type": "Feature"}
{"geometry": {"type": null}, "properties": {"geog": null, "geom": null, "id": 9}, "type": "Feature"}                                                            {"geometry": {"type": null}, "properties": {"geog": null, "id": 9}, "type": "Feature"}                                                                          {"geometry": {"type": null}, "properties": {"geom": null, "id": 9}, "type": "Feature"}

query T
SELECT
  ST_AsGeoJSON(parse_test_geojson.*, 'geog', 3, true)
FROM parse_test_geojson ORDER BY id ASC
----
{
   "geometry": {
     "coordinates": [
       1.555,
       -2
     ],
     "type": "Point"
   },
   "properties": {
     "geom": {
       "coordinates": [
         1.555,
         -2
       ],
       "type": "Point"
     },
     "id": 1
   },
   "type": "Feature"
}
{
   "geometry": {
     "coordinates": [
       1,
       2
     ],
     "type": "Point"
   },
   "properties": {
     "geom": {
       "coordinates": [
         1,
         2
       ],
       "type": "Point"
     },
     "id": 2
   },
   "type": "Feature"
}
{
   "geometry": {
     "coordinates": [
       1,
       2
     ],
     "type": "Point"
   },
   "properties": {
     "geom": {
       "coordinates": [
         1,
         2
       ],
       "type": "Point"
     },
     "id": 3
   },
   "type": "Feature"
}
{
   "geometry": {
     "coordinates": [
       1,
       2
     ],
     "type": "Point"
   },
   "properties": {
     "geom": {
       "coordinates": [
         1,
         2
       ],
       "type": "Point"
     },
     "id": 4
   },
   "type": "Feature"
}
{
   "geometry": {
     "coordinates": [
       1,
       2
     ],
     "type": "Point"
   },
   "properties": {
     "geom": {
       "coordinates": [
         1,
         2
       ],
       "type": "Point"
     },
     "id": 5
   },
   "type": "Feature"
}
{
   "geometry": {
     "coordinates": [
       1,
       1
     ],
     "type": "Point"
   },
   "properties": {
     "geom": {
       "coordinates": [
         1,
         1
       ],
       "type": "Point"
     },
     "id": 6
   },
   "type": "Feature"
}
{
   "geometry": {
     "coordinates": [
       1,
       1
     ],
     "type": "Point"
   },
   "properties": {
     "geom": {
       "coordinates": [
         1,
         1
       ],
       "type": "Point"
     },
     "id": 7
   },
   "type": "Feature"
}
{
   "geometry": {
     "coordinates": [],
     "type": "Point"
   },
   "properties": {
     "geom": {
       "coordinates": [],
       "type": "Point"
     },
     "id": 8
   },
   "type": "Feature"
}
{
   "geometry": {
     "type": null
   },
   "properties": {
     "geom": null,
     "id": 9
   },
   "type": "Feature"
}

statement error "geom_no_exist" column not found
SELECT
  ST_AsGeoJSON(parse_test.*, 'geom_no_exist')
FROM parse_test ORDER BY id asc

# tests casts
query TTT
SELECT
  geom::bytea,
  geom::jsonb,
  geom::string
FROM parse_test ORDER BY id ASC
----
[1 1 0 0 0 225 122 20 174 71 225 248 63 0 0 0 0 0 0 0 192]   {"coordinates": [1.555, -2], "type": "Point"}  0101000000E17A14AE47E1F83F00000000000000C0
[1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  {"coordinates": [1, 2], "type": "Point"}       0101000020E6100000000000000000F03F0000000000000040
[1 1 0 0 32 164 15 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  {"coordinates": [1, 2], "type": "Point"}       0101000020A40F0000000000000000F03F0000000000000040
[1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]              {"coordinates": [1, 2], "type": "Point"}       0101000000000000000000F03F0000000000000040
[1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]              {"coordinates": [1, 2], "type": "Point"}       0101000000000000000000F03F0000000000000040
[1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]            {"coordinates": [1, 1], "type": "Point"}       0101000000000000000000F03F000000000000F03F
[1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]            {"coordinates": [1, 1], "type": "Point"}       0101000000000000000000F03F000000000000F03F
[1 1 0 0 0 0 0 0 0 0 0 248 127 0 0 0 0 0 0 248 127]          {"coordinates": [], "type": "Point"}           0101000000000000000000F87F000000000000F87F
NULL                                                         NULL                                           NULL

query TTT
SELECT
  geom::bytea::geometry,
  geom::jsonb::geometry,
  geom::string::geometry
FROM parse_test ORDER BY id ASC
----
0101000000E17A14AE47E1F83F00000000000000C0          0101000000E17A14AE47E1F83F00000000000000C0  0101000000E17A14AE47E1F83F00000000000000C0
0101000020E6100000000000000000F03F0000000000000040  0101000000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040
0101000020A40F0000000000000000F03F0000000000000040  0101000000000000000000F03F0000000000000040  0101000020A40F0000000000000000F03F0000000000000040
0101000000000000000000F03F0000000000000040          0101000000000000000000F03F0000000000000040  0101000000000000000000F03F0000000000000040
0101000000000000000000F03F0000000000000040          0101000000000000000000F03F0000000000000040  0101000000000000000000F03F0000000000000040
0101000000000000000000F03F000000000000F03F          0101000000000000000000F03F000000000000F03F  0101000000000000000000F03F000000000000F03F
0101000000000000000000F03F000000000000F03F          0101000000000000000000F03F000000000000F03F  0101000000000000000000F03F000000000000F03F
0101000000000000000000F87F000000000000F87F          0101000000000000000000F87F000000000000F87F  0101000000000000000000F87F000000000000F87F
NULL                                                NULL                                        NULL


# test out of bounds precisions
query TTTT
SELECT
  ST_AsText(geom, 123123123),
  ST_AsText(geom, -1),
  ST_AsGeoJSON(geom, 123123123),
  ST_AsGeoJSON(geom, -1)
FROM parse_test ORDER BY id ASC
----
POINT (1.5549999999999999378275106209912337362766265869140625 -2)  POINT (1.555 -2)  {"type":"Point","coordinates":[1.5549999999999999378275106209912337362766265869140625,-2]}    {"type":"Point","coordinates":[1.555,-2]}
POINT (1 2)                                                        POINT (1 2)       {"type":"Point","coordinates":[1,2]}                                                          {"type":"Point","coordinates":[1,2]}
POINT (1 2)                                                        POINT (1 2)       {"type":"Point","crs":{"type":"name","properties":{"name":"EPSG:4004"}},"coordinates":[1,2]}  {"type":"Point","crs":{"type":"name","properties":{"name":"EPSG:4004"}},"coordinates":[1,2]}
POINT (1 2)                                                        POINT (1 2)       {"type":"Point","coordinates":[1,2]}                                                          {"type":"Point","coordinates":[1,2]}
POINT (1 2)                                                        POINT (1 2)       {"type":"Point","coordinates":[1,2]}                                                          {"type":"Point","coordinates":[1,2]}
POINT (1 1)                                                        POINT (1 1)       {"type":"Point","coordinates":[1,1]}                                                          {"type":"Point","coordinates":[1,1]}
POINT (1 1)                                                        POINT (1 1)       {"type":"Point","coordinates":[1,1]}                                                          {"type":"Point","coordinates":[1,1]}
POINT EMPTY                                                        POINT EMPTY       {"type":"Point","coordinates":[]}                                                             {"type":"Point","coordinates":[]}
NULL                                                               NULL              NULL                                                                                          NULL

query TTT
SELECT
  ST_AsHexEWKB(geom),
  ST_AsHexEWKB(geom, 'ndr'),
  ST_AsHexEWKB(geom, 'xdr')
FROM parse_test ORDER BY id ASC
----
0101000000E17A14AE47E1F83F00000000000000C0          0101000000E17A14AE47E1F83F00000000000000C0          00000000013FF8E147AE147AE1C000000000000000
0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0020000001000010E63FF00000000000004000000000000000
0101000020A40F0000000000000000F03F0000000000000040  0101000020A40F0000000000000000F03F0000000000000040  002000000100000FA43FF00000000000004000000000000000
0101000000000000000000F03F0000000000000040          0101000000000000000000F03F0000000000000040          00000000013FF00000000000004000000000000000
0101000000000000000000F03F0000000000000040          0101000000000000000000F03F0000000000000040          00000000013FF00000000000004000000000000000
0101000000000000000000F03F000000000000F03F          0101000000000000000000F03F000000000000F03F          00000000013FF00000000000003FF0000000000000
0101000000000000000000F03F000000000000F03F          0101000000000000000000F03F000000000000F03F          00000000013FF00000000000003FF0000000000000
0101000000000000000000F87F000000000000F87F          0101000000000000000000F87F000000000000F87F          00000000017FF80000000000007FF8000000000000
NULL                                                NULL                                                NULL

query TTTTTTT
SELECT
  ST_AsText(geog),
  ST_AsEWKT(geog),
  ST_AsBinary(geog),
  ST_AsBinary(geog, 'ndr'),
  ST_AsBinary(geog, 'xdr'),
  ST_AsEWKB(geog),
  ST_AsKML(geog)
FROM parse_test ORDER BY id ASC
----
POINT (1.555 -2)                                    SRID=4326;POINT (1.555 -2)  [1 1 0 0 0 225 122 20 174 71 225 248 63 0 0 0 0 0 0 0 192]  [1 1 0 0 0 225 122 20 174 71 225 248 63 0 0 0 0 0 0 0 192]  [0 0 0 0 1 63 248 225 71 174 20 122 225 192 0 0 0 0 0 0 0]  [1 1 0 0 32 230 16 0 0 225 122 20 174 71 225 248 63 0 0 0 0 0 0 0 192]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1.555,-2</coordinates></Point>
POINT (1 2)                                         SRID=4326;POINT (1 2)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [0 0 0 0 1 63 240 0 0 0 0 0 0 64 0 0 0 0 0 0 0]  [1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,2</coordinates></Point>
POINT (1 2)                                         SRID=4326;POINT (1 2)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [0 0 0 0 1 63 240 0 0 0 0 0 0 64 0 0 0 0 0 0 0]  [1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,2</coordinates></Point>
POINT (1 2)                                         SRID=4326;POINT (1 2)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [0 0 0 0 1 63 240 0 0 0 0 0 0 64 0 0 0 0 0 0 0]  [1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,2</coordinates></Point>
POINT (1 2)                                         SRID=4326;POINT (1 2)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  [0 0 0 0 1 63 240 0 0 0 0 0 0 64 0 0 0 0 0 0 0]  [1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,2</coordinates></Point>
POINT (1 1)                                         SRID=4326;POINT (1 1)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  [0 0 0 0 1 63 240 0 0 0 0 0 0 63 240 0 0 0 0 0 0]  [1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,1</coordinates></Point>
POINT (1 1)                                         SRID=4326;POINT (1 1)  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  [1 1 0 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  [0 0 0 0 1 63 240 0 0 0 0 0 0 63 240 0 0 0 0 0 0]  [1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates>1,1</coordinates></Point>
POINT EMPTY                                         SRID=4326;POINT EMPTY  [1 1 0 0 0 0 0 0 0 0 0 248 127 0 0 0 0 0 0 248 127]  [1 1 0 0 0 0 0 0 0 0 0 248 127 0 0 0 0 0 0 248 127]  [0 0 0 0 1 127 248 0 0 0 0 0 0 127 248 0 0 0 0 0 0]  [1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 248 127 0 0 0 0 0 0 248 127]  <?xml version="1.0" encoding="UTF-8"?>
<Point><coordinates></coordinates></Point>
NULL                                                NULL  NULL  NULL  NULL  NULL  NULL

query TTT
SELECT
  ST_AsGeoJSON(geog),
  ST_AsGeoJSON(geog, 6, 8),
  ST_AsGeoJSON(geog, 6, 5)
FROM parse_test ORDER BY id ASC
----
{"type":"Point","coordinates":[1.555,-2]}  {"type":"Point","coordinates":[1.555,-2]}  {"type":"Point","bbox":[1.555,-2,1.555,-2],"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::4326"}},"coordinates":[1.555,-2]}
{"type":"Point","coordinates":[1,2]}       {"type":"Point","coordinates":[1,2]}       {"type":"Point","bbox":[1,2,1,2],"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::4326"}},"coordinates":[1,2]}
{"type":"Point","coordinates":[1,2]}       {"type":"Point","coordinates":[1,2]}       {"type":"Point","bbox":[1,2,1,2],"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::4326"}},"coordinates":[1,2]}
{"type":"Point","coordinates":[1,2]}       {"type":"Point","coordinates":[1,2]}       {"type":"Point","bbox":[1,2,1,2],"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::4326"}},"coordinates":[1,2]}
{"type":"Point","coordinates":[1,2]}       {"type":"Point","coordinates":[1,2]}       {"type":"Point","bbox":[1,2,1,2],"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::4326"}},"coordinates":[1,2]}
{"type":"Point","coordinates":[1,1]}       {"type":"Point","coordinates":[1,1]}       {"type":"Point","bbox":[1,1,1,1],"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::4326"}},"coordinates":[1,1]}
{"type":"Point","coordinates":[1,1]}       {"type":"Point","coordinates":[1,1]}       {"type":"Point","bbox":[1,1,1,1],"crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::4326"}},"coordinates":[1,1]}
{"type":"Point","coordinates":[]}          {"type":"Point","coordinates":[]}          {"type":"Point","crs":{"type":"name","properties":{"name":"urn:ogc:def:crs:EPSG::4326"}},"coordinates":[]}
NULL                                       NULL                                       NULL

query TTT
SELECT ST_AsEWKT(g), ST_GeoHash(g), ST_GeoHash(g, 8) FROM ( VALUES
  ('POINT (0 0)'::geography),
  ('LINESTRING(0 0, 1 0)'::geography)
) t(g)
----
SRID=4326;POINT (0 0)            s0000000000000000000  s0000000
SRID=4326;LINESTRING (0 0, 1 0)  ·                     s00252h0

# tests casts
query TTT
SELECT
  geog::bytea,
  geog::jsonb,
  geog::string
FROM parse_test ORDER BY id ASC
----
[1 1 0 0 32 230 16 0 0 225 122 20 174 71 225 248 63 0 0 0 0 0 0 0 192]  {"coordinates": [1.555, -2], "type": "Point"}  0101000020E6100000E17A14AE47E1F83F00000000000000C0
[1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]             {"coordinates": [1, 2], "type": "Point"}       0101000020E6100000000000000000F03F0000000000000040
[1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]             {"coordinates": [1, 2], "type": "Point"}       0101000020E6100000000000000000F03F0000000000000040
[1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]             {"coordinates": [1, 2], "type": "Point"}       0101000020E6100000000000000000F03F0000000000000040
[1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 0 64]             {"coordinates": [1, 2], "type": "Point"}       0101000020E6100000000000000000F03F0000000000000040
[1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]           {"coordinates": [1, 1], "type": "Point"}       0101000020E6100000000000000000F03F000000000000F03F
[1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 240 63 0 0 0 0 0 0 240 63]           {"coordinates": [1, 1], "type": "Point"}       0101000020E6100000000000000000F03F000000000000F03F
[1 1 0 0 32 230 16 0 0 0 0 0 0 0 0 248 127 0 0 0 0 0 0 248 127]         {"coordinates": [], "type": "Point"}           0101000020E6100000000000000000F87F000000000000F87F
NULL                                                                    NULL                                           NULL

query TTT
SELECT
  geog::bytea::geography,
  geog::jsonb::geography,
  geog::string::geography
FROM parse_test ORDER BY id ASC
----
0101000020E6100000E17A14AE47E1F83F00000000000000C0  0101000020E6100000E17A14AE47E1F83F00000000000000C0  0101000020E6100000E17A14AE47E1F83F00000000000000C0
0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040
0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040
0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040
0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040
0101000020E6100000000000000000F03F000000000000F03F  0101000020E6100000000000000000F03F000000000000F03F  0101000020E6100000000000000000F03F000000000000F03F
0101000020E6100000000000000000F03F000000000000F03F  0101000020E6100000000000000000F03F000000000000F03F  0101000020E6100000000000000000F03F000000000000F03F
0101000020E6100000000000000000F87F000000000000F87F  0101000020E6100000000000000000F87F000000000000F87F  0101000020E6100000000000000000F87F000000000000F87F
NULL                                                NULL                                                NULL

query TTTT
SELECT
  ST_AsHexWKB(geog),
  ST_AsHexEWKB(geog),
  ST_AsHexEWKB(geog, 'ndr'),
  ST_AsHexEWKB(geog, 'xdr')
FROM parse_test ORDER BY id ASC
----
0101000000E17A14AE47E1F83F00000000000000C0  0101000020E6100000E17A14AE47E1F83F00000000000000C0  0101000020E6100000E17A14AE47E1F83F00000000000000C0  0020000001000010E63FF8E147AE147AE1C000000000000000
0101000000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0020000001000010E63FF00000000000004000000000000000
0101000000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0020000001000010E63FF00000000000004000000000000000
0101000000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0020000001000010E63FF00000000000004000000000000000
0101000000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0101000020E6100000000000000000F03F0000000000000040  0020000001000010E63FF00000000000004000000000000000
0101000000000000000000F03F000000000000F03F  0101000020E6100000000000000000F03F000000000000F03F  0101000020E6100000000000000000F03F000000000000F03F  0020000001000010E63FF00000000000003FF0000000000000
0101000000000000000000F03F000000000000F03F  0101000020E6100000000000000000F03F000000000000F03F  0101000020E6100000000000000000F03F000000000000F03F  0020000001000010E63FF00000000000003FF0000000000000
0101000000000000000000F87F000000000000F87F  0101000020E6100000000000000000F87F000000000000F87F  0101000020E6100000000000000000F87F000000000000F87F  0020000001000010E67FF80000000000007FF8000000000000
NULL                                        NULL                                                NULL                                                NULL

query TTTTTTTT
SELECT
  ST_PointFromText('POINT(1.0 1.0)'),
  ST_PointFromText('POINT(1.0 1.0)', 4326),
  ST_PointFromText('LINESTRING(1.0 1.0, 2.0 2.0)'),
  ST_PointFromText('LINESTRING(1.0 1.0, 2.0 2.0)', 4326),
  ST_PointFromWKB(ST_AsBinary('POINT(1.0 1.0)'::geometry)),
  ST_PointFromWKB(ST_AsBinary('POINT(1.0 1.0)'::geometry), 4326),
  ST_PointFromWKB(ST_AsBinary('LINESTRING(1.0 1.0, 2.0 2.0)'::geometry)),
  ST_PointFromWKB(ST_AsBinary('LINESTRING(1.0 1.0, 2.0 2.0)'::geometry), 4326)
----
0101000000000000000000F03F000000000000F03F  0101000020E6100000000000000000F03F000000000000F03F  NULL  NULL  0101000000000000000000F03F000000000000F03F  0101000020E6100000000000000000F03F000000000000F03F  NULL  NULL

subtest geom_operators

statement ok
CREATE TABLE geom_operators_test (
  dsc TEXT PRIMARY KEY,
  geom GEOMETRY
)

statement ok
INSERT INTO geom_operators_test VALUES
  ('NULL', NULL),
  ('Square (left)', 'POLYGON((-1.0 0.0, 0.0 0.0, 0.0 1.0, -1.0 1.0, -1.0 0.0))'),
  ('Point middle of Left Square', 'POINT(-0.5 0.5)'),
  ('Square (right)', 'POLYGON((0.0 0.0, 1.0 0.0, 1.0 1.0, 0.0 1.0, 0.0 0.0))'),
  ('Point middle of Right Square', 'POINT(0.5 0.5)'),
  ('Square overlapping left and right square', 'POLYGON((-0.1 0.0, 1.0 0.0, 1.0 1.0, -0.1 1.0, -0.1 0.0))'),
  ('Line going through left and right square', 'LINESTRING(-0.5 0.5, 0.5 0.5)'),
  ('Faraway point', 'POINT(5.0 5.0)'),
  ('Empty LineString', 'LINESTRING EMPTY'),
  ('Empty Point', 'POINT EMPTY'),
  ('Empty GeometryCollection', 'GEOMETRYCOLLECTION EMPTY'),
  ('Nested Geometry Collection', 'GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0 0)))'::geometry)
  -- ('Partially Empty GeometryCollection', 'GEOMETRYCOLLECTION ( LINESTRING EMPTY, POINT (0.0 0.0) )') -- some of these cases crash GEOS.

# GROUP BY
query TR
SELECT
  a.dsc,
  ST_Area(a.geom)
FROM geom_operators_test a
GROUP BY a.dsc, a.geom
ORDER BY a.dsc
----
Empty GeometryCollection                  0
Empty LineString                          0
Empty Point                               0
Faraway point                             0
Line going through left and right square  0
NULL                                      NULL
Nested Geometry Collection                0
Point middle of Left Square               0
Point middle of Right Square              0
Square (left)                             1
Square (right)                            1
Square overlapping left and right square  1.1

# Validity checking.
query TBBBTTTT
SELECT
  dsc,
  ST_IsValid(geom),
  ST_IsValid(geom, 0),
  ST_IsValid(geom, 1),
  ST_IsValidReason(geom),
  ST_IsValidReason(geom, 0),
  ST_IsValidReason(geom, 1),
  ST_AsEWKT(ST_MakeValid(geom))
FROM ( VALUES
  ('valid geom', 'POINT(1.0 2.0)'::geometry),
  ('invalid polygon', 'POLYGON((1.0 1.0, 2.0 2.0, 1.5 1.5, 1.5 -1.5, 1.0 1.0))'::geometry),
  ('self-intersecting polygon', 'POLYGON ((14 20, 8 45, 20 35, 14 20, 16 30, 12 30, 14 20))'::geometry)
) t(dsc, geom)
----
valid geom                 true   true   true   Valid Geometry                 Valid Geometry          Valid Geometry     POINT (1 2)
invalid polygon            false  false  false  Self-intersection[1.5 1.5]     Self-intersection       Self-intersection  GEOMETRYCOLLECTION (POLYGON ((1 1, 1.5 1.5, 1.5 -1.5, 1 1)), LINESTRING (1.5 1.5, 2 2))
self-intersecting polygon  false  false  true   Ring Self-intersection[14 20]  Ring Self-intersection  Valid Geometry     POLYGON ((14 20, 8 45, 20 35, 14 20), (14 20, 16 30, 12 30, 14 20))

# Unary operators
query TRRRRRR
SELECT
  a.dsc,
  ST_Area(a.geom),
  ST_Area2D(a.geom),
  ST_Length(a.geom),
  ST_Length2D(a.geom),
  ST_Perimeter(a.geom),
  ST_Perimeter2D(a.geom)
FROM geom_operators_test a
ORDER BY a.dsc
----
Empty GeometryCollection                  0     0     0     0     0     0
Empty LineString                          0     0     0     0     0     0
Empty Point                               0     0     0     0     0     0
Faraway point                             0     0     0     0     0     0
Line going through left and right square  0     0     1     1     0     0
NULL                                      NULL  NULL  NULL  NULL  NULL  NULL
Nested Geometry Collection                0     0     0     0     0     0
Point middle of Left Square               0     0     0     0     0     0
Point middle of Right Square              0     0     0     0     0     0
Square (left)                             1     1     0     0     4     4
Square (right)                            1     1     0     0     4     4
Square overlapping left and right square  1.1   1.1   0     0     4.2   4.2

# Topology operators.

query TTT
SELECT
  a.dsc,
  b.dsc,
  ST_AsEWKT(ST_Union(a.geom, b.geom))
FROM geom_operators_test a
JOIN geom_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY
Empty GeometryCollection                  Empty LineString                          LINESTRING EMPTY
Empty GeometryCollection                  Empty Point                               POINT EMPTY
Empty GeometryCollection                  Faraway point                             POINT (5 5)
Empty GeometryCollection                  Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)
Empty GeometryCollection                  NULL                                      NULL
Empty GeometryCollection                  Nested Geometry Collection                GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))
Empty GeometryCollection                  Point middle of Left Square               POINT (-0.5 0.5)
Empty GeometryCollection                  Point middle of Right Square              POINT (0.5 0.5)
Empty GeometryCollection                  Square (left)                             POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0))
Empty GeometryCollection                  Square (right)                            POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))
Empty GeometryCollection                  Square overlapping left and right square  POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0))
Empty LineString                          Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY
Empty LineString                          Empty LineString                          LINESTRING EMPTY
Empty LineString                          Empty Point                               POINT EMPTY
Empty LineString                          Faraway point                             POINT (5 5)
Empty LineString                          Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)
Empty LineString                          NULL                                      NULL
Empty LineString                          Nested Geometry Collection                GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))
Empty LineString                          Point middle of Left Square               POINT (-0.5 0.5)
Empty LineString                          Point middle of Right Square              POINT (0.5 0.5)
Empty LineString                          Square (left)                             POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0))
Empty LineString                          Square (right)                            POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))
Empty LineString                          Square overlapping left and right square  POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0))
Empty Point                               Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY
Empty Point                               Empty LineString                          LINESTRING EMPTY
Empty Point                               Empty Point                               POINT EMPTY
Empty Point                               Faraway point                             POINT (5 5)
Empty Point                               Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)
Empty Point                               NULL                                      NULL
Empty Point                               Nested Geometry Collection                GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))
Empty Point                               Point middle of Left Square               POINT (-0.5 0.5)
Empty Point                               Point middle of Right Square              POINT (0.5 0.5)
Empty Point                               Square (left)                             POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0))
Empty Point                               Square (right)                            POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))
Empty Point                               Square overlapping left and right square  POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0))
Faraway point                             Empty GeometryCollection                  POINT (5 5)
Faraway point                             Empty LineString                          POINT (5 5)
Faraway point                             Empty Point                               POINT (5 5)
Faraway point                             Faraway point                             POINT (5 5)
Faraway point                             Line going through left and right square  GEOMETRYCOLLECTION (POINT (5 5), LINESTRING (-0.5 0.5, 0.5 0.5))
Faraway point                             NULL                                      NULL
Faraway point                             Nested Geometry Collection                GEOMETRYCOLLECTION (POINT (5 5), GEOMETRYCOLLECTION (POINT (0 0)))
Faraway point                             Point middle of Left Square               MULTIPOINT (5 5, -0.5 0.5)
Faraway point                             Point middle of Right Square              MULTIPOINT (5 5, 0.5 0.5)
Faraway point                             Square (left)                             GEOMETRYCOLLECTION (POINT (5 5), POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0)))
Faraway point                             Square (right)                            GEOMETRYCOLLECTION (POINT (5 5), POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0)))
Faraway point                             Square overlapping left and right square  GEOMETRYCOLLECTION (POINT (5 5), POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0)))
Line going through left and right square  Empty GeometryCollection                  LINESTRING (-0.5 0.5, 0.5 0.5)
Line going through left and right square  Empty LineString                          LINESTRING (-0.5 0.5, 0.5 0.5)
Line going through left and right square  Empty Point                               LINESTRING (-0.5 0.5, 0.5 0.5)
Line going through left and right square  Faraway point                             GEOMETRYCOLLECTION (LINESTRING (-0.5 0.5, 0.5 0.5), POINT (5 5))
Line going through left and right square  Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)
Line going through left and right square  NULL                                      NULL
Line going through left and right square  Nested Geometry Collection                GEOMETRYCOLLECTION (LINESTRING (-0.5 0.5, 0.5 0.5), GEOMETRYCOLLECTION (POINT (0 0)))
Line going through left and right square  Point middle of Left Square               LINESTRING (-0.5 0.5, 0.5 0.5)
Line going through left and right square  Point middle of Right Square              LINESTRING (-0.5 0.5, 0.5 0.5)
Line going through left and right square  Square (left)                             GEOMETRYCOLLECTION (LINESTRING (0 0.5, 0.5 0.5), POLYGON ((0 0.5, 0 0, -1 0, -1 1, 0 1, 0 0.5)))
Line going through left and right square  Square (right)                            GEOMETRYCOLLECTION (LINESTRING (-0.5 0.5, 0 0.5), POLYGON ((0 0.5, 0 1, 1 1, 1 0, 0 0, 0 0.5)))
Line going through left and right square  Square overlapping left and right square  GEOMETRYCOLLECTION (LINESTRING (-0.5 0.5, -0.1 0.5), POLYGON ((-0.1 0.5, -0.1 1, 1 1, 1 0, -0.1 0, -0.1 0.5)))
NULL                                      Empty GeometryCollection                  NULL
NULL                                      Empty LineString                          NULL
NULL                                      Empty Point                               NULL
NULL                                      Faraway point                             NULL
NULL                                      Line going through left and right square  NULL
NULL                                      NULL                                      NULL
NULL                                      Nested Geometry Collection                NULL
NULL                                      Point middle of Left Square               NULL
NULL                                      Point middle of Right Square              NULL
NULL                                      Square (left)                             NULL
NULL                                      Square (right)                            NULL
NULL                                      Square overlapping left and right square  NULL
Nested Geometry Collection                Empty GeometryCollection                  GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))
Nested Geometry Collection                Empty LineString                          GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))
Nested Geometry Collection                Empty Point                               GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))
Nested Geometry Collection                Faraway point                             GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)), POINT (5 5))
Nested Geometry Collection                Line going through left and right square  GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)), LINESTRING (-0.5 0.5, 0.5 0.5))
Nested Geometry Collection                NULL                                      NULL
Nested Geometry Collection                Nested Geometry Collection                POINT (0 0)
Nested Geometry Collection                Point middle of Left Square               GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)), POINT (-0.5 0.5))
Nested Geometry Collection                Point middle of Right Square              GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)), POINT (0.5 0.5))
Nested Geometry Collection                Square (left)                             POLYGON ((-1 0, -1 1, 0 1, 0 0, -1 0))
Nested Geometry Collection                Square (right)                            POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0))
Nested Geometry Collection                Square overlapping left and right square  POLYGON ((-0.1 0, -0.1 1, 1 1, 1 0, -0.1 0))
Point middle of Left Square               Empty GeometryCollection                  POINT (-0.5 0.5)
Point middle of Left Square               Empty LineString                          POINT (-0.5 0.5)
Point middle of Left Square               Empty Point                               POINT (-0.5 0.5)
Point middle of Left Square               Faraway point                             MULTIPOINT (-0.5 0.5, 5 5)
Point middle of Left Square               Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)
Point middle of Left Square               NULL                                      NULL
Point middle of Left Square               Nested Geometry Collection                GEOMETRYCOLLECTION (POINT (-0.5 0.5), GEOMETRYCOLLECTION (POINT (0 0)))
Point middle of Left Square               Point middle of Left Square               POINT (-0.5 0.5)
Point middle of Left Square               Point middle of Right Square              MULTIPOINT (-0.5 0.5, 0.5 0.5)
Point middle of Left Square               Square (left)                             POLYGON ((-1 0, -1 1, 0 1, 0 0, -1 0))
Point middle of Left Square               Square (right)                            GEOMETRYCOLLECTION (POINT (-0.5 0.5), POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0)))
Point middle of Left Square               Square overlapping left and right square  GEOMETRYCOLLECTION (POINT (-0.5 0.5), POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0)))
Point middle of Right Square              Empty GeometryCollection                  POINT (0.5 0.5)
Point middle of Right Square              Empty LineString                          POINT (0.5 0.5)
Point middle of Right Square              Empty Point                               POINT (0.5 0.5)
Point middle of Right Square              Faraway point                             MULTIPOINT (0.5 0.5, 5 5)
Point middle of Right Square              Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)
Point middle of Right Square              NULL                                      NULL
Point middle of Right Square              Nested Geometry Collection                GEOMETRYCOLLECTION (POINT (0.5 0.5), GEOMETRYCOLLECTION (POINT (0 0)))
Point middle of Right Square              Point middle of Left Square               MULTIPOINT (0.5 0.5, -0.5 0.5)
Point middle of Right Square              Point middle of Right Square              POINT (0.5 0.5)
Point middle of Right Square              Square (left)                             GEOMETRYCOLLECTION (POINT (0.5 0.5), POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0)))
Point middle of Right Square              Square (right)                            POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0))
Point middle of Right Square              Square overlapping left and right square  POLYGON ((-0.1 0, -0.1 1, 1 1, 1 0, -0.1 0))
Square (left)                             Empty GeometryCollection                  POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0))
Square (left)                             Empty LineString                          POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0))
Square (left)                             Empty Point                               POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0))
Square (left)                             Faraway point                             GEOMETRYCOLLECTION (POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0)), POINT (5 5))
Square (left)                             Line going through left and right square  GEOMETRYCOLLECTION (LINESTRING (0 0.5, 0.5 0.5), POLYGON ((0 0.5, 0 0, -1 0, -1 1, 0 1, 0 0.5)))
Square (left)                             NULL                                      NULL
Square (left)                             Nested Geometry Collection                POLYGON ((-1 0, -1 1, 0 1, 0 0, -1 0))
Square (left)                             Point middle of Left Square               POLYGON ((-1 0, -1 1, 0 1, 0 0, -1 0))
Square (left)                             Point middle of Right Square              GEOMETRYCOLLECTION (POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0)), POINT (0.5 0.5))
Square (left)                             Square (left)                             POLYGON ((0 0, -1 0, -1 1, 0 1, 0 0))
Square (left)                             Square (right)                            POLYGON ((0 0, -1 0, -1 1, 0 1, 1 1, 1 0, 0 0))
Square (left)                             Square overlapping left and right square  POLYGON ((-0.1 0, -1 0, -1 1, -0.1 1, 0 1, 1 1, 1 0, 0 0, -0.1 0))
Square (right)                            Empty GeometryCollection                  POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))
Square (right)                            Empty LineString                          POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))
Square (right)                            Empty Point                               POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))
Square (right)                            Faraway point                             GEOMETRYCOLLECTION (POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0)), POINT (5 5))
Square (right)                            Line going through left and right square  GEOMETRYCOLLECTION (LINESTRING (-0.5 0.5, 0 0.5), POLYGON ((0 0.5, 0 1, 1 1, 1 0, 0 0, 0 0.5)))
Square (right)                            NULL                                      NULL
Square (right)                            Nested Geometry Collection                POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0))
Square (right)                            Point middle of Left Square               GEOMETRYCOLLECTION (POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0)), POINT (-0.5 0.5))
Square (right)                            Point middle of Right Square              POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0))
Square (right)                            Square (left)                             POLYGON ((0 1, 1 1, 1 0, 0 0, -1 0, -1 1, 0 1))
Square (right)                            Square (right)                            POLYGON ((1 0, 0 0, 0 1, 1 1, 1 0))
Square (right)                            Square overlapping left and right square  POLYGON ((1 0, 0 0, -0.1 0, -0.1 1, 0 1, 1 1, 1 0))
Square overlapping left and right square  Empty GeometryCollection                  POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0))
Square overlapping left and right square  Empty LineString                          POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0))
Square overlapping left and right square  Empty Point                               POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0))
Square overlapping left and right square  Faraway point                             GEOMETRYCOLLECTION (POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0)), POINT (5 5))
Square overlapping left and right square  Line going through left and right square  GEOMETRYCOLLECTION (LINESTRING (-0.5 0.5, -0.1 0.5), POLYGON ((-0.1 0.5, -0.1 1, 1 1, 1 0, -0.1 0, -0.1 0.5)))
Square overlapping left and right square  NULL                                      NULL
Square overlapping left and right square  Nested Geometry Collection                POLYGON ((-0.1 0, -0.1 1, 1 1, 1 0, -0.1 0))
Square overlapping left and right square  Point middle of Left Square               GEOMETRYCOLLECTION (POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0)), POINT (-0.5 0.5))
Square overlapping left and right square  Point middle of Right Square              POLYGON ((-0.1 0, -0.1 1, 1 1, 1 0, -0.1 0))
Square overlapping left and right square  Square (left)                             POLYGON ((0 0, -0.1 0, -1 0, -1 1, -0.1 1, 0 1, 1 1, 1 0, 0 0))
Square overlapping left and right square  Square (right)                            POLYGON ((0 0, -0.1 0, -0.1 1, 0 1, 1 1, 1 0, 0 0))
Square overlapping left and right square  Square overlapping left and right square  POLYGON ((1 0, -0.1 0, -0.1 1, 1 1, 1 0))

query TTTB
SELECT
  a.dsc,
  b.dsc,
  ST_AsEWKT(ST_Intersection(a.geom, b.geom)),
  ST_Intersection(a.geom, b.geom) = ST_Intersection(a.geom::string, b.geom::string)
FROM geom_operators_test a
JOIN geom_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                   true
Empty GeometryCollection                  Empty LineString                          GEOMETRYCOLLECTION EMPTY                   true
Empty GeometryCollection                  Empty Point                               GEOMETRYCOLLECTION EMPTY                   true
Empty GeometryCollection                  Faraway point                             GEOMETRYCOLLECTION EMPTY                   true
Empty GeometryCollection                  Line going through left and right square  GEOMETRYCOLLECTION EMPTY                   true
Empty GeometryCollection                  NULL                                      NULL                                       NULL
Empty GeometryCollection                  Nested Geometry Collection                GEOMETRYCOLLECTION EMPTY                   true
Empty GeometryCollection                  Point middle of Left Square               GEOMETRYCOLLECTION EMPTY                   true
Empty GeometryCollection                  Point middle of Right Square              GEOMETRYCOLLECTION EMPTY                   true
Empty GeometryCollection                  Square (left)                             GEOMETRYCOLLECTION EMPTY                   true
Empty GeometryCollection                  Square (right)                            GEOMETRYCOLLECTION EMPTY                   true
Empty GeometryCollection                  Square overlapping left and right square  GEOMETRYCOLLECTION EMPTY                   true
Empty LineString                          Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                   true
Empty LineString                          Empty LineString                          GEOMETRYCOLLECTION EMPTY                   true
Empty LineString                          Empty Point                               GEOMETRYCOLLECTION EMPTY                   true
Empty LineString                          Faraway point                             GEOMETRYCOLLECTION EMPTY                   true
Empty LineString                          Line going through left and right square  GEOMETRYCOLLECTION EMPTY                   true
Empty LineString                          NULL                                      NULL                                       NULL
Empty LineString                          Nested Geometry Collection                GEOMETRYCOLLECTION EMPTY                   true
Empty LineString                          Point middle of Left Square               GEOMETRYCOLLECTION EMPTY                   true
Empty LineString                          Point middle of Right Square              GEOMETRYCOLLECTION EMPTY                   true
Empty LineString                          Square (left)                             GEOMETRYCOLLECTION EMPTY                   true
Empty LineString                          Square (right)                            GEOMETRYCOLLECTION EMPTY                   true
Empty LineString                          Square overlapping left and right square  GEOMETRYCOLLECTION EMPTY                   true
Empty Point                               Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                   true
Empty Point                               Empty LineString                          GEOMETRYCOLLECTION EMPTY                   true
Empty Point                               Empty Point                               GEOMETRYCOLLECTION EMPTY                   true
Empty Point                               Faraway point                             GEOMETRYCOLLECTION EMPTY                   true
Empty Point                               Line going through left and right square  GEOMETRYCOLLECTION EMPTY                   true
Empty Point                               NULL                                      NULL                                       NULL
Empty Point                               Nested Geometry Collection                GEOMETRYCOLLECTION EMPTY                   true
Empty Point                               Point middle of Left Square               GEOMETRYCOLLECTION EMPTY                   true
Empty Point                               Point middle of Right Square              GEOMETRYCOLLECTION EMPTY                   true
Empty Point                               Square (left)                             GEOMETRYCOLLECTION EMPTY                   true
Empty Point                               Square (right)                            GEOMETRYCOLLECTION EMPTY                   true
Empty Point                               Square overlapping left and right square  GEOMETRYCOLLECTION EMPTY                   true
Faraway point                             Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                   true
Faraway point                             Empty LineString                          GEOMETRYCOLLECTION EMPTY                   true
Faraway point                             Empty Point                               GEOMETRYCOLLECTION EMPTY                   true
Faraway point                             Faraway point                             POINT (5 5)                                true
Faraway point                             Line going through left and right square  POINT EMPTY                                true
Faraway point                             NULL                                      NULL                                       NULL
Faraway point                             Nested Geometry Collection                POINT EMPTY                                true
Faraway point                             Point middle of Left Square               POINT EMPTY                                true
Faraway point                             Point middle of Right Square              POINT EMPTY                                true
Faraway point                             Square (left)                             POINT EMPTY                                true
Faraway point                             Square (right)                            POINT EMPTY                                true
Faraway point                             Square overlapping left and right square  POINT EMPTY                                true
Line going through left and right square  Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                   true
Line going through left and right square  Empty LineString                          GEOMETRYCOLLECTION EMPTY                   true
Line going through left and right square  Empty Point                               GEOMETRYCOLLECTION EMPTY                   true
Line going through left and right square  Faraway point                             POINT EMPTY                                true
Line going through left and right square  Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)             true
Line going through left and right square  NULL                                      NULL                                       NULL
Line going through left and right square  Nested Geometry Collection                POINT EMPTY                                true
Line going through left and right square  Point middle of Left Square               POINT (-0.5 0.5)                           true
Line going through left and right square  Point middle of Right Square              POINT (0.5 0.5)                            true
Line going through left and right square  Square (left)                             LINESTRING (-0.5 0.5, 0 0.5)               true
Line going through left and right square  Square (right)                            LINESTRING (0 0.5, 0.5 0.5)                true
Line going through left and right square  Square overlapping left and right square  LINESTRING (-0.1 0.5, 0.5 0.5)             true
NULL                                      Empty GeometryCollection                  NULL                                       NULL
NULL                                      Empty LineString                          NULL                                       NULL
NULL                                      Empty Point                               NULL                                       NULL
NULL                                      Faraway point                             NULL                                       NULL
NULL                                      Line going through left and right square  NULL                                       NULL
NULL                                      NULL                                      NULL                                       NULL
NULL                                      Nested Geometry Collection                NULL                                       NULL
NULL                                      Point middle of Left Square               NULL                                       NULL
NULL                                      Point middle of Right Square              NULL                                       NULL
NULL                                      Square (left)                             NULL                                       NULL
NULL                                      Square (right)                            NULL                                       NULL
NULL                                      Square overlapping left and right square  NULL                                       NULL
Nested Geometry Collection                Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                   true
Nested Geometry Collection                Empty LineString                          GEOMETRYCOLLECTION EMPTY                   true
Nested Geometry Collection                Empty Point                               GEOMETRYCOLLECTION EMPTY                   true
Nested Geometry Collection                Faraway point                             POINT EMPTY                                true
Nested Geometry Collection                Line going through left and right square  POINT EMPTY                                true
Nested Geometry Collection                NULL                                      NULL                                       NULL
Nested Geometry Collection                Nested Geometry Collection                POINT (0 0)                                true
Nested Geometry Collection                Point middle of Left Square               POINT EMPTY                                true
Nested Geometry Collection                Point middle of Right Square              POINT EMPTY                                true
Nested Geometry Collection                Square (left)                             POINT (0 0)                                true
Nested Geometry Collection                Square (right)                            POINT (0 0)                                true
Nested Geometry Collection                Square overlapping left and right square  POINT (0 0)                                true
Point middle of Left Square               Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                   true
Point middle of Left Square               Empty LineString                          GEOMETRYCOLLECTION EMPTY                   true
Point middle of Left Square               Empty Point                               GEOMETRYCOLLECTION EMPTY                   true
Point middle of Left Square               Faraway point                             POINT EMPTY                                true
Point middle of Left Square               Line going through left and right square  POINT (-0.5 0.5)                           true
Point middle of Left Square               NULL                                      NULL                                       NULL
Point middle of Left Square               Nested Geometry Collection                POINT EMPTY                                true
Point middle of Left Square               Point middle of Left Square               POINT (-0.5 0.5)                           true
Point middle of Left Square               Point middle of Right Square              POINT EMPTY                                true
Point middle of Left Square               Square (left)                             POINT (-0.5 0.5)                           true
Point middle of Left Square               Square (right)                            POINT EMPTY                                true
Point middle of Left Square               Square overlapping left and right square  POINT EMPTY                                true
Point middle of Right Square              Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                   true
Point middle of Right Square              Empty LineString                          GEOMETRYCOLLECTION EMPTY                   true
Point middle of Right Square              Empty Point                               GEOMETRYCOLLECTION EMPTY                   true
Point middle of Right Square              Faraway point                             POINT EMPTY                                true
Point middle of Right Square              Line going through left and right square  POINT (0.5 0.5)                            true
Point middle of Right Square              NULL                                      NULL                                       NULL
Point middle of Right Square              Nested Geometry Collection                POINT EMPTY                                true
Point middle of Right Square              Point middle of Left Square               POINT EMPTY                                true
Point middle of Right Square              Point middle of Right Square              POINT (0.5 0.5)                            true
Point middle of Right Square              Square (left)                             POINT EMPTY                                true
Point middle of Right Square              Square (right)                            POINT (0.5 0.5)                            true
Point middle of Right Square              Square overlapping left and right square  POINT (0.5 0.5)                            true
Square (left)                             Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                   true
Square (left)                             Empty LineString                          GEOMETRYCOLLECTION EMPTY                   true
Square (left)                             Empty Point                               GEOMETRYCOLLECTION EMPTY                   true
Square (left)                             Faraway point                             POINT EMPTY                                true
Square (left)                             Line going through left and right square  LINESTRING (-0.5 0.5, 0 0.5)               true
Square (left)                             NULL                                      NULL                                       NULL
Square (left)                             Nested Geometry Collection                POINT (0 0)                                true
Square (left)                             Point middle of Left Square               POINT (-0.5 0.5)                           true
Square (left)                             Point middle of Right Square              POINT EMPTY                                true
Square (left)                             Square (left)                             POLYGON ((0 0, -1 0, -1 1, 0 1, 0 0))      true
Square (left)                             Square (right)                            LINESTRING (0 0, 0 1)                      true
Square (left)                             Square overlapping left and right square  POLYGON ((0 0, -0.1 0, -0.1 1, 0 1, 0 0))  true
Square (right)                            Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                   true
Square (right)                            Empty LineString                          GEOMETRYCOLLECTION EMPTY                   true
Square (right)                            Empty Point                               GEOMETRYCOLLECTION EMPTY                   true
Square (right)                            Faraway point                             POINT EMPTY                                true
Square (right)                            Line going through left and right square  LINESTRING (0 0.5, 0.5 0.5)                true
Square (right)                            NULL                                      NULL                                       NULL
Square (right)                            Nested Geometry Collection                POINT (0 0)                                true
Square (right)                            Point middle of Left Square               POINT EMPTY                                true
Square (right)                            Point middle of Right Square              POINT (0.5 0.5)                            true
Square (right)                            Square (left)                             LINESTRING (0 1, 0 0)                      true
Square (right)                            Square (right)                            POLYGON ((1 0, 0 0, 0 1, 1 1, 1 0))        true
Square (right)                            Square overlapping left and right square  POLYGON ((1 0, 0 0, 0 1, 1 1, 1 0))        true
Square overlapping left and right square  Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                   true
Square overlapping left and right square  Empty LineString                          GEOMETRYCOLLECTION EMPTY                   true
Square overlapping left and right square  Empty Point                               GEOMETRYCOLLECTION EMPTY                   true
Square overlapping left and right square  Faraway point                             POINT EMPTY                                true
Square overlapping left and right square  Line going through left and right square  LINESTRING (-0.1 0.5, 0.5 0.5)             true
Square overlapping left and right square  NULL                                      NULL                                       NULL
Square overlapping left and right square  Nested Geometry Collection                POINT (0 0)                                true
Square overlapping left and right square  Point middle of Left Square               POINT EMPTY                                true
Square overlapping left and right square  Point middle of Right Square              POINT (0.5 0.5)                            true
Square overlapping left and right square  Square (left)                             POLYGON ((0 0, -0.1 0, -0.1 1, 0 1, 0 0))  true
Square overlapping left and right square  Square (right)                            POLYGON ((1 0, 0 0, 0 1, 1 1, 1 0))        true
Square overlapping left and right square  Square overlapping left and right square  POLYGON ((1 0, -0.1 0, -0.1 1, 1 1, 1 0))  true

query TTTT
SELECT
  a.dsc,
  ST_AsEWKT(ST_Centroid(a.geom)),
  ST_AsEWKT(ST_PointOnSurface(a.geom)),
  ST_AsEWKT(ST_ConvexHull(a.geom))
FROM geom_operators_test a
ORDER BY a.dsc
----
Empty GeometryCollection                  POINT EMPTY       POINT EMPTY       GEOMETRYCOLLECTION EMPTY
Empty LineString                          POINT EMPTY       POINT EMPTY       GEOMETRYCOLLECTION EMPTY
Empty Point                               POINT EMPTY       POINT EMPTY       GEOMETRYCOLLECTION EMPTY
Faraway point                             POINT (5 5)       POINT (5 5)       POINT (5 5)
Line going through left and right square  POINT (0 0.5)     POINT (-0.5 0.5)  LINESTRING (-0.5 0.5, 0.5 0.5)
NULL                                      NULL              NULL              NULL
Nested Geometry Collection                POINT (0 0)       POINT (0 0)       POINT (0 0)
Point middle of Left Square               POINT (-0.5 0.5)  POINT (-0.5 0.5)  POINT (-0.5 0.5)
Point middle of Right Square              POINT (0.5 0.5)   POINT (0.5 0.5)   POINT (0.5 0.5)
Square (left)                             POINT (-0.5 0.5)  POINT (-0.5 0.5)  POLYGON ((-1 0, -1 1, 0 1, 0 0, -1 0))
Square (right)                            POINT (0.5 0.5)   POINT (0.5 0.5)   POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0))
Square overlapping left and right square  POINT (0.45 0.5)  POINT (0.45 0.5)  POLYGON ((-0.1 0, -0.1 1, 1 1, 1 0, -0.1 0))

# Functions which take in strings as input as well.
query TT
SELECT
  dsc,
  ST_AsEWKT(ST_Centroid(ewkt))
FROM [SELECT dsc, ST_AsEWKT(a.geom) ewkt FROM geom_operators_test a]
ORDER BY dsc ASC
----
Empty GeometryCollection                  POINT EMPTY
Empty LineString                          POINT EMPTY
Empty Point                               POINT EMPTY
Faraway point                             POINT (5 5)
Line going through left and right square  POINT (0 0.5)
NULL                                      NULL
Nested Geometry Collection                POINT (0 0)
Point middle of Left Square               POINT (-0.5 0.5)
Point middle of Right Square              POINT (0.5 0.5)
Square (left)                             POINT (-0.5 0.5)
Square (right)                            POINT (0.5 0.5)
Square overlapping left and right square  POINT (0.45 0.5)

# Binary operators
query TTRR
SELECT
  a.dsc,
  b.dsc,
  ST_Distance(a.geom, b.geom),
  ST_MaxDistance(a.geom, b.geom)
FROM geom_operators_test a
JOIN geom_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  NULL               NULL
Empty GeometryCollection                  Empty LineString                          NULL               NULL
Empty GeometryCollection                  Empty Point                               NULL               NULL
Empty GeometryCollection                  Faraway point                             NULL               NULL
Empty GeometryCollection                  Line going through left and right square  NULL               NULL
Empty GeometryCollection                  NULL                                      NULL               NULL
Empty GeometryCollection                  Nested Geometry Collection                NULL               NULL
Empty GeometryCollection                  Point middle of Left Square               NULL               NULL
Empty GeometryCollection                  Point middle of Right Square              NULL               NULL
Empty GeometryCollection                  Square (left)                             NULL               NULL
Empty GeometryCollection                  Square (right)                            NULL               NULL
Empty GeometryCollection                  Square overlapping left and right square  NULL               NULL
Empty LineString                          Empty GeometryCollection                  NULL               NULL
Empty LineString                          Empty LineString                          NULL               NULL
Empty LineString                          Empty Point                               NULL               NULL
Empty LineString                          Faraway point                             NULL               NULL
Empty LineString                          Line going through left and right square  NULL               NULL
Empty LineString                          NULL                                      NULL               NULL
Empty LineString                          Nested Geometry Collection                NULL               NULL
Empty LineString                          Point middle of Left Square               NULL               NULL
Empty LineString                          Point middle of Right Square              NULL               NULL
Empty LineString                          Square (left)                             NULL               NULL
Empty LineString                          Square (right)                            NULL               NULL
Empty LineString                          Square overlapping left and right square  NULL               NULL
Empty Point                               Empty GeometryCollection                  NULL               NULL
Empty Point                               Empty LineString                          NULL               NULL
Empty Point                               Empty Point                               NULL               NULL
Empty Point                               Faraway point                             NULL               NULL
Empty Point                               Line going through left and right square  NULL               NULL
Empty Point                               NULL                                      NULL               NULL
Empty Point                               Nested Geometry Collection                NULL               NULL
Empty Point                               Point middle of Left Square               NULL               NULL
Empty Point                               Point middle of Right Square              NULL               NULL
Empty Point                               Square (left)                             NULL               NULL
Empty Point                               Square (right)                            NULL               NULL
Empty Point                               Square overlapping left and right square  NULL               NULL
Faraway point                             Empty GeometryCollection                  NULL               NULL
Faraway point                             Empty LineString                          NULL               NULL
Faraway point                             Empty Point                               NULL               NULL
Faraway point                             Faraway point                             0                  0
Faraway point                             Line going through left and right square  6.36396103067893   7.10633520177595
Faraway point                             NULL                                      NULL               NULL
Faraway point                             Nested Geometry Collection                7.07106781186548   7.07106781186548
Faraway point                             Point middle of Left Square               7.10633520177595   7.10633520177595
Faraway point                             Point middle of Right Square              6.36396103067893   6.36396103067893
Faraway point                             Square (left)                             6.40312423743285   7.81024967590665
Faraway point                             Square (right)                            5.65685424949238   7.07106781186548
Faraway point                             Square overlapping left and right square  5.65685424949238   7.14212853426764
Line going through left and right square  Empty GeometryCollection                  NULL               NULL
Line going through left and right square  Empty LineString                          NULL               NULL
Line going through left and right square  Empty Point                               NULL               NULL
Line going through left and right square  Faraway point                             6.36396103067893   7.10633520177595
Line going through left and right square  Line going through left and right square  0                  1
Line going through left and right square  NULL                                      NULL               NULL
Line going through left and right square  Nested Geometry Collection                0.5                0.707106781186548
Line going through left and right square  Point middle of Left Square               0                  1
Line going through left and right square  Point middle of Right Square              0                  1
Line going through left and right square  Square (left)                             0                  1.58113883008419
Line going through left and right square  Square (right)                            0                  1.58113883008419
Line going through left and right square  Square overlapping left and right square  0                  1.58113883008419
NULL                                      Empty GeometryCollection                  NULL               NULL
NULL                                      Empty LineString                          NULL               NULL
NULL                                      Empty Point                               NULL               NULL
NULL                                      Faraway point                             NULL               NULL
NULL                                      Line going through left and right square  NULL               NULL
NULL                                      NULL                                      NULL               NULL
NULL                                      Nested Geometry Collection                NULL               NULL
NULL                                      Point middle of Left Square               NULL               NULL
NULL                                      Point middle of Right Square              NULL               NULL
NULL                                      Square (left)                             NULL               NULL
NULL                                      Square (right)                            NULL               NULL
NULL                                      Square overlapping left and right square  NULL               NULL
Nested Geometry Collection                Empty GeometryCollection                  NULL               NULL
Nested Geometry Collection                Empty LineString                          NULL               NULL
Nested Geometry Collection                Empty Point                               NULL               NULL
Nested Geometry Collection                Faraway point                             7.07106781186548   7.07106781186548
Nested Geometry Collection                Line going through left and right square  0.5                0.707106781186548
Nested Geometry Collection                NULL                                      NULL               NULL
Nested Geometry Collection                Nested Geometry Collection                0                  0
Nested Geometry Collection                Point middle of Left Square               0.707106781186548  0.707106781186548
Nested Geometry Collection                Point middle of Right Square              0.707106781186548  0.707106781186548
Nested Geometry Collection                Square (left)                             0                  1.4142135623731
Nested Geometry Collection                Square (right)                            0                  1.4142135623731
Nested Geometry Collection                Square overlapping left and right square  0                  1.4142135623731
Point middle of Left Square               Empty GeometryCollection                  NULL               NULL
Point middle of Left Square               Empty LineString                          NULL               NULL
Point middle of Left Square               Empty Point                               NULL               NULL
Point middle of Left Square               Faraway point                             7.10633520177595   7.10633520177595
Point middle of Left Square               Line going through left and right square  0                  1
Point middle of Left Square               NULL                                      NULL               NULL
Point middle of Left Square               Nested Geometry Collection                0.707106781186548  0.707106781186548
Point middle of Left Square               Point middle of Left Square               0                  0
Point middle of Left Square               Point middle of Right Square              1                  1
Point middle of Left Square               Square (left)                             0                  0.707106781186548
Point middle of Left Square               Square (right)                            0.5                1.58113883008419
Point middle of Left Square               Square overlapping left and right square  0.4                1.58113883008419
Point middle of Right Square              Empty GeometryCollection                  NULL               NULL
Point middle of Right Square              Empty LineString                          NULL               NULL
Point middle of Right Square              Empty Point                               NULL               NULL
Point middle of Right Square              Faraway point                             6.36396103067893   6.36396103067893
Point middle of Right Square              Line going through left and right square  0                  1
Point middle of Right Square              NULL                                      NULL               NULL
Point middle of Right Square              Nested Geometry Collection                0.707106781186548  0.707106781186548
Point middle of Right Square              Point middle of Left Square               1                  1
Point middle of Right Square              Point middle of Right Square              0                  0
Point middle of Right Square              Square (left)                             0.5                1.58113883008419
Point middle of Right Square              Square (right)                            0                  0.707106781186548
Point middle of Right Square              Square overlapping left and right square  0                  0.781024967590665
Square (left)                             Empty GeometryCollection                  NULL               NULL
Square (left)                             Empty LineString                          NULL               NULL
Square (left)                             Empty Point                               NULL               NULL
Square (left)                             Faraway point                             6.40312423743285   7.81024967590665
Square (left)                             Line going through left and right square  0                  1.58113883008419
Square (left)                             NULL                                      NULL               NULL
Square (left)                             Nested Geometry Collection                0                  1.4142135623731
Square (left)                             Point middle of Left Square               0                  0.707106781186548
Square (left)                             Point middle of Right Square              0.5                1.58113883008419
Square (left)                             Square (left)                             0                  1.4142135623731
Square (left)                             Square (right)                            0                  2.23606797749979
Square (left)                             Square overlapping left and right square  0                  2.23606797749979
Square (right)                            Empty GeometryCollection                  NULL               NULL
Square (right)                            Empty LineString                          NULL               NULL
Square (right)                            Empty Point                               NULL               NULL
Square (right)                            Faraway point                             5.65685424949238   7.07106781186548
Square (right)                            Line going through left and right square  0                  1.58113883008419
Square (right)                            NULL                                      NULL               NULL
Square (right)                            Nested Geometry Collection                0                  1.4142135623731
Square (right)                            Point middle of Left Square               0.5                1.58113883008419
Square (right)                            Point middle of Right Square              0                  0.707106781186548
Square (right)                            Square (left)                             0                  2.23606797749979
Square (right)                            Square (right)                            0                  1.4142135623731
Square (right)                            Square overlapping left and right square  0                  1.48660687473185
Square overlapping left and right square  Empty GeometryCollection                  NULL               NULL
Square overlapping left and right square  Empty LineString                          NULL               NULL
Square overlapping left and right square  Empty Point                               NULL               NULL
Square overlapping left and right square  Faraway point                             5.65685424949238   7.14212853426764
Square overlapping left and right square  Line going through left and right square  0                  1.58113883008419
Square overlapping left and right square  NULL                                      NULL               NULL
Square overlapping left and right square  Nested Geometry Collection                0                  1.4142135623731
Square overlapping left and right square  Point middle of Left Square               0.4                1.58113883008419
Square overlapping left and right square  Point middle of Right Square              0                  0.781024967590665
Square overlapping left and right square  Square (left)                             0                  2.23606797749979
Square overlapping left and right square  Square (right)                            0                  1.48660687473185
Square overlapping left and right square  Square overlapping left and right square  0                  1.48660687473185

# ST_DistanceSphere, ST_DistanceSpheroid
query TTRR
SELECT
  a.dsc,
  b.dsc,
  ST_DistanceSphere(a.geom, b.geom),
  ST_DistanceSpheroid(a.geom, b.geom)
FROM geom_operators_test a
JOIN geom_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  NULL              NULL
Empty GeometryCollection                  Empty LineString                          NULL              NULL
Empty GeometryCollection                  Empty Point                               NULL              NULL
Empty GeometryCollection                  Faraway point                             NULL              NULL
Empty GeometryCollection                  Line going through left and right square  NULL              NULL
Empty GeometryCollection                  NULL                                      NULL              NULL
Empty GeometryCollection                  Nested Geometry Collection                NULL              NULL
Empty GeometryCollection                  Point middle of Left Square               NULL              NULL
Empty GeometryCollection                  Point middle of Right Square              NULL              NULL
Empty GeometryCollection                  Square (left)                             NULL              NULL
Empty GeometryCollection                  Square (right)                            NULL              NULL
Empty GeometryCollection                  Square overlapping left and right square  NULL              NULL
Empty LineString                          Empty GeometryCollection                  NULL              NULL
Empty LineString                          Empty LineString                          NULL              NULL
Empty LineString                          Empty Point                               NULL              NULL
Empty LineString                          Faraway point                             NULL              NULL
Empty LineString                          Line going through left and right square  NULL              NULL
Empty LineString                          NULL                                      NULL              NULL
Empty LineString                          Nested Geometry Collection                NULL              NULL
Empty LineString                          Point middle of Left Square               NULL              NULL
Empty LineString                          Point middle of Right Square              NULL              NULL
Empty LineString                          Square (left)                             NULL              NULL
Empty LineString                          Square (right)                            NULL              NULL
Empty LineString                          Square overlapping left and right square  NULL              NULL
Empty Point                               Empty GeometryCollection                  NULL              NULL
Empty Point                               Empty LineString                          NULL              NULL
Empty Point                               Empty Point                               NULL              NULL
Empty Point                               Faraway point                             NULL              NULL
Empty Point                               Line going through left and right square  NULL              NULL
Empty Point                               NULL                                      NULL              NULL
Empty Point                               Nested Geometry Collection                NULL              NULL
Empty Point                               Point middle of Left Square               NULL              NULL
Empty Point                               Point middle of Right Square              NULL              NULL
Empty Point                               Square (left)                             NULL              NULL
Empty Point                               Square (right)                            NULL              NULL
Empty Point                               Square overlapping left and right square  NULL              NULL
Faraway point                             Empty GeometryCollection                  NULL              NULL
Faraway point                             Empty LineString                          NULL              NULL
Faraway point                             Empty Point                               NULL              NULL
Faraway point                             Faraway point                             0                 0
Faraway point                             Line going through left and right square  707142.162247235  705577.648328755
Faraway point                             NULL                                      NULL              NULL
Faraway point                             Nested Geometry Collection                785768.30266465   784028.73980903
Faraway point                             Point middle of Left Square               789521.780520966  788297.405265007
Faraway point                             Point middle of Right Square              707142.162247235  705577.648328755
Faraway point                             Square (left)                             711311.966664979  710260.975395327
Faraway point                             Square (right)                            628519.033787529  627129.502610754
Faraway point                             Square overlapping left and right square  628519.033787529  627129.502610754
Line going through left and right square  Empty GeometryCollection                  NULL              NULL
Line going through left and right square  Empty LineString                          NULL              NULL
Line going through left and right square  Empty Point                               NULL              NULL
Line going through left and right square  Faraway point                             707142.162247235  705577.648328755
Line going through left and right square  Line going through left and right square  0                 0
Line going through left and right square  NULL                                      NULL              NULL
Line going through left and right square  Nested Geometry Collection                55599.6568243979  55289.2571431371
Line going through left and right square  Point middle of Left Square               0                 0
Line going through left and right square  Point middle of Right Square              0                 0
Line going through left and right square  Square (left)                             0                 0
Line going through left and right square  Square (right)                            0                 0
Line going through left and right square  Square overlapping left and right square  0                 0
NULL                                      Empty GeometryCollection                  NULL              NULL
NULL                                      Empty LineString                          NULL              NULL
NULL                                      Empty Point                               NULL              NULL
NULL                                      Faraway point                             NULL              NULL
NULL                                      Line going through left and right square  NULL              NULL
NULL                                      NULL                                      NULL              NULL
NULL                                      Nested Geometry Collection                NULL              NULL
NULL                                      Point middle of Left Square               NULL              NULL
NULL                                      Point middle of Right Square              NULL              NULL
NULL                                      Square (left)                             NULL              NULL
NULL                                      Square (right)                            NULL              NULL
NULL                                      Square overlapping left and right square  NULL              NULL
Nested Geometry Collection                Empty GeometryCollection                  NULL              NULL
Nested Geometry Collection                Empty LineString                          NULL              NULL
Nested Geometry Collection                Empty Point                               NULL              NULL
Nested Geometry Collection                Faraway point                             785768.30266465   784028.73980903
Nested Geometry Collection                Line going through left and right square  55599.6568243979  55289.2571431371
Nested Geometry Collection                NULL                                      NULL              NULL
Nested Geometry Collection                Nested Geometry Collection                0                 0
Nested Geometry Collection                Point middle of Left Square               78626.2959272162  78451.2480312391
Nested Geometry Collection                Point middle of Right Square              78626.2959272162  78451.2480312391
Nested Geometry Collection                Square (left)                             0                 0
Nested Geometry Collection                Square (right)                            0                 0
Nested Geometry Collection                Square overlapping left and right square  0                 0
Point middle of Left Square               Empty GeometryCollection                  NULL              NULL
Point middle of Left Square               Empty LineString                          NULL              NULL
Point middle of Left Square               Empty Point                               NULL              NULL
Point middle of Left Square               Faraway point                             789521.780520966  788297.405265007
Point middle of Left Square               Line going through left and right square  0                 0
Point middle of Left Square               NULL                                      NULL              NULL
Point middle of Left Square               Nested Geometry Collection                78626.2959272162  78451.2480312391
Point middle of Left Square               Point middle of Left Square               0                 0
Point middle of Left Square               Point middle of Right Square              111190.845659241  111315.280354463
Point middle of Left Square               Square (left)                             0                 0
Point middle of Left Square               Square (right)                            55595.4228296203  55657.6401772334
Point middle of Left Square               Square overlapping left and right square  44476.338279173   44526.1121572803
Point middle of Right Square              Empty GeometryCollection                  NULL              NULL
Point middle of Right Square              Empty LineString                          NULL              NULL
Point middle of Right Square              Empty Point                               NULL              NULL
Point middle of Right Square              Faraway point                             707142.162247235  705577.648328755
Point middle of Right Square              Line going through left and right square  0                 0
Point middle of Right Square              NULL                                      NULL              NULL
Point middle of Right Square              Nested Geometry Collection                78626.2959272162  78451.2480312391
Point middle of Right Square              Point middle of Left Square               111190.845659241  111315.280354463
Point middle of Right Square              Point middle of Right Square              0                 0
Point middle of Right Square              Square (left)                             55595.4228296203  55657.6401772334
Point middle of Right Square              Square (right)                            0                 0
Point middle of Right Square              Square overlapping left and right square  0                 0
Square (left)                             Empty GeometryCollection                  NULL              NULL
Square (left)                             Empty LineString                          NULL              NULL
Square (left)                             Empty Point                               NULL              NULL
Square (left)                             Faraway point                             711311.966664979  710260.975395327
Square (left)                             Line going through left and right square  0                 0
Square (left)                             NULL                                      NULL              NULL
Square (left)                             Nested Geometry Collection                0                 0
Square (left)                             Point middle of Left Square               0                 0
Square (left)                             Point middle of Right Square              55595.4228296203  55657.6401772334
Square (left)                             Square (left)                             0                 0
Square (left)                             Square (right)                            0                 0
Square (left)                             Square overlapping left and right square  0                 0
Square (right)                            Empty GeometryCollection                  NULL              NULL
Square (right)                            Empty LineString                          NULL              NULL
Square (right)                            Empty Point                               NULL              NULL
Square (right)                            Faraway point                             628519.033787529  627129.502610754
Square (right)                            Line going through left and right square  0                 0
Square (right)                            NULL                                      NULL              NULL
Square (right)                            Nested Geometry Collection                0                 0
Square (right)                            Point middle of Left Square               55595.4228296203  55657.6401772334
Square (right)                            Point middle of Right Square              0                 0
Square (right)                            Square (left)                             0                 0
Square (right)                            Square (right)                            0                 0
Square (right)                            Square overlapping left and right square  0                 0
Square overlapping left and right square  Empty GeometryCollection                  NULL              NULL
Square overlapping left and right square  Empty LineString                          NULL              NULL
Square overlapping left and right square  Empty Point                               NULL              NULL
Square overlapping left and right square  Faraway point                             628519.033787529  627129.502610754
Square overlapping left and right square  Line going through left and right square  0                 0
Square overlapping left and right square  NULL                                      NULL              NULL
Square overlapping left and right square  Nested Geometry Collection                0                 0
Square overlapping left and right square  Point middle of Left Square               44476.338279173   44526.1121572803
Square overlapping left and right square  Point middle of Right Square              0                 0
Square overlapping left and right square  Square (left)                             0                 0
Square overlapping left and right square  Square (right)                            0                 0
Square overlapping left and right square  Square overlapping left and right square  0                 0

# ST_LongestLine, ST_ShortestLine
query TTTT
SELECT
  a.dsc,
  b.dsc,
  ST_AsText(ST_LongestLine(a.geom, b.geom)),
  ST_AsText(ST_ShortestLine(a.geom, b.geom))
FROM geom_operators_test a
JOIN geom_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  NULL                             NULL
Empty GeometryCollection                  Empty LineString                          NULL                             NULL
Empty GeometryCollection                  Empty Point                               NULL                             NULL
Empty GeometryCollection                  Faraway point                             NULL                             NULL
Empty GeometryCollection                  Line going through left and right square  NULL                             NULL
Empty GeometryCollection                  NULL                                      NULL                             NULL
Empty GeometryCollection                  Nested Geometry Collection                NULL                             NULL
Empty GeometryCollection                  Point middle of Left Square               NULL                             NULL
Empty GeometryCollection                  Point middle of Right Square              NULL                             NULL
Empty GeometryCollection                  Square (left)                             NULL                             NULL
Empty GeometryCollection                  Square (right)                            NULL                             NULL
Empty GeometryCollection                  Square overlapping left and right square  NULL                             NULL
Empty LineString                          Empty GeometryCollection                  NULL                             NULL
Empty LineString                          Empty LineString                          NULL                             NULL
Empty LineString                          Empty Point                               NULL                             NULL
Empty LineString                          Faraway point                             NULL                             NULL
Empty LineString                          Line going through left and right square  NULL                             NULL
Empty LineString                          NULL                                      NULL                             NULL
Empty LineString                          Nested Geometry Collection                NULL                             NULL
Empty LineString                          Point middle of Left Square               NULL                             NULL
Empty LineString                          Point middle of Right Square              NULL                             NULL
Empty LineString                          Square (left)                             NULL                             NULL
Empty LineString                          Square (right)                            NULL                             NULL
Empty LineString                          Square overlapping left and right square  NULL                             NULL
Empty Point                               Empty GeometryCollection                  NULL                             NULL
Empty Point                               Empty LineString                          NULL                             NULL
Empty Point                               Empty Point                               NULL                             NULL
Empty Point                               Faraway point                             NULL                             NULL
Empty Point                               Line going through left and right square  NULL                             NULL
Empty Point                               NULL                                      NULL                             NULL
Empty Point                               Nested Geometry Collection                NULL                             NULL
Empty Point                               Point middle of Left Square               NULL                             NULL
Empty Point                               Point middle of Right Square              NULL                             NULL
Empty Point                               Square (left)                             NULL                             NULL
Empty Point                               Square (right)                            NULL                             NULL
Empty Point                               Square overlapping left and right square  NULL                             NULL
Faraway point                             Empty GeometryCollection                  NULL                             NULL
Faraway point                             Empty LineString                          NULL                             NULL
Faraway point                             Empty Point                               NULL                             NULL
Faraway point                             Faraway point                             LINESTRING (5 5, 5 5)            LINESTRING (5 5, 5 5)
Faraway point                             Line going through left and right square  LINESTRING (5 5, -0.5 0.5)       LINESTRING (5 5, 0.5 0.5)
Faraway point                             NULL                                      NULL                             NULL
Faraway point                             Nested Geometry Collection                LINESTRING (5 5, 0 0)            LINESTRING (5 5, 0 0)
Faraway point                             Point middle of Left Square               LINESTRING (5 5, -0.5 0.5)       LINESTRING (5 5, -0.5 0.5)
Faraway point                             Point middle of Right Square              LINESTRING (5 5, 0.5 0.5)        LINESTRING (5 5, 0.5 0.5)
Faraway point                             Square (left)                             LINESTRING (5 5, -1 0)           LINESTRING (5 5, 0 1)
Faraway point                             Square (right)                            LINESTRING (5 5, 0 0)            LINESTRING (5 5, 1 1)
Faraway point                             Square overlapping left and right square  LINESTRING (5 5, -0.1 0)         LINESTRING (5 5, 1 1)
Line going through left and right square  Empty GeometryCollection                  NULL                             NULL
Line going through left and right square  Empty LineString                          NULL                             NULL
Line going through left and right square  Empty Point                               NULL                             NULL
Line going through left and right square  Faraway point                             LINESTRING (-0.5 0.5, 5 5)       LINESTRING (0.5 0.5, 5 5)
Line going through left and right square  Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)   LINESTRING (-0.5 0.5, -0.5 0.5)
Line going through left and right square  NULL                                      NULL                             NULL
Line going through left and right square  Nested Geometry Collection                LINESTRING (-0.5 0.5, 0 0)       LINESTRING (0 0.5, 0 0)
Line going through left and right square  Point middle of Left Square               LINESTRING (0.5 0.5, -0.5 0.5)   LINESTRING (-0.5 0.5, -0.5 0.5)
Line going through left and right square  Point middle of Right Square              LINESTRING (-0.5 0.5, 0.5 0.5)   LINESTRING (0.5 0.5, 0.5 0.5)
Line going through left and right square  Square (left)                             LINESTRING (0.5 0.5, -1 0)       LINESTRING (-0.5 0.5, -0.5 0.5)
Line going through left and right square  Square (right)                            LINESTRING (-0.5 0.5, 1 0)       LINESTRING (0 0.5, 0 0.5)
Line going through left and right square  Square overlapping left and right square  LINESTRING (-0.5 0.5, 1 0)       LINESTRING (-0.1 0.5, -0.1 0.5)
NULL                                      Empty GeometryCollection                  NULL                             NULL
NULL                                      Empty LineString                          NULL                             NULL
NULL                                      Empty Point                               NULL                             NULL
NULL                                      Faraway point                             NULL                             NULL
NULL                                      Line going through left and right square  NULL                             NULL
NULL                                      NULL                                      NULL                             NULL
NULL                                      Nested Geometry Collection                NULL                             NULL
NULL                                      Point middle of Left Square               NULL                             NULL
NULL                                      Point middle of Right Square              NULL                             NULL
NULL                                      Square (left)                             NULL                             NULL
NULL                                      Square (right)                            NULL                             NULL
NULL                                      Square overlapping left and right square  NULL                             NULL
Nested Geometry Collection                Empty GeometryCollection                  NULL                             NULL
Nested Geometry Collection                Empty LineString                          NULL                             NULL
Nested Geometry Collection                Empty Point                               NULL                             NULL
Nested Geometry Collection                Faraway point                             LINESTRING (0 0, 5 5)            LINESTRING (0 0, 5 5)
Nested Geometry Collection                Line going through left and right square  LINESTRING (0 0, -0.5 0.5)       LINESTRING (0 0, 0 0.5)
Nested Geometry Collection                NULL                                      NULL                             NULL
Nested Geometry Collection                Nested Geometry Collection                LINESTRING (0 0, 0 0)            LINESTRING (0 0, 0 0)
Nested Geometry Collection                Point middle of Left Square               LINESTRING (0 0, -0.5 0.5)       LINESTRING (0 0, -0.5 0.5)
Nested Geometry Collection                Point middle of Right Square              LINESTRING (0 0, 0.5 0.5)        LINESTRING (0 0, 0.5 0.5)
Nested Geometry Collection                Square (left)                             LINESTRING (0 0, -1 1)           LINESTRING (0 0, 0 0)
Nested Geometry Collection                Square (right)                            LINESTRING (0 0, 1 1)            LINESTRING (0 0, 0 0)
Nested Geometry Collection                Square overlapping left and right square  LINESTRING (0 0, 1 1)            LINESTRING (0 0, 0 0)
Point middle of Left Square               Empty GeometryCollection                  NULL                             NULL
Point middle of Left Square               Empty LineString                          NULL                             NULL
Point middle of Left Square               Empty Point                               NULL                             NULL
Point middle of Left Square               Faraway point                             LINESTRING (-0.5 0.5, 5 5)       LINESTRING (-0.5 0.5, 5 5)
Point middle of Left Square               Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)   LINESTRING (-0.5 0.5, -0.5 0.5)
Point middle of Left Square               NULL                                      NULL                             NULL
Point middle of Left Square               Nested Geometry Collection                LINESTRING (-0.5 0.5, 0 0)       LINESTRING (-0.5 0.5, 0 0)
Point middle of Left Square               Point middle of Left Square               LINESTRING (-0.5 0.5, -0.5 0.5)  LINESTRING (-0.5 0.5, -0.5 0.5)
Point middle of Left Square               Point middle of Right Square              LINESTRING (-0.5 0.5, 0.5 0.5)   LINESTRING (-0.5 0.5, 0.5 0.5)
Point middle of Left Square               Square (left)                             LINESTRING (-0.5 0.5, 0 0)       LINESTRING (-0.5 0.5, -0.5 0.5)
Point middle of Left Square               Square (right)                            LINESTRING (-0.5 0.5, 1 0)       LINESTRING (-0.5 0.5, 0 0.5)
Point middle of Left Square               Square overlapping left and right square  LINESTRING (-0.5 0.5, 1 0)       LINESTRING (-0.5 0.5, -0.1 0.5)
Point middle of Right Square              Empty GeometryCollection                  NULL                             NULL
Point middle of Right Square              Empty LineString                          NULL                             NULL
Point middle of Right Square              Empty Point                               NULL                             NULL
Point middle of Right Square              Faraway point                             LINESTRING (0.5 0.5, 5 5)        LINESTRING (0.5 0.5, 5 5)
Point middle of Right Square              Line going through left and right square  LINESTRING (0.5 0.5, -0.5 0.5)   LINESTRING (0.5 0.5, 0.5 0.5)
Point middle of Right Square              NULL                                      NULL                             NULL
Point middle of Right Square              Nested Geometry Collection                LINESTRING (0.5 0.5, 0 0)        LINESTRING (0.5 0.5, 0 0)
Point middle of Right Square              Point middle of Left Square               LINESTRING (0.5 0.5, -0.5 0.5)   LINESTRING (0.5 0.5, -0.5 0.5)
Point middle of Right Square              Point middle of Right Square              LINESTRING (0.5 0.5, 0.5 0.5)    LINESTRING (0.5 0.5, 0.5 0.5)
Point middle of Right Square              Square (left)                             LINESTRING (0.5 0.5, -1 1)       LINESTRING (0.5 0.5, 0 0.5)
Point middle of Right Square              Square (right)                            LINESTRING (0.5 0.5, 1 0)        LINESTRING (0.5 0.5, 0.5 0.5)
Point middle of Right Square              Square overlapping left and right square  LINESTRING (0.5 0.5, -0.1 1)     LINESTRING (0.5 0.5, 0.5 0.5)
Square (left)                             Empty GeometryCollection                  NULL                             NULL
Square (left)                             Empty LineString                          NULL                             NULL
Square (left)                             Empty Point                               NULL                             NULL
Square (left)                             Faraway point                             LINESTRING (-1 0, 5 5)           LINESTRING (0 1, 5 5)
Square (left)                             Line going through left and right square  LINESTRING (-1 0, 0.5 0.5)       LINESTRING (-0.5 0.5, -0.5 0.5)
Square (left)                             NULL                                      NULL                             NULL
Square (left)                             Nested Geometry Collection                LINESTRING (-1 1, 0 0)           LINESTRING (0 0, 0 0)
Square (left)                             Point middle of Left Square               LINESTRING (0 0, -0.5 0.5)       LINESTRING (-0.5 0.5, -0.5 0.5)
Square (left)                             Point middle of Right Square              LINESTRING (-1 1, 0.5 0.5)       LINESTRING (0 0.5, 0.5 0.5)
Square (left)                             Square (left)                             LINESTRING (-1 0, 0 1)           LINESTRING (-1 0, -1 0)
Square (left)                             Square (right)                            LINESTRING (-1 0, 1 1)           LINESTRING (0 0, 0 0)
Square (left)                             Square overlapping left and right square  LINESTRING (-1 0, 1 1)           LINESTRING (-0.1 0, -0.1 0)
Square (right)                            Empty GeometryCollection                  NULL                             NULL
Square (right)                            Empty LineString                          NULL                             NULL
Square (right)                            Empty Point                               NULL                             NULL
Square (right)                            Faraway point                             LINESTRING (0 0, 5 5)            LINESTRING (1 1, 5 5)
Square (right)                            Line going through left and right square  LINESTRING (1 0, -0.5 0.5)       LINESTRING (0 0.5, 0 0.5)
Square (right)                            NULL                                      NULL                             NULL
Square (right)                            Nested Geometry Collection                LINESTRING (1 1, 0 0)            LINESTRING (0 0, 0 0)
Square (right)                            Point middle of Left Square               LINESTRING (1 0, -0.5 0.5)       LINESTRING (0 0.5, -0.5 0.5)
Square (right)                            Point middle of Right Square              LINESTRING (1 0, 0.5 0.5)        LINESTRING (0.5 0.5, 0.5 0.5)
Square (right)                            Square (left)                             LINESTRING (1 0, -1 1)           LINESTRING (0 0, 0 0)
Square (right)                            Square (right)                            LINESTRING (0 0, 1 1)            LINESTRING (0 0, 0 0)
Square (right)                            Square overlapping left and right square  LINESTRING (1 0, -0.1 1)         LINESTRING (0 0, 0 0)
Square overlapping left and right square  Empty GeometryCollection                  NULL                             NULL
Square overlapping left and right square  Empty LineString                          NULL                             NULL
Square overlapping left and right square  Empty Point                               NULL                             NULL
Square overlapping left and right square  Faraway point                             LINESTRING (-0.1 0, 5 5)         LINESTRING (1 1, 5 5)
Square overlapping left and right square  Line going through left and right square  LINESTRING (1 0, -0.5 0.5)       LINESTRING (-0.1 0.5, -0.1 0.5)
Square overlapping left and right square  NULL                                      NULL                             NULL
Square overlapping left and right square  Nested Geometry Collection                LINESTRING (1 1, 0 0)            LINESTRING (0 0, 0 0)
Square overlapping left and right square  Point middle of Left Square               LINESTRING (1 0, -0.5 0.5)       LINESTRING (-0.1 0.5, -0.5 0.5)
Square overlapping left and right square  Point middle of Right Square              LINESTRING (-0.1 1, 0.5 0.5)     LINESTRING (0.5 0.5, 0.5 0.5)
Square overlapping left and right square  Square (left)                             LINESTRING (1 0, -1 1)           LINESTRING (-0.1 0, -0.1 0)
Square overlapping left and right square  Square (right)                            LINESTRING (-0.1 0, 1 1)         LINESTRING (0 0, 0 0)
Square overlapping left and right square  Square overlapping left and right square  LINESTRING (-0.1 0, 1 1)         LINESTRING (-0.1 0, -0.1 0)

# Binary predicates
query TTBBBBBBBBBBB
SELECT
  a.dsc,
  b.dsc,
  ST_Covers(a.geom, b.geom),
  ST_CoveredBy(a.geom, b.geom),
  ST_Contains(a.geom, b.geom),
  ST_ContainsProperly(a.geom, b.geom),
  ST_Crosses(a.geom, b.geom),
  ST_Disjoint(a.geom, b.geom),
  ST_Equals(a.geom, b.geom),
  ST_Intersects(a.geom, b.geom),
  ST_Overlaps(a.geom, b.geom),
  ST_Touches(a.geom, b.geom),
  ST_Within(a.geom, b.geom)
FROM geom_operators_test a
JOIN geom_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  false  false  false  false  false  true   true   false  false  false  false
Empty GeometryCollection                  Empty LineString                          false  false  false  false  false  true   true   false  false  false  false
Empty GeometryCollection                  Empty Point                               false  false  false  false  false  true   true   false  false  false  false
Empty GeometryCollection                  Faraway point                             false  false  false  false  false  true   false  false  false  false  false
Empty GeometryCollection                  Line going through left and right square  false  false  false  false  false  true   false  false  false  false  false
Empty GeometryCollection                  NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Empty GeometryCollection                  Nested Geometry Collection                false  false  false  false  false  true   false  false  false  false  false
Empty GeometryCollection                  Point middle of Left Square               false  false  false  false  false  true   false  false  false  false  false
Empty GeometryCollection                  Point middle of Right Square              false  false  false  false  false  true   false  false  false  false  false
Empty GeometryCollection                  Square (left)                             false  false  false  false  false  true   false  false  false  false  false
Empty GeometryCollection                  Square (right)                            false  false  false  false  false  true   false  false  false  false  false
Empty GeometryCollection                  Square overlapping left and right square  false  false  false  false  false  true   false  false  false  false  false
Empty LineString                          Empty GeometryCollection                  false  false  false  false  false  true   true   false  false  false  false
Empty LineString                          Empty LineString                          false  false  false  false  false  true   true   false  false  false  false
Empty LineString                          Empty Point                               false  false  false  false  false  true   true   false  false  false  false
Empty LineString                          Faraway point                             false  false  false  false  false  true   false  false  false  false  false
Empty LineString                          Line going through left and right square  false  false  false  false  false  true   false  false  false  false  false
Empty LineString                          NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Empty LineString                          Nested Geometry Collection                false  false  false  false  false  true   false  false  false  false  false
Empty LineString                          Point middle of Left Square               false  false  false  false  false  true   false  false  false  false  false
Empty LineString                          Point middle of Right Square              false  false  false  false  false  true   false  false  false  false  false
Empty LineString                          Square (left)                             false  false  false  false  false  true   false  false  false  false  false
Empty LineString                          Square (right)                            false  false  false  false  false  true   false  false  false  false  false
Empty LineString                          Square overlapping left and right square  false  false  false  false  false  true   false  false  false  false  false
Empty Point                               Empty GeometryCollection                  false  false  false  false  false  true   true   false  false  false  false
Empty Point                               Empty LineString                          false  false  false  false  false  true   true   false  false  false  false
Empty Point                               Empty Point                               false  false  false  false  false  true   true   false  false  false  false
Empty Point                               Faraway point                             false  false  false  false  false  true   false  false  false  false  false
Empty Point                               Line going through left and right square  false  false  false  false  false  true   false  false  false  false  false
Empty Point                               NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Empty Point                               Nested Geometry Collection                false  false  false  false  false  true   false  false  false  false  false
Empty Point                               Point middle of Left Square               false  false  false  false  false  true   false  false  false  false  false
Empty Point                               Point middle of Right Square              false  false  false  false  false  true   false  false  false  false  false
Empty Point                               Square (left)                             false  false  false  false  false  true   false  false  false  false  false
Empty Point                               Square (right)                            false  false  false  false  false  true   false  false  false  false  false
Empty Point                               Square overlapping left and right square  false  false  false  false  false  true   false  false  false  false  false
Faraway point                             Empty GeometryCollection                  false  false  false  false  false  true   false  false  false  false  false
Faraway point                             Empty LineString                          false  false  false  false  false  true   false  false  false  false  false
Faraway point                             Empty Point                               false  false  false  false  false  true   false  false  false  false  false
Faraway point                             Faraway point                             true   true   true   true   false  false  true   true   false  false  true
Faraway point                             Line going through left and right square  false  false  false  false  false  true   false  false  false  false  false
Faraway point                             NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Faraway point                             Nested Geometry Collection                false  false  false  false  false  true   false  false  false  false  false
Faraway point                             Point middle of Left Square               false  false  false  false  false  true   false  false  false  false  false
Faraway point                             Point middle of Right Square              false  false  false  false  false  true   false  false  false  false  false
Faraway point                             Square (left)                             false  false  false  false  false  true   false  false  false  false  false
Faraway point                             Square (right)                            false  false  false  false  false  true   false  false  false  false  false
Faraway point                             Square overlapping left and right square  false  false  false  false  false  true   false  false  false  false  false
Line going through left and right square  Empty GeometryCollection                  false  false  false  false  false  true   false  false  false  false  false
Line going through left and right square  Empty LineString                          false  false  false  false  false  true   false  false  false  false  false
Line going through left and right square  Empty Point                               false  false  false  false  false  true   false  false  false  false  false
Line going through left and right square  Faraway point                             false  false  false  false  false  true   false  false  false  false  false
Line going through left and right square  Line going through left and right square  true   true   true   false  false  false  true   true   false  false  true
Line going through left and right square  NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Line going through left and right square  Nested Geometry Collection                false  false  false  false  false  true   false  false  false  false  false
Line going through left and right square  Point middle of Left Square               true   false  false  false  false  false  false  true   false  true   false
Line going through left and right square  Point middle of Right Square              true   false  false  false  false  false  false  true   false  true   false
Line going through left and right square  Square (left)                             false  false  false  false  true   false  false  true   false  false  false
Line going through left and right square  Square (right)                            false  false  false  false  true   false  false  true   false  false  false
Line going through left and right square  Square overlapping left and right square  false  false  false  false  true   false  false  true   false  false  false
NULL                                      Empty GeometryCollection                  NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Empty LineString                          NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Empty Point                               NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Faraway point                             NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Line going through left and right square  NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Nested Geometry Collection                NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Point middle of Left Square               NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Point middle of Right Square              NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Square (left)                             NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Square (right)                            NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Square overlapping left and right square  NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Nested Geometry Collection                Empty GeometryCollection                  false  false  false  false  false  true   false  false  false  false  false
Nested Geometry Collection                Empty LineString                          false  false  false  false  false  true   false  false  false  false  false
Nested Geometry Collection                Empty Point                               false  false  false  false  false  true   false  false  false  false  false
Nested Geometry Collection                Faraway point                             false  false  false  false  false  true   false  false  false  false  false
Nested Geometry Collection                Line going through left and right square  false  false  false  false  false  true   false  false  false  false  false
Nested Geometry Collection                NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Nested Geometry Collection                Nested Geometry Collection                true   true   true   true   false  false  true   true   false  false  true
Nested Geometry Collection                Point middle of Left Square               false  false  false  false  false  true   false  false  false  false  false
Nested Geometry Collection                Point middle of Right Square              false  false  false  false  false  true   false  false  false  false  false
Nested Geometry Collection                Square (left)                             false  true   false  false  false  false  false  true   false  true   false
Nested Geometry Collection                Square (right)                            false  true   false  false  false  false  false  true   false  true   false
Nested Geometry Collection                Square overlapping left and right square  false  true   false  false  false  false  false  true   false  true   false
Point middle of Left Square               Empty GeometryCollection                  false  false  false  false  false  true   false  false  false  false  false
Point middle of Left Square               Empty LineString                          false  false  false  false  false  true   false  false  false  false  false
Point middle of Left Square               Empty Point                               false  false  false  false  false  true   false  false  false  false  false
Point middle of Left Square               Faraway point                             false  false  false  false  false  true   false  false  false  false  false
Point middle of Left Square               Line going through left and right square  false  true   false  false  false  false  false  true   false  true   false
Point middle of Left Square               NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Point middle of Left Square               Nested Geometry Collection                false  false  false  false  false  true   false  false  false  false  false
Point middle of Left Square               Point middle of Left Square               true   true   true   true   false  false  true   true   false  false  true
Point middle of Left Square               Point middle of Right Square              false  false  false  false  false  true   false  false  false  false  false
Point middle of Left Square               Square (left)                             false  true   false  false  false  false  false  true   false  false  true
Point middle of Left Square               Square (right)                            false  false  false  false  false  true   false  false  false  false  false
Point middle of Left Square               Square overlapping left and right square  false  false  false  false  false  true   false  false  false  false  false
Point middle of Right Square              Empty GeometryCollection                  false  false  false  false  false  true   false  false  false  false  false
Point middle of Right Square              Empty LineString                          false  false  false  false  false  true   false  false  false  false  false
Point middle of Right Square              Empty Point                               false  false  false  false  false  true   false  false  false  false  false
Point middle of Right Square              Faraway point                             false  false  false  false  false  true   false  false  false  false  false
Point middle of Right Square              Line going through left and right square  false  true   false  false  false  false  false  true   false  true   false
Point middle of Right Square              NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Point middle of Right Square              Nested Geometry Collection                false  false  false  false  false  true   false  false  false  false  false
Point middle of Right Square              Point middle of Left Square               false  false  false  false  false  true   false  false  false  false  false
Point middle of Right Square              Point middle of Right Square              true   true   true   true   false  false  true   true   false  false  true
Point middle of Right Square              Square (left)                             false  false  false  false  false  true   false  false  false  false  false
Point middle of Right Square              Square (right)                            false  true   false  false  false  false  false  true   false  false  true
Point middle of Right Square              Square overlapping left and right square  false  true   false  false  false  false  false  true   false  false  true
Square (left)                             Empty GeometryCollection                  false  false  false  false  false  true   false  false  false  false  false
Square (left)                             Empty LineString                          false  false  false  false  false  true   false  false  false  false  false
Square (left)                             Empty Point                               false  false  false  false  false  true   false  false  false  false  false
Square (left)                             Faraway point                             false  false  false  false  false  true   false  false  false  false  false
Square (left)                             Line going through left and right square  false  false  false  false  true   false  false  true   false  false  false
Square (left)                             NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Square (left)                             Nested Geometry Collection                true   false  false  false  false  false  false  true   false  true   false
Square (left)                             Point middle of Left Square               true   false  true   true   false  false  false  true   false  false  false
Square (left)                             Point middle of Right Square              false  false  false  false  false  true   false  false  false  false  false
Square (left)                             Square (left)                             true   true   true   false  false  false  true   true   false  false  true
Square (left)                             Square (right)                            false  false  false  false  false  false  false  true   false  true   false
Square (left)                             Square overlapping left and right square  false  false  false  false  false  false  false  true   true   false  false
Square (right)                            Empty GeometryCollection                  false  false  false  false  false  true   false  false  false  false  false
Square (right)                            Empty LineString                          false  false  false  false  false  true   false  false  false  false  false
Square (right)                            Empty Point                               false  false  false  false  false  true   false  false  false  false  false
Square (right)                            Faraway point                             false  false  false  false  false  true   false  false  false  false  false
Square (right)                            Line going through left and right square  false  false  false  false  true   false  false  true   false  false  false
Square (right)                            NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Square (right)                            Nested Geometry Collection                true   false  false  false  false  false  false  true   false  true   false
Square (right)                            Point middle of Left Square               false  false  false  false  false  true   false  false  false  false  false
Square (right)                            Point middle of Right Square              true   false  true   true   false  false  false  true   false  false  false
Square (right)                            Square (left)                             false  false  false  false  false  false  false  true   false  true   false
Square (right)                            Square (right)                            true   true   true   false  false  false  true   true   false  false  true
Square (right)                            Square overlapping left and right square  false  true   false  false  false  false  false  true   false  false  true
Square overlapping left and right square  Empty GeometryCollection                  false  false  false  false  false  true   false  false  false  false  false
Square overlapping left and right square  Empty LineString                          false  false  false  false  false  true   false  false  false  false  false
Square overlapping left and right square  Empty Point                               false  false  false  false  false  true   false  false  false  false  false
Square overlapping left and right square  Faraway point                             false  false  false  false  false  true   false  false  false  false  false
Square overlapping left and right square  Line going through left and right square  false  false  false  false  true   false  false  true   false  false  false
Square overlapping left and right square  NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Square overlapping left and right square  Nested Geometry Collection                true   false  false  false  false  false  false  true   false  true   false
Square overlapping left and right square  Point middle of Left Square               false  false  false  false  false  true   false  false  false  false  false
Square overlapping left and right square  Point middle of Right Square              true   false  true   true   false  false  false  true   false  false  false
Square overlapping left and right square  Square (left)                             false  false  false  false  false  false  false  true   true   false  false
Square overlapping left and right square  Square (right)                            true   false  true   false  false  false  false  true   false  false  false
Square overlapping left and right square  Square overlapping left and right square  true   true   true   false  false  false  true   true   false  false  true

query TTBBBBBBBBBB
SELECT
  a.dsc,
  b.dsc,
  _ST_Covers(a.geom, b.geom),
  _ST_CoveredBy(a.geom, b.geom),
  _ST_Contains(a.geom, b.geom),
  _ST_ContainsProperly(a.geom, b.geom),
  _ST_Crosses(a.geom, b.geom),
  _ST_Equals(a.geom, b.geom),
  _ST_Intersects(a.geom, b.geom),
  _ST_Overlaps(a.geom, b.geom),
  _ST_Touches(a.geom, b.geom),
  _ST_Within(a.geom, b.geom)
FROM geom_operators_test a
JOIN geom_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  false  false  false  false  false  true   false  false  false  false
Empty GeometryCollection                  Empty LineString                          false  false  false  false  false  true   false  false  false  false
Empty GeometryCollection                  Empty Point                               false  false  false  false  false  true   false  false  false  false
Empty GeometryCollection                  Faraway point                             false  false  false  false  false  false  false  false  false  false
Empty GeometryCollection                  Line going through left and right square  false  false  false  false  false  false  false  false  false  false
Empty GeometryCollection                  NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Empty GeometryCollection                  Nested Geometry Collection                false  false  false  false  false  false  false  false  false  false
Empty GeometryCollection                  Point middle of Left Square               false  false  false  false  false  false  false  false  false  false
Empty GeometryCollection                  Point middle of Right Square              false  false  false  false  false  false  false  false  false  false
Empty GeometryCollection                  Square (left)                             false  false  false  false  false  false  false  false  false  false
Empty GeometryCollection                  Square (right)                            false  false  false  false  false  false  false  false  false  false
Empty GeometryCollection                  Square overlapping left and right square  false  false  false  false  false  false  false  false  false  false
Empty LineString                          Empty GeometryCollection                  false  false  false  false  false  true   false  false  false  false
Empty LineString                          Empty LineString                          false  false  false  false  false  true   false  false  false  false
Empty LineString                          Empty Point                               false  false  false  false  false  true   false  false  false  false
Empty LineString                          Faraway point                             false  false  false  false  false  false  false  false  false  false
Empty LineString                          Line going through left and right square  false  false  false  false  false  false  false  false  false  false
Empty LineString                          NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Empty LineString                          Nested Geometry Collection                false  false  false  false  false  false  false  false  false  false
Empty LineString                          Point middle of Left Square               false  false  false  false  false  false  false  false  false  false
Empty LineString                          Point middle of Right Square              false  false  false  false  false  false  false  false  false  false
Empty LineString                          Square (left)                             false  false  false  false  false  false  false  false  false  false
Empty LineString                          Square (right)                            false  false  false  false  false  false  false  false  false  false
Empty LineString                          Square overlapping left and right square  false  false  false  false  false  false  false  false  false  false
Empty Point                               Empty GeometryCollection                  false  false  false  false  false  true   false  false  false  false
Empty Point                               Empty LineString                          false  false  false  false  false  true   false  false  false  false
Empty Point                               Empty Point                               false  false  false  false  false  true   false  false  false  false
Empty Point                               Faraway point                             false  false  false  false  false  false  false  false  false  false
Empty Point                               Line going through left and right square  false  false  false  false  false  false  false  false  false  false
Empty Point                               NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Empty Point                               Nested Geometry Collection                false  false  false  false  false  false  false  false  false  false
Empty Point                               Point middle of Left Square               false  false  false  false  false  false  false  false  false  false
Empty Point                               Point middle of Right Square              false  false  false  false  false  false  false  false  false  false
Empty Point                               Square (left)                             false  false  false  false  false  false  false  false  false  false
Empty Point                               Square (right)                            false  false  false  false  false  false  false  false  false  false
Empty Point                               Square overlapping left and right square  false  false  false  false  false  false  false  false  false  false
Faraway point                             Empty GeometryCollection                  false  false  false  false  false  false  false  false  false  false
Faraway point                             Empty LineString                          false  false  false  false  false  false  false  false  false  false
Faraway point                             Empty Point                               false  false  false  false  false  false  false  false  false  false
Faraway point                             Faraway point                             true   true   true   true   false  true   true   false  false  true
Faraway point                             Line going through left and right square  false  false  false  false  false  false  false  false  false  false
Faraway point                             NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Faraway point                             Nested Geometry Collection                false  false  false  false  false  false  false  false  false  false
Faraway point                             Point middle of Left Square               false  false  false  false  false  false  false  false  false  false
Faraway point                             Point middle of Right Square              false  false  false  false  false  false  false  false  false  false
Faraway point                             Square (left)                             false  false  false  false  false  false  false  false  false  false
Faraway point                             Square (right)                            false  false  false  false  false  false  false  false  false  false
Faraway point                             Square overlapping left and right square  false  false  false  false  false  false  false  false  false  false
Line going through left and right square  Empty GeometryCollection                  false  false  false  false  false  false  false  false  false  false
Line going through left and right square  Empty LineString                          false  false  false  false  false  false  false  false  false  false
Line going through left and right square  Empty Point                               false  false  false  false  false  false  false  false  false  false
Line going through left and right square  Faraway point                             false  false  false  false  false  false  false  false  false  false
Line going through left and right square  Line going through left and right square  true   true   true   false  false  true   true   false  false  true
Line going through left and right square  NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Line going through left and right square  Nested Geometry Collection                false  false  false  false  false  false  false  false  false  false
Line going through left and right square  Point middle of Left Square               true   false  false  false  false  false  true   false  true   false
Line going through left and right square  Point middle of Right Square              true   false  false  false  false  false  true   false  true   false
Line going through left and right square  Square (left)                             false  false  false  false  true   false  true   false  false  false
Line going through left and right square  Square (right)                            false  false  false  false  true   false  true   false  false  false
Line going through left and right square  Square overlapping left and right square  false  false  false  false  true   false  true   false  false  false
NULL                                      Empty GeometryCollection                  NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Empty LineString                          NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Empty Point                               NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Faraway point                             NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Line going through left and right square  NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Nested Geometry Collection                NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Point middle of Left Square               NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Point middle of Right Square              NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Square (left)                             NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Square (right)                            NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
NULL                                      Square overlapping left and right square  NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Nested Geometry Collection                Empty GeometryCollection                  false  false  false  false  false  false  false  false  false  false
Nested Geometry Collection                Empty LineString                          false  false  false  false  false  false  false  false  false  false
Nested Geometry Collection                Empty Point                               false  false  false  false  false  false  false  false  false  false
Nested Geometry Collection                Faraway point                             false  false  false  false  false  false  false  false  false  false
Nested Geometry Collection                Line going through left and right square  false  false  false  false  false  false  false  false  false  false
Nested Geometry Collection                NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Nested Geometry Collection                Nested Geometry Collection                true   true   true   true   false  true   true   false  false  true
Nested Geometry Collection                Point middle of Left Square               false  false  false  false  false  false  false  false  false  false
Nested Geometry Collection                Point middle of Right Square              false  false  false  false  false  false  false  false  false  false
Nested Geometry Collection                Square (left)                             false  true   false  false  false  false  true   false  true   false
Nested Geometry Collection                Square (right)                            false  true   false  false  false  false  true   false  true   false
Nested Geometry Collection                Square overlapping left and right square  false  true   false  false  false  false  true   false  true   false
Point middle of Left Square               Empty GeometryCollection                  false  false  false  false  false  false  false  false  false  false
Point middle of Left Square               Empty LineString                          false  false  false  false  false  false  false  false  false  false
Point middle of Left Square               Empty Point                               false  false  false  false  false  false  false  false  false  false
Point middle of Left Square               Faraway point                             false  false  false  false  false  false  false  false  false  false
Point middle of Left Square               Line going through left and right square  false  true   false  false  false  false  true   false  true   false
Point middle of Left Square               NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Point middle of Left Square               Nested Geometry Collection                false  false  false  false  false  false  false  false  false  false
Point middle of Left Square               Point middle of Left Square               true   true   true   true   false  true   true   false  false  true
Point middle of Left Square               Point middle of Right Square              false  false  false  false  false  false  false  false  false  false
Point middle of Left Square               Square (left)                             false  true   false  false  false  false  true   false  false  true
Point middle of Left Square               Square (right)                            false  false  false  false  false  false  false  false  false  false
Point middle of Left Square               Square overlapping left and right square  false  false  false  false  false  false  false  false  false  false
Point middle of Right Square              Empty GeometryCollection                  false  false  false  false  false  false  false  false  false  false
Point middle of Right Square              Empty LineString                          false  false  false  false  false  false  false  false  false  false
Point middle of Right Square              Empty Point                               false  false  false  false  false  false  false  false  false  false
Point middle of Right Square              Faraway point                             false  false  false  false  false  false  false  false  false  false
Point middle of Right Square              Line going through left and right square  false  true   false  false  false  false  true   false  true   false
Point middle of Right Square              NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Point middle of Right Square              Nested Geometry Collection                false  false  false  false  false  false  false  false  false  false
Point middle of Right Square              Point middle of Left Square               false  false  false  false  false  false  false  false  false  false
Point middle of Right Square              Point middle of Right Square              true   true   true   true   false  true   true   false  false  true
Point middle of Right Square              Square (left)                             false  false  false  false  false  false  false  false  false  false
Point middle of Right Square              Square (right)                            false  true   false  false  false  false  true   false  false  true
Point middle of Right Square              Square overlapping left and right square  false  true   false  false  false  false  true   false  false  true
Square (left)                             Empty GeometryCollection                  false  false  false  false  false  false  false  false  false  false
Square (left)                             Empty LineString                          false  false  false  false  false  false  false  false  false  false
Square (left)                             Empty Point                               false  false  false  false  false  false  false  false  false  false
Square (left)                             Faraway point                             false  false  false  false  false  false  false  false  false  false
Square (left)                             Line going through left and right square  false  false  false  false  true   false  true   false  false  false
Square (left)                             NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Square (left)                             Nested Geometry Collection                true   false  false  false  false  false  true   false  true   false
Square (left)                             Point middle of Left Square               true   false  true   true   false  false  true   false  false  false
Square (left)                             Point middle of Right Square              false  false  false  false  false  false  false  false  false  false
Square (left)                             Square (left)                             true   true   true   false  false  true   true   false  false  true
Square (left)                             Square (right)                            false  false  false  false  false  false  true   false  true   false
Square (left)                             Square overlapping left and right square  false  false  false  false  false  false  true   true   false  false
Square (right)                            Empty GeometryCollection                  false  false  false  false  false  false  false  false  false  false
Square (right)                            Empty LineString                          false  false  false  false  false  false  false  false  false  false
Square (right)                            Empty Point                               false  false  false  false  false  false  false  false  false  false
Square (right)                            Faraway point                             false  false  false  false  false  false  false  false  false  false
Square (right)                            Line going through left and right square  false  false  false  false  true   false  true   false  false  false
Square (right)                            NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Square (right)                            Nested Geometry Collection                true   false  false  false  false  false  true   false  true   false
Square (right)                            Point middle of Left Square               false  false  false  false  false  false  false  false  false  false
Square (right)                            Point middle of Right Square              true   false  true   true   false  false  true   false  false  false
Square (right)                            Square (left)                             false  false  false  false  false  false  true   false  true   false
Square (right)                            Square (right)                            true   true   true   false  false  true   true   false  false  true
Square (right)                            Square overlapping left and right square  false  true   false  false  false  false  true   false  false  true
Square overlapping left and right square  Empty GeometryCollection                  false  false  false  false  false  false  false  false  false  false
Square overlapping left and right square  Empty LineString                          false  false  false  false  false  false  false  false  false  false
Square overlapping left and right square  Empty Point                               false  false  false  false  false  false  false  false  false  false
Square overlapping left and right square  Faraway point                             false  false  false  false  false  false  false  false  false  false
Square overlapping left and right square  Line going through left and right square  false  false  false  false  true   false  true   false  false  false
Square overlapping left and right square  NULL                                      NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL   NULL
Square overlapping left and right square  Nested Geometry Collection                true   false  false  false  false  false  true   false  true   false
Square overlapping left and right square  Point middle of Left Square               false  false  false  false  false  false  false  false  false  false
Square overlapping left and right square  Point middle of Right Square              true   false  true   true   false  false  true   false  false  false
Square overlapping left and right square  Square (left)                             false  false  false  false  false  false  true   true   false  false
Square overlapping left and right square  Square (right)                            true   false  true   false  false  false  true   false  false  false
Square overlapping left and right square  Square overlapping left and right square  true   true   true   false  false  true   true   false  false  true

# DWithin
query TTBB
SELECT
  a.dsc,
  b.dsc,
  ST_DWithin(a.geom, b.geom, 1),
  ST_DFullyWithin(a.geom, b.geom, 1)
FROM geom_operators_test a
JOIN geom_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  false  false
Empty GeometryCollection                  Empty LineString                          false  false
Empty GeometryCollection                  Empty Point                               false  false
Empty GeometryCollection                  Faraway point                             false  false
Empty GeometryCollection                  Line going through left and right square  false  false
Empty GeometryCollection                  NULL                                      NULL   NULL
Empty GeometryCollection                  Nested Geometry Collection                false  false
Empty GeometryCollection                  Point middle of Left Square               false  false
Empty GeometryCollection                  Point middle of Right Square              false  false
Empty GeometryCollection                  Square (left)                             false  false
Empty GeometryCollection                  Square (right)                            false  false
Empty GeometryCollection                  Square overlapping left and right square  false  false
Empty LineString                          Empty GeometryCollection                  false  false
Empty LineString                          Empty LineString                          false  false
Empty LineString                          Empty Point                               false  false
Empty LineString                          Faraway point                             false  false
Empty LineString                          Line going through left and right square  false  false
Empty LineString                          NULL                                      NULL   NULL
Empty LineString                          Nested Geometry Collection                false  false
Empty LineString                          Point middle of Left Square               false  false
Empty LineString                          Point middle of Right Square              false  false
Empty LineString                          Square (left)                             false  false
Empty LineString                          Square (right)                            false  false
Empty LineString                          Square overlapping left and right square  false  false
Empty Point                               Empty GeometryCollection                  false  false
Empty Point                               Empty LineString                          false  false
Empty Point                               Empty Point                               false  false
Empty Point                               Faraway point                             false  false
Empty Point                               Line going through left and right square  false  false
Empty Point                               NULL                                      NULL   NULL
Empty Point                               Nested Geometry Collection                false  false
Empty Point                               Point middle of Left Square               false  false
Empty Point                               Point middle of Right Square              false  false
Empty Point                               Square (left)                             false  false
Empty Point                               Square (right)                            false  false
Empty Point                               Square overlapping left and right square  false  false
Faraway point                             Empty GeometryCollection                  false  false
Faraway point                             Empty LineString                          false  false
Faraway point                             Empty Point                               false  false
Faraway point                             Faraway point                             true   true
Faraway point                             Line going through left and right square  false  false
Faraway point                             NULL                                      NULL   NULL
Faraway point                             Nested Geometry Collection                false  false
Faraway point                             Point middle of Left Square               false  false
Faraway point                             Point middle of Right Square              false  false
Faraway point                             Square (left)                             false  false
Faraway point                             Square (right)                            false  false
Faraway point                             Square overlapping left and right square  false  false
Line going through left and right square  Empty GeometryCollection                  false  false
Line going through left and right square  Empty LineString                          false  false
Line going through left and right square  Empty Point                               false  false
Line going through left and right square  Faraway point                             false  false
Line going through left and right square  Line going through left and right square  true   true
Line going through left and right square  NULL                                      NULL   NULL
Line going through left and right square  Nested Geometry Collection                true   true
Line going through left and right square  Point middle of Left Square               true   true
Line going through left and right square  Point middle of Right Square              true   true
Line going through left and right square  Square (left)                             true   false
Line going through left and right square  Square (right)                            true   false
Line going through left and right square  Square overlapping left and right square  true   false
NULL                                      Empty GeometryCollection                  NULL   NULL
NULL                                      Empty LineString                          NULL   NULL
NULL                                      Empty Point                               NULL   NULL
NULL                                      Faraway point                             NULL   NULL
NULL                                      Line going through left and right square  NULL   NULL
NULL                                      NULL                                      NULL   NULL
NULL                                      Nested Geometry Collection                NULL   NULL
NULL                                      Point middle of Left Square               NULL   NULL
NULL                                      Point middle of Right Square              NULL   NULL
NULL                                      Square (left)                             NULL   NULL
NULL                                      Square (right)                            NULL   NULL
NULL                                      Square overlapping left and right square  NULL   NULL
Nested Geometry Collection                Empty GeometryCollection                  false  false
Nested Geometry Collection                Empty LineString                          false  false
Nested Geometry Collection                Empty Point                               false  false
Nested Geometry Collection                Faraway point                             false  false
Nested Geometry Collection                Line going through left and right square  true   true
Nested Geometry Collection                NULL                                      NULL   NULL
Nested Geometry Collection                Nested Geometry Collection                true   true
Nested Geometry Collection                Point middle of Left Square               true   true
Nested Geometry Collection                Point middle of Right Square              true   true
Nested Geometry Collection                Square (left)                             true   false
Nested Geometry Collection                Square (right)                            true   false
Nested Geometry Collection                Square overlapping left and right square  true   false
Point middle of Left Square               Empty GeometryCollection                  false  false
Point middle of Left Square               Empty LineString                          false  false
Point middle of Left Square               Empty Point                               false  false
Point middle of Left Square               Faraway point                             false  false
Point middle of Left Square               Line going through left and right square  true   true
Point middle of Left Square               NULL                                      NULL   NULL
Point middle of Left Square               Nested Geometry Collection                true   true
Point middle of Left Square               Point middle of Left Square               true   true
Point middle of Left Square               Point middle of Right Square              true   true
Point middle of Left Square               Square (left)                             true   true
Point middle of Left Square               Square (right)                            true   false
Point middle of Left Square               Square overlapping left and right square  true   false
Point middle of Right Square              Empty GeometryCollection                  false  false
Point middle of Right Square              Empty LineString                          false  false
Point middle of Right Square              Empty Point                               false  false
Point middle of Right Square              Faraway point                             false  false
Point middle of Right Square              Line going through left and right square  true   true
Point middle of Right Square              NULL                                      NULL   NULL
Point middle of Right Square              Nested Geometry Collection                true   true
Point middle of Right Square              Point middle of Left Square               true   true
Point middle of Right Square              Point middle of Right Square              true   true
Point middle of Right Square              Square (left)                             true   false
Point middle of Right Square              Square (right)                            true   true
Point middle of Right Square              Square overlapping left and right square  true   true
Square (left)                             Empty GeometryCollection                  false  false
Square (left)                             Empty LineString                          false  false
Square (left)                             Empty Point                               false  false
Square (left)                             Faraway point                             false  false
Square (left)                             Line going through left and right square  true   false
Square (left)                             NULL                                      NULL   NULL
Square (left)                             Nested Geometry Collection                true   false
Square (left)                             Point middle of Left Square               true   true
Square (left)                             Point middle of Right Square              true   false
Square (left)                             Square (left)                             true   false
Square (left)                             Square (right)                            true   false
Square (left)                             Square overlapping left and right square  true   false
Square (right)                            Empty GeometryCollection                  false  false
Square (right)                            Empty LineString                          false  false
Square (right)                            Empty Point                               false  false
Square (right)                            Faraway point                             false  false
Square (right)                            Line going through left and right square  true   false
Square (right)                            NULL                                      NULL   NULL
Square (right)                            Nested Geometry Collection                true   false
Square (right)                            Point middle of Left Square               true   false
Square (right)                            Point middle of Right Square              true   true
Square (right)                            Square (left)                             true   false
Square (right)                            Square (right)                            true   false
Square (right)                            Square overlapping left and right square  true   false
Square overlapping left and right square  Empty GeometryCollection                  false  false
Square overlapping left and right square  Empty LineString                          false  false
Square overlapping left and right square  Empty Point                               false  false
Square overlapping left and right square  Faraway point                             false  false
Square overlapping left and right square  Line going through left and right square  true   false
Square overlapping left and right square  NULL                                      NULL   NULL
Square overlapping left and right square  Nested Geometry Collection                true   false
Square overlapping left and right square  Point middle of Left Square               true   false
Square overlapping left and right square  Point middle of Right Square              true   true
Square overlapping left and right square  Square (left)                             true   false
Square overlapping left and right square  Square (right)                            true   false
Square overlapping left and right square  Square overlapping left and right square  true   false

query TTBB
SELECT
  a.dsc,
  b.dsc,
  _ST_DWithin(a.geom, b.geom, 1),
  _ST_DFullyWithin(a.geom, b.geom, 1)
FROM geom_operators_test a
JOIN geom_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  false  false
Empty GeometryCollection                  Empty LineString                          false  false
Empty GeometryCollection                  Empty Point                               false  false
Empty GeometryCollection                  Faraway point                             false  false
Empty GeometryCollection                  Line going through left and right square  false  false
Empty GeometryCollection                  NULL                                      NULL   NULL
Empty GeometryCollection                  Nested Geometry Collection                false  false
Empty GeometryCollection                  Point middle of Left Square               false  false
Empty GeometryCollection                  Point middle of Right Square              false  false
Empty GeometryCollection                  Square (left)                             false  false
Empty GeometryCollection                  Square (right)                            false  false
Empty GeometryCollection                  Square overlapping left and right square  false  false
Empty LineString                          Empty GeometryCollection                  false  false
Empty LineString                          Empty LineString                          false  false
Empty LineString                          Empty Point                               false  false
Empty LineString                          Faraway point                             false  false
Empty LineString                          Line going through left and right square  false  false
Empty LineString                          NULL                                      NULL   NULL
Empty LineString                          Nested Geometry Collection                false  false
Empty LineString                          Point middle of Left Square               false  false
Empty LineString                          Point middle of Right Square              false  false
Empty LineString                          Square (left)                             false  false
Empty LineString                          Square (right)                            false  false
Empty LineString                          Square overlapping left and right square  false  false
Empty Point                               Empty GeometryCollection                  false  false
Empty Point                               Empty LineString                          false  false
Empty Point                               Empty Point                               false  false
Empty Point                               Faraway point                             false  false
Empty Point                               Line going through left and right square  false  false
Empty Point                               NULL                                      NULL   NULL
Empty Point                               Nested Geometry Collection                false  false
Empty Point                               Point middle of Left Square               false  false
Empty Point                               Point middle of Right Square              false  false
Empty Point                               Square (left)                             false  false
Empty Point                               Square (right)                            false  false
Empty Point                               Square overlapping left and right square  false  false
Faraway point                             Empty GeometryCollection                  false  false
Faraway point                             Empty LineString                          false  false
Faraway point                             Empty Point                               false  false
Faraway point                             Faraway point                             true   true
Faraway point                             Line going through left and right square  false  false
Faraway point                             NULL                                      NULL   NULL
Faraway point                             Nested Geometry Collection                false  false
Faraway point                             Point middle of Left Square               false  false
Faraway point                             Point middle of Right Square              false  false
Faraway point                             Square (left)                             false  false
Faraway point                             Square (right)                            false  false
Faraway point                             Square overlapping left and right square  false  false
Line going through left and right square  Empty GeometryCollection                  false  false
Line going through left and right square  Empty LineString                          false  false
Line going through left and right square  Empty Point                               false  false
Line going through left and right square  Faraway point                             false  false
Line going through left and right square  Line going through left and right square  true   true
Line going through left and right square  NULL                                      NULL   NULL
Line going through left and right square  Nested Geometry Collection                true   true
Line going through left and right square  Point middle of Left Square               true   true
Line going through left and right square  Point middle of Right Square              true   true
Line going through left and right square  Square (left)                             true   false
Line going through left and right square  Square (right)                            true   false
Line going through left and right square  Square overlapping left and right square  true   false
NULL                                      Empty GeometryCollection                  NULL   NULL
NULL                                      Empty LineString                          NULL   NULL
NULL                                      Empty Point                               NULL   NULL
NULL                                      Faraway point                             NULL   NULL
NULL                                      Line going through left and right square  NULL   NULL
NULL                                      NULL                                      NULL   NULL
NULL                                      Nested Geometry Collection                NULL   NULL
NULL                                      Point middle of Left Square               NULL   NULL
NULL                                      Point middle of Right Square              NULL   NULL
NULL                                      Square (left)                             NULL   NULL
NULL                                      Square (right)                            NULL   NULL
NULL                                      Square overlapping left and right square  NULL   NULL
Nested Geometry Collection                Empty GeometryCollection                  false  false
Nested Geometry Collection                Empty LineString                          false  false
Nested Geometry Collection                Empty Point                               false  false
Nested Geometry Collection                Faraway point                             false  false
Nested Geometry Collection                Line going through left and right square  true   true
Nested Geometry Collection                NULL                                      NULL   NULL
Nested Geometry Collection                Nested Geometry Collection                true   true
Nested Geometry Collection                Point middle of Left Square               true   true
Nested Geometry Collection                Point middle of Right Square              true   true
Nested Geometry Collection                Square (left)                             true   false
Nested Geometry Collection                Square (right)                            true   false
Nested Geometry Collection                Square overlapping left and right square  true   false
Point middle of Left Square               Empty GeometryCollection                  false  false
Point middle of Left Square               Empty LineString                          false  false
Point middle of Left Square               Empty Point                               false  false
Point middle of Left Square               Faraway point                             false  false
Point middle of Left Square               Line going through left and right square  true   true
Point middle of Left Square               NULL                                      NULL   NULL
Point middle of Left Square               Nested Geometry Collection                true   true
Point middle of Left Square               Point middle of Left Square               true   true
Point middle of Left Square               Point middle of Right Square              true   true
Point middle of Left Square               Square (left)                             true   true
Point middle of Left Square               Square (right)                            true   false
Point middle of Left Square               Square overlapping left and right square  true   false
Point middle of Right Square              Empty GeometryCollection                  false  false
Point middle of Right Square              Empty LineString                          false  false
Point middle of Right Square              Empty Point                               false  false
Point middle of Right Square              Faraway point                             false  false
Point middle of Right Square              Line going through left and right square  true   true
Point middle of Right Square              NULL                                      NULL   NULL
Point middle of Right Square              Nested Geometry Collection                true   true
Point middle of Right Square              Point middle of Left Square               true   true
Point middle of Right Square              Point middle of Right Square              true   true
Point middle of Right Square              Square (left)                             true   false
Point middle of Right Square              Square (right)                            true   true
Point middle of Right Square              Square overlapping left and right square  true   true
Square (left)                             Empty GeometryCollection                  false  false
Square (left)                             Empty LineString                          false  false
Square (left)                             Empty Point                               false  false
Square (left)                             Faraway point                             false  false
Square (left)                             Line going through left and right square  true   false
Square (left)                             NULL                                      NULL   NULL
Square (left)                             Nested Geometry Collection                true   false
Square (left)                             Point middle of Left Square               true   true
Square (left)                             Point middle of Right Square              true   false
Square (left)                             Square (left)                             true   false
Square (left)                             Square (right)                            true   false
Square (left)                             Square overlapping left and right square  true   false
Square (right)                            Empty GeometryCollection                  false  false
Square (right)                            Empty LineString                          false  false
Square (right)                            Empty Point                               false  false
Square (right)                            Faraway point                             false  false
Square (right)                            Line going through left and right square  true   false
Square (right)                            NULL                                      NULL   NULL
Square (right)                            Nested Geometry Collection                true   false
Square (right)                            Point middle of Left Square               true   false
Square (right)                            Point middle of Right Square              true   true
Square (right)                            Square (left)                             true   false
Square (right)                            Square (right)                            true   false
Square (right)                            Square overlapping left and right square  true   false
Square overlapping left and right square  Empty GeometryCollection                  false  false
Square overlapping left and right square  Empty LineString                          false  false
Square overlapping left and right square  Empty Point                               false  false
Square overlapping left and right square  Faraway point                             false  false
Square overlapping left and right square  Line going through left and right square  true   false
Square overlapping left and right square  NULL                                      NULL   NULL
Square overlapping left and right square  Nested Geometry Collection                true   false
Square overlapping left and right square  Point middle of Left Square               true   false
Square overlapping left and right square  Point middle of Right Square              true   true
Square overlapping left and right square  Square (left)                             true   false
Square overlapping left and right square  Square (right)                            true   false
Square overlapping left and right square  Square overlapping left and right square  true   false

# ST_Buffer
query TTTT
SELECT
  a.dsc,
  ST_AsEWKT(ST_Buffer(a.geom, 10), 5),
  ST_AsEWKT(ST_Buffer(a.geom, 10, 2), 5),
  ST_AsEWKT(ST_Buffer(a.geom, 10, 'quad_segs=4 endcap=flat'), 5)
FROM geom_operators_test a
ORDER BY a.dsc
----
Empty GeometryCollection                  POLYGON EMPTY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      POLYGON EMPTY                                                                                                                                                POLYGON EMPTY
Empty LineString                          POLYGON EMPTY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      POLYGON EMPTY                                                                                                                                                POLYGON EMPTY
Empty Point                               POLYGON EMPTY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      POLYGON EMPTY                                                                                                                                                POLYGON EMPTY
Faraway point                             POLYGON ((15 5, 14.80785 3.0491, 14.2388 1.17317, 13.3147 -0.5557, 12.07107 -2.07107, 10.5557 -3.3147, 8.82683 -4.2388, 6.9509 -4.80785, 5 -5, 3.0491 -4.80785, 1.17317 -4.2388, -0.5557 -3.3147, -2.07107 -2.07107, -3.3147 -0.5557, -4.2388 1.17317, -4.80785 3.0491, -5 5, -4.80785 6.9509, -4.2388 8.82683, -3.3147 10.5557, -2.07107 12.07107, -0.5557 13.3147, 1.17317 14.2388, 3.0491 14.80785, 5 15, 6.9509 14.80785, 8.82683 14.2388, 10.5557 13.3147, 12.07107 12.07107, 13.3147 10.5557, 14.2388 8.82683, 14.80785 6.9509, 15 5))                                       POLYGON ((15 5, 12.07107 -2.07107, 5 -5, -2.07107 -2.07107, -5 5, -2.07107 12.07107, 5 15, 12.07107 12.07107, 15 5))                                         POLYGON EMPTY
Line going through left and right square  POLYGON ((0.5 10.5, 2.4509 10.30785, 4.32683 9.7388, 6.0557 8.8147, 7.57107 7.57107, 8.8147 6.0557, 9.7388 4.32683, 10.30785 2.4509, 10.5 0.5, 10.30785 -1.4509, 9.7388 -3.32683, 8.8147 -5.0557, 7.57107 -6.57107, 6.0557 -7.8147, 4.32683 -8.7388, 2.4509 -9.30785, 0.5 -9.5, -0.5 -9.5, -2.4509 -9.30785, -4.32683 -8.7388, -6.0557 -7.8147, -7.57107 -6.57107, -8.8147 -5.0557, -9.7388 -3.32683, -10.30785 -1.4509, -10.5 0.5, -10.30785 2.4509, -9.7388 4.32683, -8.8147 6.0557, -7.57107 7.57107, -6.0557 8.8147, -4.32683 9.7388, -2.4509 10.30785, -0.5 10.5, 0.5 10.5))  POLYGON ((0.5 10.5, 7.57107 7.57107, 10.5 0.5, 7.57107 -6.57107, 0.5 -9.5, -0.5 -9.5, -7.57107 -6.57107, -10.5 0.5, -7.57107 7.57107, -0.5 10.5, 0.5 10.5))  POLYGON ((0.5 10.5, 0.5 -9.5, -0.5 -9.5, -0.5 10.5, 0.5 10.5))
NULL                                      NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               NULL                                                                                                                                                         NULL
Nested Geometry Collection                POLYGON ((10 0, 9.80785 -1.9509, 9.2388 -3.82683, 8.3147 -5.5557, 7.07107 -7.07107, 5.5557 -8.3147, 3.82683 -9.2388, 1.9509 -9.80785, 0 -10, -1.9509 -9.80785, -3.82683 -9.2388, -5.5557 -8.3147, -7.07107 -7.07107, -8.3147 -5.5557, -9.2388 -3.82683, -9.80785 -1.9509, -10 -0, -9.80785 1.9509, -9.2388 3.82683, -8.3147 5.5557, -7.07107 7.07107, -5.5557 8.3147, -3.82683 9.2388, -1.9509 9.80785, -0 10, 1.9509 9.80785, 3.82683 9.2388, 5.5557 8.3147, 7.07107 7.07107, 8.3147 5.5557, 9.2388 3.82683, 9.80785 1.9509, 10 0))                                               POLYGON ((10 0, 7.07107 -7.07107, 0 -10, -7.07107 -7.07107, -10 -0, -7.07107 7.07107, -0 10, 7.07107 7.07107, 10 0))                                         POLYGON EMPTY
Point middle of Left Square               POLYGON ((9.5 0.5, 9.30785 -1.4509, 8.7388 -3.32683, 7.8147 -5.0557, 6.57107 -6.57107, 5.0557 -7.8147, 3.32683 -8.7388, 1.4509 -9.30785, -0.5 -9.5, -2.4509 -9.30785, -4.32683 -8.7388, -6.0557 -7.8147, -7.57107 -6.57107, -8.8147 -5.0557, -9.7388 -3.32683, -10.30785 -1.4509, -10.5 0.5, -10.30785 2.4509, -9.7388 4.32683, -8.8147 6.0557, -7.57107 7.57107, -6.0557 8.8147, -4.32683 9.7388, -2.4509 10.30785, -0.5 10.5, 1.4509 10.30785, 3.32683 9.7388, 5.0557 8.8147, 6.57107 7.57107, 7.8147 6.0557, 8.7388 4.32683, 9.30785 2.4509, 9.5 0.5))                          POLYGON ((9.5 0.5, 6.57107 -6.57107, -0.5 -9.5, -7.57107 -6.57107, -10.5 0.5, -7.57107 7.57107, -0.5 10.5, 6.57107 7.57107, 9.5 0.5))                        POLYGON EMPTY
Point middle of Right Square              POLYGON ((10.5 0.5, 10.30785 -1.4509, 9.7388 -3.32683, 8.8147 -5.0557, 7.57107 -6.57107, 6.0557 -7.8147, 4.32683 -8.7388, 2.4509 -9.30785, 0.5 -9.5, -1.4509 -9.30785, -3.32683 -8.7388, -5.0557 -7.8147, -6.57107 -6.57107, -7.8147 -5.0557, -8.7388 -3.32683, -9.30785 -1.4509, -9.5 0.5, -9.30785 2.4509, -8.7388 4.32683, -7.8147 6.0557, -6.57107 7.57107, -5.0557 8.8147, -3.32683 9.7388, -1.4509 10.30785, 0.5 10.5, 2.4509 10.30785, 4.32683 9.7388, 6.0557 8.8147, 7.57107 7.57107, 8.8147 6.0557, 9.7388 4.32683, 10.30785 2.4509, 10.5 0.5))                           POLYGON ((10.5 0.5, 7.57107 -6.57107, 0.5 -9.5, -6.57107 -6.57107, -9.5 0.5, -6.57107 7.57107, 0.5 10.5, 7.57107 7.57107, 10.5 0.5))                         POLYGON EMPTY
Square (left)                             POLYGON ((-11 0, -11 1, -10.80785 2.9509, -10.2388 4.82683, -9.3147 6.5557, -8.07107 8.07107, -6.5557 9.3147, -4.82683 10.2388, -2.9509 10.80785, -1 11, 0 11, 1.9509 10.80785, 3.82683 10.2388, 5.5557 9.3147, 7.07107 8.07107, 8.3147 6.5557, 9.2388 4.82683, 9.80785 2.9509, 10 1, 10 0, 9.80785 -1.9509, 9.2388 -3.82683, 8.3147 -5.5557, 7.07107 -7.07107, 5.5557 -8.3147, 3.82683 -9.2388, 1.9509 -9.80785, 0 -10, -1 -10, -2.9509 -9.80785, -4.82683 -9.2388, -6.5557 -8.3147, -8.07107 -7.07107, -9.3147 -5.5557, -10.2388 -3.82683, -10.80785 -1.9509, -11 0))            POLYGON ((-11 0, -11 1, -8.07107 8.07107, -1 11, 0 11, 7.07107 8.07107, 10 1, 10 0, 7.07107 -7.07107, 0 -10, -1 -10, -8.07107 -7.07107, -11 0))              POLYGON ((-11 0, -11 1, -10.2388 4.82683, -8.07107 8.07107, -4.82683 10.2388, -1 11, 0 11, 3.82683 10.2388, 7.07107 8.07107, 9.2388 4.82683, 10 1, 10 0, 9.2388 -3.82683, 7.07107 -7.07107, 3.82683 -9.2388, 0 -10, -1 -10, -4.82683 -9.2388, -8.07107 -7.07107, -10.2388 -3.82683, -11 0))
Square (right)                            POLYGON ((-10 0, -10 1, -9.80785 2.9509, -9.2388 4.82683, -8.3147 6.5557, -7.07107 8.07107, -5.5557 9.3147, -3.82683 10.2388, -1.9509 10.80785, 0 11, 1 11, 2.9509 10.80785, 4.82683 10.2388, 6.5557 9.3147, 8.07107 8.07107, 9.3147 6.5557, 10.2388 4.82683, 10.80785 2.9509, 11 1, 11 0, 10.80785 -1.9509, 10.2388 -3.82683, 9.3147 -5.5557, 8.07107 -7.07107, 6.5557 -8.3147, 4.82683 -9.2388, 2.9509 -9.80785, 1 -10, 0 -10, -1.9509 -9.80785, -3.82683 -9.2388, -5.5557 -8.3147, -7.07107 -7.07107, -8.3147 -5.5557, -9.2388 -3.82683, -9.80785 -1.9509, -10 0))              POLYGON ((-10 0, -10 1, -7.07107 8.07107, 0 11, 1 11, 8.07107 8.07107, 11 1, 11 0, 8.07107 -7.07107, 1 -10, 0 -10, -7.07107 -7.07107, -10 0))                POLYGON ((-10 0, -10 1, -9.2388 4.82683, -7.07107 8.07107, -3.82683 10.2388, 0 11, 1 11, 4.82683 10.2388, 8.07107 8.07107, 10.2388 4.82683, 11 1, 11 0, 10.2388 -3.82683, 8.07107 -7.07107, 4.82683 -9.2388, 1 -10, 0 -10, -3.82683 -9.2388, -7.07107 -7.07107, -9.2388 -3.82683, -10 0))
Square overlapping left and right square  POLYGON ((-10.1 0, -10.1 1, -9.90785 2.9509, -9.3388 4.82683, -8.4147 6.5557, -7.17107 8.07107, -5.6557 9.3147, -3.92683 10.2388, -2.0509 10.80785, -0.1 11, 1 11, 2.9509 10.80785, 4.82683 10.2388, 6.5557 9.3147, 8.07107 8.07107, 9.3147 6.5557, 10.2388 4.82683, 10.80785 2.9509, 11 1, 11 0, 10.80785 -1.9509, 10.2388 -3.82683, 9.3147 -5.5557, 8.07107 -7.07107, 6.5557 -8.3147, 4.82683 -9.2388, 2.9509 -9.80785, 1 -10, -0.1 -10, -2.0509 -9.80785, -3.92683 -9.2388, -5.6557 -8.3147, -7.17107 -7.07107, -8.4147 -5.5557, -9.3388 -3.82683, -9.90785 -1.9509, -10.1 0))  POLYGON ((-10.1 0, -10.1 1, -7.17107 8.07107, -0.1 11, 1 11, 8.07107 8.07107, 11 1, 11 0, 8.07107 -7.07107, 1 -10, -0.1 -10, -7.17107 -7.07107, -10.1 0))    POLYGON ((-10.1 0, -10.1 1, -9.3388 4.82683, -7.17107 8.07107, -3.92683 10.2388, -0.1 11, 1 11, 4.82683 10.2388, 8.07107 8.07107, 10.2388 4.82683, 11 1, 11 0, 10.2388 -3.82683, 8.07107 -7.07107, 4.82683 -9.2388, 1 -10, -0.1 -10, -3.92683 -9.2388, -7.17107 -7.07107, -9.3388 -3.82683, -10.1 0))

# Test raw string with ST_Buffer
query I
SELECT ST_NPoints(ST_Buffer('SRID=4326;POINT(0 0)', 10.0))
----
33

# DE-9IM relations
query B
SELECT
  ST_RelateMatch(m, pattern)
FROM ( VALUES
  ('101202FFF', 'TTTTTTFFF'),
  ('101202FTF', 'TTTTTTFFF')
) tbl(m, pattern)
----
true
false

query TTTB
SELECT
  a.dsc,
  b.dsc,
  ST_Relate(a.geom, b.geom),
  ST_Relate(a.geom, b.geom, 'T**FF*FF*')
FROM geom_operators_test a
JOIN geom_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  FFFFFFFF2  false
Empty GeometryCollection                  Empty LineString                          FFFFFFFF2  false
Empty GeometryCollection                  Empty Point                               FFFFFFFF2  false
Empty GeometryCollection                  Faraway point                             FFFFFF0F2  false
Empty GeometryCollection                  Line going through left and right square  FFFFFF102  false
Empty GeometryCollection                  NULL                                      NULL       NULL
Empty GeometryCollection                  Nested Geometry Collection                FFFFFF0F2  false
Empty GeometryCollection                  Point middle of Left Square               FFFFFF0F2  false
Empty GeometryCollection                  Point middle of Right Square              FFFFFF0F2  false
Empty GeometryCollection                  Square (left)                             FFFFFF212  false
Empty GeometryCollection                  Square (right)                            FFFFFF212  false
Empty GeometryCollection                  Square overlapping left and right square  FFFFFF212  false
Empty LineString                          Empty GeometryCollection                  FFFFFFFF2  false
Empty LineString                          Empty LineString                          FFFFFFFF2  false
Empty LineString                          Empty Point                               FFFFFFFF2  false
Empty LineString                          Faraway point                             FFFFFF0F2  false
Empty LineString                          Line going through left and right square  FFFFFF102  false
Empty LineString                          NULL                                      NULL       NULL
Empty LineString                          Nested Geometry Collection                FFFFFF0F2  false
Empty LineString                          Point middle of Left Square               FFFFFF0F2  false
Empty LineString                          Point middle of Right Square              FFFFFF0F2  false
Empty LineString                          Square (left)                             FFFFFF212  false
Empty LineString                          Square (right)                            FFFFFF212  false
Empty LineString                          Square overlapping left and right square  FFFFFF212  false
Empty Point                               Empty GeometryCollection                  FFFFFFFF2  false
Empty Point                               Empty LineString                          FFFFFFFF2  false
Empty Point                               Empty Point                               FFFFFFFF2  false
Empty Point                               Faraway point                             FFFFFF0F2  false
Empty Point                               Line going through left and right square  FFFFFF102  false
Empty Point                               NULL                                      NULL       NULL
Empty Point                               Nested Geometry Collection                FFFFFF0F2  false
Empty Point                               Point middle of Left Square               FFFFFF0F2  false
Empty Point                               Point middle of Right Square              FFFFFF0F2  false
Empty Point                               Square (left)                             FFFFFF212  false
Empty Point                               Square (right)                            FFFFFF212  false
Empty Point                               Square overlapping left and right square  FFFFFF212  false
Faraway point                             Empty GeometryCollection                  FF0FFFFF2  false
Faraway point                             Empty LineString                          FF0FFFFF2  false
Faraway point                             Empty Point                               FF0FFFFF2  false
Faraway point                             Faraway point                             0FFFFFFF2  true
Faraway point                             Line going through left and right square  FF0FFF102  false
Faraway point                             NULL                                      NULL       NULL
Faraway point                             Nested Geometry Collection                FF0FFF0F2  false
Faraway point                             Point middle of Left Square               FF0FFF0F2  false
Faraway point                             Point middle of Right Square              FF0FFF0F2  false
Faraway point                             Square (left)                             FF0FFF212  false
Faraway point                             Square (right)                            FF0FFF212  false
Faraway point                             Square overlapping left and right square  FF0FFF212  false
Line going through left and right square  Empty GeometryCollection                  FF1FF0FF2  false
Line going through left and right square  Empty LineString                          FF1FF0FF2  false
Line going through left and right square  Empty Point                               FF1FF0FF2  false
Line going through left and right square  Faraway point                             FF1FF00F2  false
Line going through left and right square  Line going through left and right square  1FFF0FFF2  false
Line going through left and right square  NULL                                      NULL       NULL
Line going through left and right square  Nested Geometry Collection                FF1FF00F2  false
Line going through left and right square  Point middle of Left Square               FF10F0FF2  false
Line going through left and right square  Point middle of Right Square              FF10F0FF2  false
Line going through left and right square  Square (left)                             1010F0212  false
Line going through left and right square  Square (right)                            1010F0212  false
Line going through left and right square  Square overlapping left and right square  1010F0212  false
NULL                                      Empty GeometryCollection                  NULL       NULL
NULL                                      Empty LineString                          NULL       NULL
NULL                                      Empty Point                               NULL       NULL
NULL                                      Faraway point                             NULL       NULL
NULL                                      Line going through left and right square  NULL       NULL
NULL                                      NULL                                      NULL       NULL
NULL                                      Nested Geometry Collection                NULL       NULL
NULL                                      Point middle of Left Square               NULL       NULL
NULL                                      Point middle of Right Square              NULL       NULL
NULL                                      Square (left)                             NULL       NULL
NULL                                      Square (right)                            NULL       NULL
NULL                                      Square overlapping left and right square  NULL       NULL
Nested Geometry Collection                Empty GeometryCollection                  FF0FFFFF2  false
Nested Geometry Collection                Empty LineString                          FF0FFFFF2  false
Nested Geometry Collection                Empty Point                               FF0FFFFF2  false
Nested Geometry Collection                Faraway point                             FF0FFF0F2  false
Nested Geometry Collection                Line going through left and right square  FF0FFF102  false
Nested Geometry Collection                NULL                                      NULL       NULL
Nested Geometry Collection                Nested Geometry Collection                0FFFFFFF2  true
Nested Geometry Collection                Point middle of Left Square               FF0FFF0F2  false
Nested Geometry Collection                Point middle of Right Square              FF0FFF0F2  false
Nested Geometry Collection                Square (left)                             F0FFFF212  false
Nested Geometry Collection                Square (right)                            F0FFFF212  false
Nested Geometry Collection                Square overlapping left and right square  F0FFFF212  false
Point middle of Left Square               Empty GeometryCollection                  FF0FFFFF2  false
Point middle of Left Square               Empty LineString                          FF0FFFFF2  false
Point middle of Left Square               Empty Point                               FF0FFFFF2  false
Point middle of Left Square               Faraway point                             FF0FFF0F2  false
Point middle of Left Square               Line going through left and right square  F0FFFF102  false
Point middle of Left Square               NULL                                      NULL       NULL
Point middle of Left Square               Nested Geometry Collection                FF0FFF0F2  false
Point middle of Left Square               Point middle of Left Square               0FFFFFFF2  true
Point middle of Left Square               Point middle of Right Square              FF0FFF0F2  false
Point middle of Left Square               Square (left)                             0FFFFF212  false
Point middle of Left Square               Square (right)                            FF0FFF212  false
Point middle of Left Square               Square overlapping left and right square  FF0FFF212  false
Point middle of Right Square              Empty GeometryCollection                  FF0FFFFF2  false
Point middle of Right Square              Empty LineString                          FF0FFFFF2  false
Point middle of Right Square              Empty Point                               FF0FFFFF2  false
Point middle of Right Square              Faraway point                             FF0FFF0F2  false
Point middle of Right Square              Line going through left and right square  F0FFFF102  false
Point middle of Right Square              NULL                                      NULL       NULL
Point middle of Right Square              Nested Geometry Collection                FF0FFF0F2  false
Point middle of Right Square              Point middle of Left Square               FF0FFF0F2  false
Point middle of Right Square              Point middle of Right Square              0FFFFFFF2  true
Point middle of Right Square              Square (left)                             FF0FFF212  false
Point middle of Right Square              Square (right)                            0FFFFF212  false
Point middle of Right Square              Square overlapping left and right square  0FFFFF212  false
Square (left)                             Empty GeometryCollection                  FF2FF1FF2  false
Square (left)                             Empty LineString                          FF2FF1FF2  false
Square (left)                             Empty Point                               FF2FF1FF2  false
Square (left)                             Faraway point                             FF2FF10F2  false
Square (left)                             Line going through left and right square  1020F1102  false
Square (left)                             NULL                                      NULL       NULL
Square (left)                             Nested Geometry Collection                FF20F1FF2  false
Square (left)                             Point middle of Left Square               0F2FF1FF2  true
Square (left)                             Point middle of Right Square              FF2FF10F2  false
Square (left)                             Square (left)                             2FFF1FFF2  false
Square (left)                             Square (right)                            FF2F11212  false
Square (left)                             Square overlapping left and right square  212111212  false
Square (right)                            Empty GeometryCollection                  FF2FF1FF2  false
Square (right)                            Empty LineString                          FF2FF1FF2  false
Square (right)                            Empty Point                               FF2FF1FF2  false
Square (right)                            Faraway point                             FF2FF10F2  false
Square (right)                            Line going through left and right square  1020F1102  false
Square (right)                            NULL                                      NULL       NULL
Square (right)                            Nested Geometry Collection                FF20F1FF2  false
Square (right)                            Point middle of Left Square               FF2FF10F2  false
Square (right)                            Point middle of Right Square              0F2FF1FF2  true
Square (right)                            Square (left)                             FF2F11212  false
Square (right)                            Square (right)                            2FFF1FFF2  false
Square (right)                            Square overlapping left and right square  2FF11F212  false
Square overlapping left and right square  Empty GeometryCollection                  FF2FF1FF2  false
Square overlapping left and right square  Empty LineString                          FF2FF1FF2  false
Square overlapping left and right square  Empty Point                               FF2FF1FF2  false
Square overlapping left and right square  Faraway point                             FF2FF10F2  false
Square overlapping left and right square  Line going through left and right square  1020F1102  false
Square overlapping left and right square  NULL                                      NULL       NULL
Square overlapping left and right square  Nested Geometry Collection                FF20F1FF2  false
Square overlapping left and right square  Point middle of Left Square               FF2FF10F2  false
Square overlapping left and right square  Point middle of Right Square              0F2FF1FF2  true
Square overlapping left and right square  Square (left)                             212111212  false
Square overlapping left and right square  Square (right)                            212F11FF2  false
Square overlapping left and right square  Square overlapping left and right square  2FFF1FFF2  false

# ST_Envelope
query TT
SELECT
  a.dsc,
  ST_AsEWKT(ST_Envelope(a.geom))
FROM geom_operators_test a
ORDER BY a.dsc
----
Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY
Empty LineString                          LINESTRING EMPTY
Empty Point                               POINT EMPTY
Faraway point                             POINT (5 5)
Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)
NULL                                      NULL
Nested Geometry Collection                POINT (0 0)
Point middle of Left Square               POINT (-0.5 0.5)
Point middle of Right Square              POINT (0.5 0.5)
Square (left)                             POLYGON ((-1 0, -1 1, 0 1, 0 0, -1 0))
Square (right)                            POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0))
Square overlapping left and right square  POLYGON ((-0.1 0, -0.1 1, 1 1, 1 0, -0.1 0))

# basic metadata
query TTTIII
SELECT
  a.dsc,
  GeometryType(a.geom),
  ST_GeometryType(a.geom),
  ST_NDims(a.geom),
  ST_NPoints(a.geom),
  ST_NumGeometries(a.geom)
FROM geom_operators_test a
ORDER BY a.dsc
----
Empty GeometryCollection                  GeometryCollection  ST_GeometryCollection  0     0     0
Empty LineString                          LineString          ST_LineString          2     0     0
Empty Point                               Point               ST_Point               2     0     0
Faraway point                             Point               ST_Point               2     1     1
Line going through left and right square  LineString          ST_LineString          2     2     1
NULL                                      NULL                NULL                   NULL  NULL  NULL
Nested Geometry Collection                GeometryCollection  ST_GeometryCollection  2     1     1
Point middle of Left Square               Point               ST_Point               2     1     1
Point middle of Right Square              Point               ST_Point               2     1     1
Square (left)                             Polygon             ST_Polygon             2     5     1
Square (right)                            Polygon             ST_Polygon             2     5     1
Square overlapping left and right square  Polygon             ST_Polygon             2     5     1

query TTTT
SELECT
  a.dsc,
  ST_AsEWKT(ST_GeometryN(a.geom, 0)),
  ST_AsEWKT(ST_GeometryN(a.geom, 1)),
  ST_AsEWKT(ST_GeometryN(a.geom, 2))
FROM geom_operators_test a
ORDER BY a.dsc
----
Empty GeometryCollection                  NULL  NULL                                          NULL
Empty LineString                          NULL  LINESTRING EMPTY                              NULL
Empty Point                               NULL  POINT EMPTY                                   NULL
Faraway point                             NULL  POINT (5 5)                                   NULL
Line going through left and right square  NULL  LINESTRING (-0.5 0.5, 0.5 0.5)                NULL
NULL                                      NULL  NULL                                          NULL
Nested Geometry Collection                NULL  GEOMETRYCOLLECTION (POINT (0 0))              NULL
Point middle of Left Square               NULL  POINT (-0.5 0.5)                              NULL
Point middle of Right Square              NULL  POINT (0.5 0.5)                               NULL
Square (left)                             NULL  POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0))        NULL
Square (right)                            NULL  POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))           NULL
Square overlapping left and right square  NULL  POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0))  NULL

# Point specific operations
query RR
SELECT
  ST_X(a.geom),
  ST_Y(a.geom)
FROM (VALUES
  ('POINT(1.0 2.0)'::geometry),
  ('POINT(33.0 66.0)'::geometry),
  ('POINT EMPTY'::geometry)
) a(geom)
----
1     2
33    66
NULL  NULL

statement error argument to ST_X\(\) must have shape POINT
SELECT ST_X('LINESTRING(0.0 0.0, 1.0 1.0)')

statement error argument to ST_Y\(\) must have shape POINT
SELECT ST_Y('LINESTRING(0.0 0.0, 1.0 1.0)')

# LineString specific operations
query TTITTTTT
SELECT
  ST_AsEWKT(ST_StartPoint(a.geom)),
  ST_AsEWKT(ST_EndPoint(a.geom)),
  ST_NumPoints(a.geom),
  ST_AsEWKT(ST_PointN(a.geom, 0)),
  ST_AsEWKT(ST_PointN(a.geom, 1)),
  ST_AsEWKT(ST_PointN(a.geom, 2)),
  ST_AsEWKT(ST_PointN(a.geom, 3)),
  ST_AsEWKT(ST_PointN(a.geom, 4))
FROM (VALUES
  ('LINESTRING EMPTY'::geometry),
  ('LINESTRING (0.0 0.0, 1.0 1.0, 2.0 2.0)'::geometry),
  ('SRID=4326;LINESTRING (0.0 0.0, 1.0 1.0, 2.0 2.0)'::geometry),
  ('MULTILINESTRING ((0.0 0.0, 1.0 1.0, 2.0 2.0), (3.0 3.0, 4.0 4.0))'::geometry)
) a(geom)
----
NULL                   NULL                   0     NULL  NULL                   NULL                   NULL                   NULL
POINT (0 0)            POINT (2 2)            3     NULL  POINT (0 0)            POINT (1 1)            POINT (2 2)            NULL
SRID=4326;POINT (0 0)  SRID=4326;POINT (2 2)  3     NULL  SRID=4326;POINT (0 0)  SRID=4326;POINT (1 1)  SRID=4326;POINT (2 2)  NULL
NULL                   NULL                   NULL  NULL  NULL                   NULL                   NULL                   NULL

# Polygon specific operations
query IIITTTT
SELECT
  ST_NRings(a.geom),
  ST_NumInteriorRing(a.geom),
  ST_NumInteriorRings(a.geom),
  ST_AsEWKT(ST_ExteriorRing(a.geom)),
  ST_AsEWKT(ST_InteriorRingN(a.geom, 0)),
  ST_AsEWKT(ST_InteriorRingN(a.geom, 1)),
  ST_AsEWKT(ST_InteriorRingN(a.geom, 2))
FROM (VALUES
  ('POLYGON EMPTY'::geometry),
  ('POLYGON((0 0,1 0, 1 1, 0 0))'::geometry),
  ('POLYGON((0 0,1 0, 1 1, 0 0),(0.1 0.1,0.9 0.1, 0.9 0.9, 0.1 0.1))'::geometry),
  ('SRID=4326;POLYGON((0 0,1 0, 1 1, 0 0),(0.1 0.1,0.9 0.1, 0.9 0.9, 0.1 0.1))'::geometry),
  ('LINESTRING EMPTY'::geometry)
) a(geom)
----
0  0     0     LINESTRING EMPTY                           NULL  NULL                                                       NULL
1  0     0     LINESTRING (0 0, 1 0, 1 1, 0 0)            NULL  NULL                                                       NULL
2  1     1     LINESTRING (0 0, 1 0, 1 1, 0 0)            NULL  LINESTRING (0.1 0.1, 0.9 0.1, 0.9 0.9, 0.1 0.1)            NULL
2  1     1     SRID=4326;LINESTRING (0 0, 1 0, 1 1, 0 0)  NULL  SRID=4326;LINESTRING (0.1 0.1, 0.9 0.1, 0.9 0.9, 0.1 0.1)  NULL
0  NULL  NULL  NULL                                       NULL  NULL                                                       NULL

statement error argument must be LINESTRING geometries
SELECT ST_MakePolygon('MULTIPOINT(0 0, 1 1)')

statement error unknown signature: st_makepolygon\(string\)
SELECT ST_MakePolygon('abc')

statement error argument must be LINESTRING geometries
SELECT ST_MakePolygon(
    ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 80)'),
    ARRAY[
      ST_GeomFromText('MULTIPOINT(50 70, 70 70, 70 50, 50 50, 50 70)')
    ]);

statement error argument must be LINESTRING geometries
SELECT ST_MakePolygon(
    ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 80)'),
    ARRAY[
      'MULTIPOINT(50 70, 70 70, 70 50, 50 50, 50 70)'
    ]);

statement error argument must be LINESTRING geometries
SELECT ST_MakePolygon(
    ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 80)'),
    ARRAY['abc']);

# SRID set on shell but not interior rings
statement error mixed SRIDs are not allowed
SELECT ST_MakePolygon(
    ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 80)', 4326),
    ARRAY[
      ST_GeomFromText('LINESTRING(50 70, 70 70, 70 50, 50 50, 50 70)')
    ]);

# SRIDs on shell and interior ring are unmatched
statement error mixed SRIDs are not allowed
SELECT ST_MakePolygon(
    ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 80)', 4326),
    ARRAY[
      ST_GeomFromText('LINESTRING(50 70, 70 70, 70 50, 50 50, 50 70)', 3857)
    ]);

# SRIDs on interior rings are unmatched
statement error mixed SRIDs are not allowed
SELECT ST_MakePolygon(
    ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 80)', 4326),
    ARRAY[
      ST_GeomFromText('LINESTRING(50 70, 70 70, 70 50, 50 50, 50 70)', 4326),
      ST_GeomFromText('LINESTRING(60 60, 75 60, 75 45, 60 45, 60 60)', 3857)
    ]);

statement error Polygon LinearRing at position 1 is not closed
SELECT ST_MakePolygon(ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 70)'));

statement error Polygon LinearRing must have at least 4 points, found 3 at position 1
SELECT ST_MakePolygon(ST_GeomFromText('LINESTRING(40 80, 80 80, 40 80)'));

statement error Polygon LinearRing at position 2 is not closed
SELECT ST_MakePolygon(
    ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 80)'),
    ARRAY[
      ST_GeomFromText('LINESTRING(50 70, 70 70, 70 50, 50 50, 50 60)')
    ]);

statement error Polygon LinearRing must have at least 4 points, found 3 at position 2
SELECT ST_MakePolygon(
    ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 80)'),
    ARRAY[
      ST_GeomFromText('LINESTRING(50 70, 70 70, 50 70)')
    ]);

query T
SELECT ST_AsEWKT(ST_MakePolygon( ST_GeomFromText('LINESTRING(75 29,77 29,77 29, 75 29)')));
----
POLYGON ((75 29, 77 29, 77 29, 75 29))

query T
SELECT ST_AsEWKT(ST_MakePolygon( ST_GeomFromText('LINESTRING(75 29,77 29,77 29, 75 29)', 4326)));
----
SRID=4326;POLYGON ((75 29, 77 29, 77 29, 75 29))

query T
SELECT ST_AsEWKT(ST_MakePolygon(
      ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 80)'),
      ARRAY[
        ST_GeomFromText('LINESTRING(50 70, 70 70, 70 50, 50 50, 50 70)')
      ]));
----
POLYGON ((40 80, 80 80, 80 40, 40 40, 40 80), (50 70, 70 70, 70 50, 50 50, 50 70))

query T
SELECT ST_AsEWKT(ST_MakePolygon(
      ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 80)'),
      ARRAY[
        ST_GeomFromText('LINESTRING(50 70, 70 70, 70 50, 50 50, 50 70)'),
        ST_GeomFromText('LINESTRING(60 60, 75 60, 75 45, 60 45, 60 60)')
      ]));
----
POLYGON ((40 80, 80 80, 80 40, 40 40, 40 80), (50 70, 70 70, 70 50, 50 50, 50 70), (60 60, 75 60, 75 45, 60 45, 60 60))

query T
SELECT ST_AsEWKT(ST_MakePolygon(
      ST_GeomFromText('LINESTRING(40 80, 80 80, 80 40, 40 40, 40 80)', 4326),
      ARRAY[
        ST_GeomFromText('LINESTRING(50 70, 70 70, 70 50, 50 50, 50 70)', 4326)
      ]));
----
SRID=4326;POLYGON ((40 80, 80 80, 80 40, 40 40, 40 80), (50 70, 70 70, 70 50, 50 50, 50 70))

# Multi-Geometry related operations.
query ITTT
SELECT
  ST_NumGeometries(a.geom),
  ST_AsEWKT(ST_GeometryN(a.geom, 0)),
  ST_AsEWKT(ST_GeometryN(a.geom, 1)),
  ST_AsEWKT(ST_GeometryN(a.geom, 2))
FROM (VALUES
  ('MULTIPOINT EMPTY'::geometry),
  ('MULTILINESTRING EMPTY'::geometry),
  ('MULTIPOLYGON EMPTY'::geometry),
  ('MULTIPOINT((0 0), (1 1), (2 2))'::geometry),
  ('SRID=4326;MULTIPOINT((0 0), (1 1), (2 2))'::geometry),
  ('MULTILINESTRING((0 0, 1 1), (2 2, 3 3))'::geometry),
  ('SRID=4326;MULTILINESTRING((0 0, 1 1), (2 2, 3 3))'::geometry),
  ('MULTIPOLYGON(((0 0,1 0, 1 1, 0 0)),((0.1 0.1,0.9 0.1, 0.9 0.9, 0.1 0.1)))'::geometry),
  ('SRID=4326;MULTIPOLYGON(((0 0,1 0, 1 1, 0 0)),((0.1 0.1,0.9 0.1, 0.9 0.9, 0.1 0.1)))'::geometry),
  ('GEOMETRYCOLLECTION (POINT (40 10),LINESTRING (10 10, 20 20, 10 40),POLYGON ((40 40, 20 45, 45 30, 40 40)))'::geometry),
  ('SRID=4326;GEOMETRYCOLLECTION (POINT (40 10),LINESTRING (10 10, 20 20, 10 40),POLYGON ((40 40, 20 45, 45 30, 40 40)))'::geometry)
) a(geom)
----
0  NULL  NULL                                      NULL
0  NULL  NULL                                      NULL
0  NULL  NULL                                      NULL
3  NULL  POINT (0 0)                               POINT (1 1)
3  NULL  SRID=4326;POINT (0 0)                     SRID=4326;POINT (1 1)
2  NULL  LINESTRING (0 0, 1 1)                     LINESTRING (2 2, 3 3)
2  NULL  SRID=4326;LINESTRING (0 0, 1 1)           SRID=4326;LINESTRING (2 2, 3 3)
2  NULL  POLYGON ((0 0, 1 0, 1 1, 0 0))            POLYGON ((0.1 0.1, 0.9 0.1, 0.9 0.9, 0.1 0.1))
2  NULL  SRID=4326;POLYGON ((0 0, 1 0, 1 1, 0 0))  SRID=4326;POLYGON ((0.1 0.1, 0.9 0.1, 0.9 0.9, 0.1 0.1))
3  NULL  POINT (40 10)                             LINESTRING (10 10, 20 20, 10 40)
3  NULL  SRID=4326;POINT (40 10)                   SRID=4326;LINESTRING (10 10, 20 20, 10 40)

statement ok
CREATE TABLE geom_linear (
  dsc  TEXT PRIMARY KEY,
  geom GEOMETRY
)

statement ok
INSERT INTO geom_linear VALUES
  ('Empty LineString', 'LINESTRING EMPTY'),
  ('LineString anticlockwise covering all the quadrants', 'LINESTRING(1 -1, 2 2, -2 2, -1 -1)'),
  ('LineString clockwise covering all the quadrants with SRID 4004', 'SRID=4004;LINESTRING(1 -1, -1 -1, -2 2, 2 2)')

# ST_LineInterpolatePoint, ST_LineInterpolatePoints
query TRBTTT
SELECT
  a.dsc,
  b.fraction,
  c.repeat,
  ST_AsEWKT(ST_LineInterpolatePoint(a.geom, b.fraction::float)),
  ST_AsEWKT(ST_LineInterpolatePoints(a.geom, b.fraction::float)),
  ST_AsEWKT(ST_LineInterPolatePoints(a.geom, b.fraction::float, c.repeat))
FROM geom_linear a
JOIN (VALUES (0.0), (0.2), (0.5), (0.51), (1.0)) b(fraction) ON (1=1)
JOIN (VALUES (true), (false)) c(repeat) ON (1=1)
ORDER BY a.dsc, b.fraction, c.repeat
----
Empty LineString                                                0.0   false  POINT EMPTY                                             POINT EMPTY                                                                                                                             POINT EMPTY
Empty LineString                                                0.0   true   POINT EMPTY                                             POINT EMPTY                                                                                                                             POINT EMPTY
Empty LineString                                                0.2   false  POINT EMPTY                                             MULTIPOINT EMPTY                                                                                                                        POINT EMPTY
Empty LineString                                                0.2   true   POINT EMPTY                                             MULTIPOINT EMPTY                                                                                                                        MULTIPOINT EMPTY
Empty LineString                                                0.5   false  POINT EMPTY                                             MULTIPOINT EMPTY                                                                                                                        POINT EMPTY
Empty LineString                                                0.5   true   POINT EMPTY                                             MULTIPOINT EMPTY                                                                                                                        MULTIPOINT EMPTY
Empty LineString                                                0.51  false  POINT EMPTY                                             POINT EMPTY                                                                                                                             POINT EMPTY
Empty LineString                                                0.51  true   POINT EMPTY                                             POINT EMPTY                                                                                                                             POINT EMPTY
Empty LineString                                                1.0   false  POINT EMPTY                                             POINT EMPTY                                                                                                                             POINT EMPTY
Empty LineString                                                1.0   true   POINT EMPTY                                             POINT EMPTY                                                                                                                             POINT EMPTY
LineString anticlockwise covering all the quadrants             0.0   false  POINT (1 -1)                                            POINT (1 -1)                                                                                                                            POINT (1 -1)
LineString anticlockwise covering all the quadrants             0.0   true   POINT (1 -1)                                            POINT (1 -1)                                                                                                                            POINT (1 -1)
LineString anticlockwise covering all the quadrants             0.2   false  POINT (1.652982212813471 0.958946638440411)             MULTIPOINT (1.652982212813471 0.958946638440411, 1.032455532033675 2, -1.032455532033678 2, -1.65298221281347 0.95894663844041, -1 -1)  POINT (1.652982212813471 0.958946638440411)
LineString anticlockwise covering all the quadrants             0.2   true   POINT (1.652982212813471 0.958946638440411)             MULTIPOINT (1.652982212813471 0.958946638440411, 1.032455532033675 2, -1.032455532033678 2, -1.65298221281347 0.95894663844041, -1 -1)  MULTIPOINT (1.652982212813471 0.958946638440411, 1.032455532033675 2, -1.032455532033678 2, -1.65298221281347 0.95894663844041, -1 -1)
LineString anticlockwise covering all the quadrants             0.5   false  POINT (-0 2)                                            MULTIPOINT (-0 2, -1 -1)                                                                                                                POINT (-0 2)
LineString anticlockwise covering all the quadrants             0.5   true   POINT (-0 2)                                            MULTIPOINT (-0 2, -1 -1)                                                                                                                MULTIPOINT (-0 2, -1 -1)
LineString anticlockwise covering all the quadrants             0.51  false  POINT (-0.103245553203368 2)                            POINT (-0.103245553203368 2)                                                                                                            POINT (-0.103245553203368 2)
LineString anticlockwise covering all the quadrants             0.51  true   POINT (-0.103245553203368 2)                            POINT (-0.103245553203368 2)                                                                                                            POINT (-0.103245553203368 2)
LineString anticlockwise covering all the quadrants             1.0   false  POINT (-1 -1)                                           POINT (-1 -1)                                                                                                                           POINT (-1 -1)
LineString anticlockwise covering all the quadrants             1.0   true   POINT (-1 -1)                                           POINT (-1 -1)                                                                                                                           POINT (-1 -1)
LineString clockwise covering all the quadrants with SRID 4004  0.0   false  SRID=4004;POINT (1 -1)                                  SRID=4004;POINT (1 -1)                                                                                                                  SRID=4004;POINT (1 -1)
LineString clockwise covering all the quadrants with SRID 4004  0.0   true   SRID=4004;POINT (1 -1)                                  SRID=4004;POINT (1 -1)                                                                                                                  SRID=4004;POINT (1 -1)
LineString clockwise covering all the quadrants with SRID 4004  0.2   false  SRID=4004;POINT (-0.832455532033676 -1)                 SRID=4004;MULTIPOINT (-0.832455532033676 -1, -1.526491106406735 0.579473319220206, -1.664911064067351 2, 0.167544467966325 2, 2 2)      SRID=4004;POINT (-0.832455532033676 -1)
LineString clockwise covering all the quadrants with SRID 4004  0.2   true   SRID=4004;POINT (-0.832455532033676 -1)                 SRID=4004;MULTIPOINT (-0.832455532033676 -1, -1.526491106406735 0.579473319220206, -1.664911064067351 2, 0.167544467966325 2, 2 2)      SRID=4004;MULTIPOINT (-0.832455532033676 -1, -1.526491106406735 0.579473319220206, -1.664911064067351 2, 0.167544467966325 2, 2 2)
LineString clockwise covering all the quadrants with SRID 4004  0.5   false  SRID=4004;POINT (-1.816227766016838 1.448683298050514)  SRID=4004;MULTIPOINT (-1.816227766016838 1.448683298050514, 2 2)                                                                        SRID=4004;POINT (-1.816227766016838 1.448683298050514)
LineString clockwise covering all the quadrants with SRID 4004  0.5   true   SRID=4004;POINT (-1.816227766016838 1.448683298050514)  SRID=4004;MULTIPOINT (-1.816227766016838 1.448683298050514, 2 2)                                                                        SRID=4004;MULTIPOINT (-1.816227766016838 1.448683298050514, 2 2)
LineString clockwise covering all the quadrants with SRID 4004  0.51  false  SRID=4004;POINT (-1.845201431977848 1.535604295933545)  SRID=4004;POINT (-1.845201431977848 1.535604295933545)                                                                                  SRID=4004;POINT (-1.845201431977848 1.535604295933545)
LineString clockwise covering all the quadrants with SRID 4004  0.51  true   SRID=4004;POINT (-1.845201431977848 1.535604295933545)  SRID=4004;POINT (-1.845201431977848 1.535604295933545)                                                                                  SRID=4004;POINT (-1.845201431977848 1.535604295933545)
LineString clockwise covering all the quadrants with SRID 4004  1.0   false  SRID=4004;POINT (2 2)                                   SRID=4004;POINT (2 2)                                                                                                                   SRID=4004;POINT (2 2)
LineString clockwise covering all the quadrants with SRID 4004  1.0   true   SRID=4004;POINT (2 2)                                   SRID=4004;POINT (2 2)                                                                                                                   SRID=4004;POINT (2 2)

statement error st_lineinterpolatepoint\(\): fraction -1.000000 should be within \[0 1\] range
SELECT ST_LineInterpolatePoint('LINESTRING (0 0, 1 1)'::geometry, -1)

statement error st_lineinterpolatepoints\(\): fraction -1.000000 should be within \[0 1\] range
SELECT ST_LineInterpolatePoints('LINESTRING (0 0, 1 1)'::geometry, -1, false)

statement error st_lineinterpolatepoint\(\): geometry MultiLineString should be LineString
SELECT ST_LineInterpolatePoint('MULTILINESTRING ((0 0, 1 1), (1 1, 0 0))'::geometry, 0.2)

statement error st_lineinterpolatepoints\(\): geometry MultiLineString should be LineString
SELECT ST_LineInterpolatePoints('MULTILINESTRING ((0 0, 1 1), (1 1, 0 0))'::geometry, 0.2, false)

statement error st_lineinterpolatepoint\(\): geometry Point should be LineString
SELECT ST_LineInterpolatePoint('POINT (0 0)'::geometry, 0.2)

statement error st_lineinterpolatepoints\(\): geometry Point should be LineString
SELECT ST_LineInterpolatePoints('POINT (0 0)'::geometry, 0.2, false)

statement error st_lineinterpolatepoint\(\): geometry Polygon should be LineString
SELECT ST_LineInterpolatePoint('POLYGON((-1.0 0.0, 0.0 0.0, 0.0 1.0, -1.0 1.0, -1.0 0.0))'::geometry, 0.2)

statement error st_lineinterpolatepoints\(\): geometry Polygon should be LineString
SELECT ST_LineInterpolatePoints('POLYGON((-1.0 0.0, 0.0 0.0, 0.0 1.0, -1.0 1.0, -1.0 0.0))'::geometry, 0.2, false)

subtest geog_operators

statement ok
CREATE TABLE geog_operators_test AS SELECT dsc, geom::geography AS geog FROM geom_operators_test

# GROUP BY
query TR
SELECT
  a.dsc,
  ST_Area(a.geog)
FROM geog_operators_test a
GROUP BY a.dsc, a.geog
ORDER BY a.dsc
----
Empty GeometryCollection                  0
Empty LineString                          0
Empty Point                               0
Faraway point                             0
Line going through left and right square  0
NULL                                      NULL
Nested Geometry Collection                0
Point middle of Left Square               0
Point middle of Right Square              0
Square (left)                             1.23087783614695e+10
Square (right)                            1.23087783614695e+10
Square overlapping left and right square  1.35397288423019e+10

# Unary operators
query TRRRRRRRRR
SELECT
  a.dsc,
  ST_Area(a.geog), ST_Area(a.geog, false), ST_Area(a.geog, true),
  ST_Length(a.geog), ST_Length(a.geog, false), ST_Length(a.geog, true),
  ST_Perimeter(a.geog), ST_Perimeter(a.geog, false), ST_Perimeter(a.geog, true)
FROM geog_operators_test a
ORDER BY a.dsc
----
Empty GeometryCollection                  0                     0                     0                     0                 0                 0                 0                 0                 0
Empty LineString                          0                     0                     0                     0                 0                 0                 0                 0                 0
Empty Point                               0                     0                     0                     0                 0                 0                 0                 0                 0
Faraway point                             0                     0                     0                     0                 0                 0                 0                 0                 0
Line going through left and right square  0                     0                     0                     111315.280354463  111190.845659241  111315.280354463  0                 0                 0
NULL                                      NULL                  NULL                  NULL                  NULL              NULL              NULL              NULL              NULL              NULL
Nested Geometry Collection                0                     0                     0                     0                 0                 0                 0                 0                 0
Point middle of Left Square               0                     0                     0                     0                 0                 0                 0                 0                 0
Point middle of Right Square              0                     0                     0                     0                 0                 0                 0                 0                 0
Square (left)                             1.23087783614695e+10  1.23640317985177e+10  1.23087783614695e+10  0                 0                 0                 443770.917248302  444763.382959477  443770.917248302
Square (right)                            1.23087783614695e+10  1.23640317985177e+10  1.23087783614695e+10  0                 0                 0                 443770.917248302  444763.382959477  443770.917248302
Square overlapping left and right square  1.35397288423019e+10  1.36005074605892e+10  1.35397288423019e+10  0                 0                 0                 466033.131162169  467000.705209206  466033.131162169

# Binary operators
query TTRRR
SELECT
  a.dsc,
  b.dsc,
  ST_Distance(a.geog, b.geog), ST_Distance(a.geog, b.geog, false), ST_Distance(a.geog, b.geog, true)
FROM geog_operators_test a
JOIN geog_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  NULL              NULL              NULL
Empty GeometryCollection                  Empty LineString                          NULL              NULL              NULL
Empty GeometryCollection                  Empty Point                               NULL              NULL              NULL
Empty GeometryCollection                  Faraway point                             NULL              NULL              NULL
Empty GeometryCollection                  Line going through left and right square  NULL              NULL              NULL
Empty GeometryCollection                  NULL                                      NULL              NULL              NULL
Empty GeometryCollection                  Nested Geometry Collection                NULL              NULL              NULL
Empty GeometryCollection                  Point middle of Left Square               NULL              NULL              NULL
Empty GeometryCollection                  Point middle of Right Square              NULL              NULL              NULL
Empty GeometryCollection                  Square (left)                             NULL              NULL              NULL
Empty GeometryCollection                  Square (right)                            NULL              NULL              NULL
Empty GeometryCollection                  Square overlapping left and right square  NULL              NULL              NULL
Empty LineString                          Empty GeometryCollection                  NULL              NULL              NULL
Empty LineString                          Empty LineString                          NULL              NULL              NULL
Empty LineString                          Empty Point                               NULL              NULL              NULL
Empty LineString                          Faraway point                             NULL              NULL              NULL
Empty LineString                          Line going through left and right square  NULL              NULL              NULL
Empty LineString                          NULL                                      NULL              NULL              NULL
Empty LineString                          Nested Geometry Collection                NULL              NULL              NULL
Empty LineString                          Point middle of Left Square               NULL              NULL              NULL
Empty LineString                          Point middle of Right Square              NULL              NULL              NULL
Empty LineString                          Square (left)                             NULL              NULL              NULL
Empty LineString                          Square (right)                            NULL              NULL              NULL
Empty LineString                          Square overlapping left and right square  NULL              NULL              NULL
Empty Point                               Empty GeometryCollection                  NULL              NULL              NULL
Empty Point                               Empty LineString                          NULL              NULL              NULL
Empty Point                               Empty Point                               NULL              NULL              NULL
Empty Point                               Faraway point                             NULL              NULL              NULL
Empty Point                               Line going through left and right square  NULL              NULL              NULL
Empty Point                               NULL                                      NULL              NULL              NULL
Empty Point                               Nested Geometry Collection                NULL              NULL              NULL
Empty Point                               Point middle of Left Square               NULL              NULL              NULL
Empty Point                               Point middle of Right Square              NULL              NULL              NULL
Empty Point                               Square (left)                             NULL              NULL              NULL
Empty Point                               Square (right)                            NULL              NULL              NULL
Empty Point                               Square overlapping left and right square  NULL              NULL              NULL
Faraway point                             Empty GeometryCollection                  NULL              NULL              NULL
Faraway point                             Empty LineString                          NULL              NULL              NULL
Faraway point                             Empty Point                               NULL              NULL              NULL
Faraway point                             Faraway point                             0                 0                 0
Faraway point                             Line going through left and right square  705577.648328755  707142.162247235  705577.648328755
Faraway point                             NULL                                      NULL              NULL              NULL
Faraway point                             Nested Geometry Collection                784028.73980903   785768.30266465   784028.73980903
Faraway point                             Point middle of Left Square               788297.405265007  789521.780520966  788297.405265007
Faraway point                             Point middle of Right Square              705577.648328755  707142.162247235  705577.648328755
Faraway point                             Square (left)                             710260.975395327  711311.966664979  710260.975395327
Faraway point                             Square (right)                            627129.502610754  628519.033787529  627129.502610754
Faraway point                             Square overlapping left and right square  627129.502610754  628519.033787529  627129.502610754
Line going through left and right square  Empty GeometryCollection                  NULL              NULL              NULL
Line going through left and right square  Empty LineString                          NULL              NULL              NULL
Line going through left and right square  Empty Point                               NULL              NULL              NULL
Line going through left and right square  Faraway point                             705577.648328755  707142.162247235  705577.648328755
Line going through left and right square  Line going through left and right square  0                 0                 0
Line going through left and right square  NULL                                      NULL              NULL              NULL
Line going through left and right square  Nested Geometry Collection                55289.2571431371  55599.6568243979  55289.2571431371
Line going through left and right square  Point middle of Left Square               0                 0                 0
Line going through left and right square  Point middle of Right Square              0                 0                 0
Line going through left and right square  Square (left)                             0                 0                 0
Line going through left and right square  Square (right)                            0                 0                 0
Line going through left and right square  Square overlapping left and right square  0                 0                 0
NULL                                      Empty GeometryCollection                  NULL              NULL              NULL
NULL                                      Empty LineString                          NULL              NULL              NULL
NULL                                      Empty Point                               NULL              NULL              NULL
NULL                                      Faraway point                             NULL              NULL              NULL
NULL                                      Line going through left and right square  NULL              NULL              NULL
NULL                                      NULL                                      NULL              NULL              NULL
NULL                                      Nested Geometry Collection                NULL              NULL              NULL
NULL                                      Point middle of Left Square               NULL              NULL              NULL
NULL                                      Point middle of Right Square              NULL              NULL              NULL
NULL                                      Square (left)                             NULL              NULL              NULL
NULL                                      Square (right)                            NULL              NULL              NULL
NULL                                      Square overlapping left and right square  NULL              NULL              NULL
Nested Geometry Collection                Empty GeometryCollection                  NULL              NULL              NULL
Nested Geometry Collection                Empty LineString                          NULL              NULL              NULL
Nested Geometry Collection                Empty Point                               NULL              NULL              NULL
Nested Geometry Collection                Faraway point                             784028.73980903   785768.30266465   784028.73980903
Nested Geometry Collection                Line going through left and right square  55289.2571431371  55599.6568243979  55289.2571431371
Nested Geometry Collection                NULL                                      NULL              NULL              NULL
Nested Geometry Collection                Nested Geometry Collection                0                 0                 0
Nested Geometry Collection                Point middle of Left Square               78451.2480312391  78626.2959272162  78451.2480312391
Nested Geometry Collection                Point middle of Right Square              78451.2480312391  78626.2959272162  78451.2480312391
Nested Geometry Collection                Square (left)                             0                 0                 0
Nested Geometry Collection                Square (right)                            0                 0                 0
Nested Geometry Collection                Square overlapping left and right square  0                 0                 0
Point middle of Left Square               Empty GeometryCollection                  NULL              NULL              NULL
Point middle of Left Square               Empty LineString                          NULL              NULL              NULL
Point middle of Left Square               Empty Point                               NULL              NULL              NULL
Point middle of Left Square               Faraway point                             788297.405265007  789521.780520966  788297.405265007
Point middle of Left Square               Line going through left and right square  0                 0                 0
Point middle of Left Square               NULL                                      NULL              NULL              NULL
Point middle of Left Square               Nested Geometry Collection                78451.2480312391  78626.2959272162  78451.2480312391
Point middle of Left Square               Point middle of Left Square               0                 0                 0
Point middle of Left Square               Point middle of Right Square              111315.280354463  111190.845659241  111315.280354463
Point middle of Left Square               Square (left)                             0                 0                 0
Point middle of Left Square               Square (right)                            55657.6401772334  55595.4228296203  55657.6401772334
Point middle of Left Square               Square overlapping left and right square  44526.1121572803  44476.338279173   44526.1121572803
Point middle of Right Square              Empty GeometryCollection                  NULL              NULL              NULL
Point middle of Right Square              Empty LineString                          NULL              NULL              NULL
Point middle of Right Square              Empty Point                               NULL              NULL              NULL
Point middle of Right Square              Faraway point                             705577.648328755  707142.162247235  705577.648328755
Point middle of Right Square              Line going through left and right square  0                 0                 0
Point middle of Right Square              NULL                                      NULL              NULL              NULL
Point middle of Right Square              Nested Geometry Collection                78451.2480312391  78626.2959272162  78451.2480312391
Point middle of Right Square              Point middle of Left Square               111315.280354463  111190.845659241  111315.280354463
Point middle of Right Square              Point middle of Right Square              0                 0                 0
Point middle of Right Square              Square (left)                             55657.6401772334  55595.4228296203  55657.6401772334
Point middle of Right Square              Square (right)                            0                 0                 0
Point middle of Right Square              Square overlapping left and right square  0                 0                 0
Square (left)                             Empty GeometryCollection                  NULL              NULL              NULL
Square (left)                             Empty LineString                          NULL              NULL              NULL
Square (left)                             Empty Point                               NULL              NULL              NULL
Square (left)                             Faraway point                             710260.975395327  711311.966664979  710260.975395327
Square (left)                             Line going through left and right square  0                 0                 0
Square (left)                             NULL                                      NULL              NULL              NULL
Square (left)                             Nested Geometry Collection                0                 0                 0
Square (left)                             Point middle of Left Square               0                 0                 0
Square (left)                             Point middle of Right Square              55657.6401772334  55595.4228296203  55657.6401772334
Square (left)                             Square (left)                             0                 0                 0
Square (left)                             Square (right)                            0                 0                 0
Square (left)                             Square overlapping left and right square  0                 0                 0
Square (right)                            Empty GeometryCollection                  NULL              NULL              NULL
Square (right)                            Empty LineString                          NULL              NULL              NULL
Square (right)                            Empty Point                               NULL              NULL              NULL
Square (right)                            Faraway point                             627129.502610754  628519.033787529  627129.502610754
Square (right)                            Line going through left and right square  0                 0                 0
Square (right)                            NULL                                      NULL              NULL              NULL
Square (right)                            Nested Geometry Collection                0                 0                 0
Square (right)                            Point middle of Left Square               55657.6401772334  55595.4228296203  55657.6401772334
Square (right)                            Point middle of Right Square              0                 0                 0
Square (right)                            Square (left)                             0                 0                 0
Square (right)                            Square (right)                            0                 0                 0
Square (right)                            Square overlapping left and right square  0                 0                 0
Square overlapping left and right square  Empty GeometryCollection                  NULL              NULL              NULL
Square overlapping left and right square  Empty LineString                          NULL              NULL              NULL
Square overlapping left and right square  Empty Point                               NULL              NULL              NULL
Square overlapping left and right square  Faraway point                             627129.502610754  628519.033787529  627129.502610754
Square overlapping left and right square  Line going through left and right square  0                 0                 0
Square overlapping left and right square  NULL                                      NULL              NULL              NULL
Square overlapping left and right square  Nested Geometry Collection                0                 0                 0
Square overlapping left and right square  Point middle of Left Square               44526.1121572803  44476.338279173   44526.1121572803
Square overlapping left and right square  Point middle of Right Square              0                 0                 0
Square overlapping left and right square  Square (left)                             0                 0                 0
Square overlapping left and right square  Square (right)                            0                 0                 0
Square overlapping left and right square  Square overlapping left and right square  0                 0                 0

# Binary predicates
query TTBBB
SELECT
  a.dsc,
  b.dsc,
  ST_Covers(a.geog, b.geog),
  ST_CoveredBy(a.geog, b.geog),
  ST_Intersects(a.geog, b.geog)
FROM geog_operators_test a
JOIN geog_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  false  false  false
Empty GeometryCollection                  Empty LineString                          false  false  false
Empty GeometryCollection                  Empty Point                               false  false  false
Empty GeometryCollection                  Faraway point                             false  false  false
Empty GeometryCollection                  Line going through left and right square  false  false  false
Empty GeometryCollection                  NULL                                      NULL   NULL   NULL
Empty GeometryCollection                  Nested Geometry Collection                false  false  false
Empty GeometryCollection                  Point middle of Left Square               false  false  false
Empty GeometryCollection                  Point middle of Right Square              false  false  false
Empty GeometryCollection                  Square (left)                             false  false  false
Empty GeometryCollection                  Square (right)                            false  false  false
Empty GeometryCollection                  Square overlapping left and right square  false  false  false
Empty LineString                          Empty GeometryCollection                  false  false  false
Empty LineString                          Empty LineString                          false  false  false
Empty LineString                          Empty Point                               false  false  false
Empty LineString                          Faraway point                             false  false  false
Empty LineString                          Line going through left and right square  false  false  false
Empty LineString                          NULL                                      NULL   NULL   NULL
Empty LineString                          Nested Geometry Collection                false  false  false
Empty LineString                          Point middle of Left Square               false  false  false
Empty LineString                          Point middle of Right Square              false  false  false
Empty LineString                          Square (left)                             false  false  false
Empty LineString                          Square (right)                            false  false  false
Empty LineString                          Square overlapping left and right square  false  false  false
Empty Point                               Empty GeometryCollection                  false  false  false
Empty Point                               Empty LineString                          false  false  false
Empty Point                               Empty Point                               false  false  false
Empty Point                               Faraway point                             false  false  false
Empty Point                               Line going through left and right square  false  false  false
Empty Point                               NULL                                      NULL   NULL   NULL
Empty Point                               Nested Geometry Collection                false  false  false
Empty Point                               Point middle of Left Square               false  false  false
Empty Point                               Point middle of Right Square              false  false  false
Empty Point                               Square (left)                             false  false  false
Empty Point                               Square (right)                            false  false  false
Empty Point                               Square overlapping left and right square  false  false  false
Faraway point                             Empty GeometryCollection                  false  false  false
Faraway point                             Empty LineString                          false  false  false
Faraway point                             Empty Point                               false  false  false
Faraway point                             Faraway point                             true   true   true
Faraway point                             Line going through left and right square  false  false  false
Faraway point                             NULL                                      NULL   NULL   NULL
Faraway point                             Nested Geometry Collection                false  false  false
Faraway point                             Point middle of Left Square               false  false  false
Faraway point                             Point middle of Right Square              false  false  false
Faraway point                             Square (left)                             false  false  false
Faraway point                             Square (right)                            false  false  false
Faraway point                             Square overlapping left and right square  false  false  false
Line going through left and right square  Empty GeometryCollection                  false  false  false
Line going through left and right square  Empty LineString                          false  false  false
Line going through left and right square  Empty Point                               false  false  false
Line going through left and right square  Faraway point                             false  false  false
Line going through left and right square  Line going through left and right square  true   true   true
Line going through left and right square  NULL                                      NULL   NULL   NULL
Line going through left and right square  Nested Geometry Collection                false  false  false
Line going through left and right square  Point middle of Left Square               true   false  true
Line going through left and right square  Point middle of Right Square              true   false  true
Line going through left and right square  Square (left)                             false  false  true
Line going through left and right square  Square (right)                            false  false  true
Line going through left and right square  Square overlapping left and right square  false  false  true
NULL                                      Empty GeometryCollection                  NULL   NULL   NULL
NULL                                      Empty LineString                          NULL   NULL   NULL
NULL                                      Empty Point                               NULL   NULL   NULL
NULL                                      Faraway point                             NULL   NULL   NULL
NULL                                      Line going through left and right square  NULL   NULL   NULL
NULL                                      NULL                                      NULL   NULL   NULL
NULL                                      Nested Geometry Collection                NULL   NULL   NULL
NULL                                      Point middle of Left Square               NULL   NULL   NULL
NULL                                      Point middle of Right Square              NULL   NULL   NULL
NULL                                      Square (left)                             NULL   NULL   NULL
NULL                                      Square (right)                            NULL   NULL   NULL
NULL                                      Square overlapping left and right square  NULL   NULL   NULL
Nested Geometry Collection                Empty GeometryCollection                  false  false  false
Nested Geometry Collection                Empty LineString                          false  false  false
Nested Geometry Collection                Empty Point                               false  false  false
Nested Geometry Collection                Faraway point                             false  false  false
Nested Geometry Collection                Line going through left and right square  false  false  false
Nested Geometry Collection                NULL                                      NULL   NULL   NULL
Nested Geometry Collection                Nested Geometry Collection                true   true   true
Nested Geometry Collection                Point middle of Left Square               false  false  false
Nested Geometry Collection                Point middle of Right Square              false  false  false
Nested Geometry Collection                Square (left)                             false  true   true
Nested Geometry Collection                Square (right)                            false  true   true
Nested Geometry Collection                Square overlapping left and right square  false  true   true
Point middle of Left Square               Empty GeometryCollection                  false  false  false
Point middle of Left Square               Empty LineString                          false  false  false
Point middle of Left Square               Empty Point                               false  false  false
Point middle of Left Square               Faraway point                             false  false  false
Point middle of Left Square               Line going through left and right square  false  true   true
Point middle of Left Square               NULL                                      NULL   NULL   NULL
Point middle of Left Square               Nested Geometry Collection                false  false  false
Point middle of Left Square               Point middle of Left Square               true   true   true
Point middle of Left Square               Point middle of Right Square              false  false  false
Point middle of Left Square               Square (left)                             false  true   true
Point middle of Left Square               Square (right)                            false  false  false
Point middle of Left Square               Square overlapping left and right square  false  false  false
Point middle of Right Square              Empty GeometryCollection                  false  false  false
Point middle of Right Square              Empty LineString                          false  false  false
Point middle of Right Square              Empty Point                               false  false  false
Point middle of Right Square              Faraway point                             false  false  false
Point middle of Right Square              Line going through left and right square  false  true   true
Point middle of Right Square              NULL                                      NULL   NULL   NULL
Point middle of Right Square              Nested Geometry Collection                false  false  false
Point middle of Right Square              Point middle of Left Square               false  false  false
Point middle of Right Square              Point middle of Right Square              true   true   true
Point middle of Right Square              Square (left)                             false  false  false
Point middle of Right Square              Square (right)                            false  true   true
Point middle of Right Square              Square overlapping left and right square  false  true   true
Square (left)                             Empty GeometryCollection                  false  false  false
Square (left)                             Empty LineString                          false  false  false
Square (left)                             Empty Point                               false  false  false
Square (left)                             Faraway point                             false  false  false
Square (left)                             Line going through left and right square  false  false  true
Square (left)                             NULL                                      NULL   NULL   NULL
Square (left)                             Nested Geometry Collection                true   false  true
Square (left)                             Point middle of Left Square               true   false  true
Square (left)                             Point middle of Right Square              false  false  false
Square (left)                             Square (left)                             true   true   true
Square (left)                             Square (right)                            false  false  true
Square (left)                             Square overlapping left and right square  false  false  true
Square (right)                            Empty GeometryCollection                  false  false  false
Square (right)                            Empty LineString                          false  false  false
Square (right)                            Empty Point                               false  false  false
Square (right)                            Faraway point                             false  false  false
Square (right)                            Line going through left and right square  false  false  true
Square (right)                            NULL                                      NULL   NULL   NULL
Square (right)                            Nested Geometry Collection                true   false  true
Square (right)                            Point middle of Left Square               false  false  false
Square (right)                            Point middle of Right Square              true   false  true
Square (right)                            Square (left)                             false  false  true
Square (right)                            Square (right)                            true   true   true
Square (right)                            Square overlapping left and right square  false  false  true
Square overlapping left and right square  Empty GeometryCollection                  false  false  false
Square overlapping left and right square  Empty LineString                          false  false  false
Square overlapping left and right square  Empty Point                               false  false  false
Square overlapping left and right square  Faraway point                             false  false  false
Square overlapping left and right square  Line going through left and right square  false  false  true
Square overlapping left and right square  NULL                                      NULL   NULL   NULL
Square overlapping left and right square  Nested Geometry Collection                true   false  true
Square overlapping left and right square  Point middle of Left Square               false  false  false
Square overlapping left and right square  Point middle of Right Square              true   false  true
Square overlapping left and right square  Square (left)                             false  false  true
Square overlapping left and right square  Square (right)                            false  false  true
Square overlapping left and right square  Square overlapping left and right square  true   true   true

query TTBBB
SELECT
  a.dsc,
  b.dsc,
  _ST_Covers(a.geog, b.geog),
  _ST_CoveredBy(a.geog, b.geog),
  _ST_Intersects(a.geog, b.geog)
FROM geog_operators_test a
JOIN geog_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  false  false  false
Empty GeometryCollection                  Empty LineString                          false  false  false
Empty GeometryCollection                  Empty Point                               false  false  false
Empty GeometryCollection                  Faraway point                             false  false  false
Empty GeometryCollection                  Line going through left and right square  false  false  false
Empty GeometryCollection                  NULL                                      NULL   NULL   NULL
Empty GeometryCollection                  Nested Geometry Collection                false  false  false
Empty GeometryCollection                  Point middle of Left Square               false  false  false
Empty GeometryCollection                  Point middle of Right Square              false  false  false
Empty GeometryCollection                  Square (left)                             false  false  false
Empty GeometryCollection                  Square (right)                            false  false  false
Empty GeometryCollection                  Square overlapping left and right square  false  false  false
Empty LineString                          Empty GeometryCollection                  false  false  false
Empty LineString                          Empty LineString                          false  false  false
Empty LineString                          Empty Point                               false  false  false
Empty LineString                          Faraway point                             false  false  false
Empty LineString                          Line going through left and right square  false  false  false
Empty LineString                          NULL                                      NULL   NULL   NULL
Empty LineString                          Nested Geometry Collection                false  false  false
Empty LineString                          Point middle of Left Square               false  false  false
Empty LineString                          Point middle of Right Square              false  false  false
Empty LineString                          Square (left)                             false  false  false
Empty LineString                          Square (right)                            false  false  false
Empty LineString                          Square overlapping left and right square  false  false  false
Empty Point                               Empty GeometryCollection                  false  false  false
Empty Point                               Empty LineString                          false  false  false
Empty Point                               Empty Point                               false  false  false
Empty Point                               Faraway point                             false  false  false
Empty Point                               Line going through left and right square  false  false  false
Empty Point                               NULL                                      NULL   NULL   NULL
Empty Point                               Nested Geometry Collection                false  false  false
Empty Point                               Point middle of Left Square               false  false  false
Empty Point                               Point middle of Right Square              false  false  false
Empty Point                               Square (left)                             false  false  false
Empty Point                               Square (right)                            false  false  false
Empty Point                               Square overlapping left and right square  false  false  false
Faraway point                             Empty GeometryCollection                  false  false  false
Faraway point                             Empty LineString                          false  false  false
Faraway point                             Empty Point                               false  false  false
Faraway point                             Faraway point                             true   true   true
Faraway point                             Line going through left and right square  false  false  false
Faraway point                             NULL                                      NULL   NULL   NULL
Faraway point                             Nested Geometry Collection                false  false  false
Faraway point                             Point middle of Left Square               false  false  false
Faraway point                             Point middle of Right Square              false  false  false
Faraway point                             Square (left)                             false  false  false
Faraway point                             Square (right)                            false  false  false
Faraway point                             Square overlapping left and right square  false  false  false
Line going through left and right square  Empty GeometryCollection                  false  false  false
Line going through left and right square  Empty LineString                          false  false  false
Line going through left and right square  Empty Point                               false  false  false
Line going through left and right square  Faraway point                             false  false  false
Line going through left and right square  Line going through left and right square  true   true   true
Line going through left and right square  NULL                                      NULL   NULL   NULL
Line going through left and right square  Nested Geometry Collection                false  false  false
Line going through left and right square  Point middle of Left Square               true   false  true
Line going through left and right square  Point middle of Right Square              true   false  true
Line going through left and right square  Square (left)                             false  false  true
Line going through left and right square  Square (right)                            false  false  true
Line going through left and right square  Square overlapping left and right square  false  false  true
NULL                                      Empty GeometryCollection                  NULL   NULL   NULL
NULL                                      Empty LineString                          NULL   NULL   NULL
NULL                                      Empty Point                               NULL   NULL   NULL
NULL                                      Faraway point                             NULL   NULL   NULL
NULL                                      Line going through left and right square  NULL   NULL   NULL
NULL                                      NULL                                      NULL   NULL   NULL
NULL                                      Nested Geometry Collection                NULL   NULL   NULL
NULL                                      Point middle of Left Square               NULL   NULL   NULL
NULL                                      Point middle of Right Square              NULL   NULL   NULL
NULL                                      Square (left)                             NULL   NULL   NULL
NULL                                      Square (right)                            NULL   NULL   NULL
NULL                                      Square overlapping left and right square  NULL   NULL   NULL
Nested Geometry Collection                Empty GeometryCollection                  false  false  false
Nested Geometry Collection                Empty LineString                          false  false  false
Nested Geometry Collection                Empty Point                               false  false  false
Nested Geometry Collection                Faraway point                             false  false  false
Nested Geometry Collection                Line going through left and right square  false  false  false
Nested Geometry Collection                NULL                                      NULL   NULL   NULL
Nested Geometry Collection                Nested Geometry Collection                true   true   true
Nested Geometry Collection                Point middle of Left Square               false  false  false
Nested Geometry Collection                Point middle of Right Square              false  false  false
Nested Geometry Collection                Square (left)                             false  true   true
Nested Geometry Collection                Square (right)                            false  true   true
Nested Geometry Collection                Square overlapping left and right square  false  true   true
Point middle of Left Square               Empty GeometryCollection                  false  false  false
Point middle of Left Square               Empty LineString                          false  false  false
Point middle of Left Square               Empty Point                               false  false  false
Point middle of Left Square               Faraway point                             false  false  false
Point middle of Left Square               Line going through left and right square  false  true   true
Point middle of Left Square               NULL                                      NULL   NULL   NULL
Point middle of Left Square               Nested Geometry Collection                false  false  false
Point middle of Left Square               Point middle of Left Square               true   true   true
Point middle of Left Square               Point middle of Right Square              false  false  false
Point middle of Left Square               Square (left)                             false  true   true
Point middle of Left Square               Square (right)                            false  false  false
Point middle of Left Square               Square overlapping left and right square  false  false  false
Point middle of Right Square              Empty GeometryCollection                  false  false  false
Point middle of Right Square              Empty LineString                          false  false  false
Point middle of Right Square              Empty Point                               false  false  false
Point middle of Right Square              Faraway point                             false  false  false
Point middle of Right Square              Line going through left and right square  false  true   true
Point middle of Right Square              NULL                                      NULL   NULL   NULL
Point middle of Right Square              Nested Geometry Collection                false  false  false
Point middle of Right Square              Point middle of Left Square               false  false  false
Point middle of Right Square              Point middle of Right Square              true   true   true
Point middle of Right Square              Square (left)                             false  false  false
Point middle of Right Square              Square (right)                            false  true   true
Point middle of Right Square              Square overlapping left and right square  false  true   true
Square (left)                             Empty GeometryCollection                  false  false  false
Square (left)                             Empty LineString                          false  false  false
Square (left)                             Empty Point                               false  false  false
Square (left)                             Faraway point                             false  false  false
Square (left)                             Line going through left and right square  false  false  true
Square (left)                             NULL                                      NULL   NULL   NULL
Square (left)                             Nested Geometry Collection                true   false  true
Square (left)                             Point middle of Left Square               true   false  true
Square (left)                             Point middle of Right Square              false  false  false
Square (left)                             Square (left)                             true   true   true
Square (left)                             Square (right)                            false  false  true
Square (left)                             Square overlapping left and right square  false  false  true
Square (right)                            Empty GeometryCollection                  false  false  false
Square (right)                            Empty LineString                          false  false  false
Square (right)                            Empty Point                               false  false  false
Square (right)                            Faraway point                             false  false  false
Square (right)                            Line going through left and right square  false  false  true
Square (right)                            NULL                                      NULL   NULL   NULL
Square (right)                            Nested Geometry Collection                true   false  true
Square (right)                            Point middle of Left Square               false  false  false
Square (right)                            Point middle of Right Square              true   false  true
Square (right)                            Square (left)                             false  false  true
Square (right)                            Square (right)                            true   true   true
Square (right)                            Square overlapping left and right square  false  false  true
Square overlapping left and right square  Empty GeometryCollection                  false  false  false
Square overlapping left and right square  Empty LineString                          false  false  false
Square overlapping left and right square  Empty Point                               false  false  false
Square overlapping left and right square  Faraway point                             false  false  false
Square overlapping left and right square  Line going through left and right square  false  false  true
Square overlapping left and right square  NULL                                      NULL   NULL   NULL
Square overlapping left and right square  Nested Geometry Collection                true   false  true
Square overlapping left and right square  Point middle of Left Square               false  false  false
Square overlapping left and right square  Point middle of Right Square              true   false  true
Square overlapping left and right square  Square (left)                             false  false  true
Square overlapping left and right square  Square (right)                            false  false  true
Square overlapping left and right square  Square overlapping left and right square  true   true   true

# DWithin
query TTBBB
SELECT
  a.dsc,
  b.dsc,
  ST_DWithin(a.geog, b.geog, 70558),
  ST_DWithin(a.geog, b.geog, 70558, false),
  ST_DWithin(a.geog, b.geog, 70558, true)
FROM geog_operators_test a
JOIN geog_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  false  false  false
Empty GeometryCollection                  Empty LineString                          false  false  false
Empty GeometryCollection                  Empty Point                               false  false  false
Empty GeometryCollection                  Faraway point                             false  false  false
Empty GeometryCollection                  Line going through left and right square  false  false  false
Empty GeometryCollection                  NULL                                      NULL   NULL   NULL
Empty GeometryCollection                  Nested Geometry Collection                false  false  false
Empty GeometryCollection                  Point middle of Left Square               false  false  false
Empty GeometryCollection                  Point middle of Right Square              false  false  false
Empty GeometryCollection                  Square (left)                             false  false  false
Empty GeometryCollection                  Square (right)                            false  false  false
Empty GeometryCollection                  Square overlapping left and right square  false  false  false
Empty LineString                          Empty GeometryCollection                  false  false  false
Empty LineString                          Empty LineString                          false  false  false
Empty LineString                          Empty Point                               false  false  false
Empty LineString                          Faraway point                             false  false  false
Empty LineString                          Line going through left and right square  false  false  false
Empty LineString                          NULL                                      NULL   NULL   NULL
Empty LineString                          Nested Geometry Collection                false  false  false
Empty LineString                          Point middle of Left Square               false  false  false
Empty LineString                          Point middle of Right Square              false  false  false
Empty LineString                          Square (left)                             false  false  false
Empty LineString                          Square (right)                            false  false  false
Empty LineString                          Square overlapping left and right square  false  false  false
Empty Point                               Empty GeometryCollection                  false  false  false
Empty Point                               Empty LineString                          false  false  false
Empty Point                               Empty Point                               false  false  false
Empty Point                               Faraway point                             false  false  false
Empty Point                               Line going through left and right square  false  false  false
Empty Point                               NULL                                      NULL   NULL   NULL
Empty Point                               Nested Geometry Collection                false  false  false
Empty Point                               Point middle of Left Square               false  false  false
Empty Point                               Point middle of Right Square              false  false  false
Empty Point                               Square (left)                             false  false  false
Empty Point                               Square (right)                            false  false  false
Empty Point                               Square overlapping left and right square  false  false  false
Faraway point                             Empty GeometryCollection                  false  false  false
Faraway point                             Empty LineString                          false  false  false
Faraway point                             Empty Point                               false  false  false
Faraway point                             Faraway point                             true   true   true
Faraway point                             Line going through left and right square  false  false  false
Faraway point                             NULL                                      NULL   NULL   NULL
Faraway point                             Nested Geometry Collection                false  false  false
Faraway point                             Point middle of Left Square               false  false  false
Faraway point                             Point middle of Right Square              false  false  false
Faraway point                             Square (left)                             false  false  false
Faraway point                             Square (right)                            false  false  false
Faraway point                             Square overlapping left and right square  false  false  false
Line going through left and right square  Empty GeometryCollection                  false  false  false
Line going through left and right square  Empty LineString                          false  false  false
Line going through left and right square  Empty Point                               false  false  false
Line going through left and right square  Faraway point                             false  false  false
Line going through left and right square  Line going through left and right square  true   true   true
Line going through left and right square  NULL                                      NULL   NULL   NULL
Line going through left and right square  Nested Geometry Collection                true   true   true
Line going through left and right square  Point middle of Left Square               true   true   true
Line going through left and right square  Point middle of Right Square              true   true   true
Line going through left and right square  Square (left)                             true   true   true
Line going through left and right square  Square (right)                            true   true   true
Line going through left and right square  Square overlapping left and right square  true   true   true
NULL                                      Empty GeometryCollection                  NULL   NULL   NULL
NULL                                      Empty LineString                          NULL   NULL   NULL
NULL                                      Empty Point                               NULL   NULL   NULL
NULL                                      Faraway point                             NULL   NULL   NULL
NULL                                      Line going through left and right square  NULL   NULL   NULL
NULL                                      NULL                                      NULL   NULL   NULL
NULL                                      Nested Geometry Collection                NULL   NULL   NULL
NULL                                      Point middle of Left Square               NULL   NULL   NULL
NULL                                      Point middle of Right Square              NULL   NULL   NULL
NULL                                      Square (left)                             NULL   NULL   NULL
NULL                                      Square (right)                            NULL   NULL   NULL
NULL                                      Square overlapping left and right square  NULL   NULL   NULL
Nested Geometry Collection                Empty GeometryCollection                  false  false  false
Nested Geometry Collection                Empty LineString                          false  false  false
Nested Geometry Collection                Empty Point                               false  false  false
Nested Geometry Collection                Faraway point                             false  false  false
Nested Geometry Collection                Line going through left and right square  true   true   true
Nested Geometry Collection                NULL                                      NULL   NULL   NULL
Nested Geometry Collection                Nested Geometry Collection                true   true   true
Nested Geometry Collection                Point middle of Left Square               false  false  false
Nested Geometry Collection                Point middle of Right Square              false  false  false
Nested Geometry Collection                Square (left)                             true   true   true
Nested Geometry Collection                Square (right)                            true   true   true
Nested Geometry Collection                Square overlapping left and right square  true   true   true
Point middle of Left Square               Empty GeometryCollection                  false  false  false
Point middle of Left Square               Empty LineString                          false  false  false
Point middle of Left Square               Empty Point                               false  false  false
Point middle of Left Square               Faraway point                             false  false  false
Point middle of Left Square               Line going through left and right square  true   true   true
Point middle of Left Square               NULL                                      NULL   NULL   NULL
Point middle of Left Square               Nested Geometry Collection                false  false  false
Point middle of Left Square               Point middle of Left Square               true   true   true
Point middle of Left Square               Point middle of Right Square              false  false  false
Point middle of Left Square               Square (left)                             true   true   true
Point middle of Left Square               Square (right)                            true   true   true
Point middle of Left Square               Square overlapping left and right square  true   true   true
Point middle of Right Square              Empty GeometryCollection                  false  false  false
Point middle of Right Square              Empty LineString                          false  false  false
Point middle of Right Square              Empty Point                               false  false  false
Point middle of Right Square              Faraway point                             false  false  false
Point middle of Right Square              Line going through left and right square  true   true   true
Point middle of Right Square              NULL                                      NULL   NULL   NULL
Point middle of Right Square              Nested Geometry Collection                false  false  false
Point middle of Right Square              Point middle of Left Square               false  false  false
Point middle of Right Square              Point middle of Right Square              true   true   true
Point middle of Right Square              Square (left)                             true   true   true
Point middle of Right Square              Square (right)                            true   true   true
Point middle of Right Square              Square overlapping left and right square  true   true   true
Square (left)                             Empty GeometryCollection                  false  false  false
Square (left)                             Empty LineString                          false  false  false
Square (left)                             Empty Point                               false  false  false
Square (left)                             Faraway point                             false  false  false
Square (left)                             Line going through left and right square  true   true   true
Square (left)                             NULL                                      NULL   NULL   NULL
Square (left)                             Nested Geometry Collection                true   true   true
Square (left)                             Point middle of Left Square               true   true   true
Square (left)                             Point middle of Right Square              true   true   true
Square (left)                             Square (left)                             true   true   true
Square (left)                             Square (right)                            true   true   true
Square (left)                             Square overlapping left and right square  true   true   true
Square (right)                            Empty GeometryCollection                  false  false  false
Square (right)                            Empty LineString                          false  false  false
Square (right)                            Empty Point                               false  false  false
Square (right)                            Faraway point                             false  false  false
Square (right)                            Line going through left and right square  true   true   true
Square (right)                            NULL                                      NULL   NULL   NULL
Square (right)                            Nested Geometry Collection                true   true   true
Square (right)                            Point middle of Left Square               true   true   true
Square (right)                            Point middle of Right Square              true   true   true
Square (right)                            Square (left)                             true   true   true
Square (right)                            Square (right)                            true   true   true
Square (right)                            Square overlapping left and right square  true   true   true
Square overlapping left and right square  Empty GeometryCollection                  false  false  false
Square overlapping left and right square  Empty LineString                          false  false  false
Square overlapping left and right square  Empty Point                               false  false  false
Square overlapping left and right square  Faraway point                             false  false  false
Square overlapping left and right square  Line going through left and right square  true   true   true
Square overlapping left and right square  NULL                                      NULL   NULL   NULL
Square overlapping left and right square  Nested Geometry Collection                true   true   true
Square overlapping left and right square  Point middle of Left Square               true   true   true
Square overlapping left and right square  Point middle of Right Square              true   true   true
Square overlapping left and right square  Square (left)                             true   true   true
Square overlapping left and right square  Square (right)                            true   true   true
Square overlapping left and right square  Square overlapping left and right square  true   true   true

query TTBBB
SELECT
  a.dsc,
  b.dsc,
  _ST_DWithin(a.geog, b.geog, 70558),
  _ST_DWithin(a.geog, b.geog, 70558, false),
  _ST_DWithin(a.geog, b.geog, 70558, true)
FROM geog_operators_test a
JOIN geog_operators_test b ON (1=1)
ORDER BY a.dsc, b.dsc
----
Empty GeometryCollection                  Empty GeometryCollection                  false  false  false
Empty GeometryCollection                  Empty LineString                          false  false  false
Empty GeometryCollection                  Empty Point                               false  false  false
Empty GeometryCollection                  Faraway point                             false  false  false
Empty GeometryCollection                  Line going through left and right square  false  false  false
Empty GeometryCollection                  NULL                                      NULL   NULL   NULL
Empty GeometryCollection                  Nested Geometry Collection                false  false  false
Empty GeometryCollection                  Point middle of Left Square               false  false  false
Empty GeometryCollection                  Point middle of Right Square              false  false  false
Empty GeometryCollection                  Square (left)                             false  false  false
Empty GeometryCollection                  Square (right)                            false  false  false
Empty GeometryCollection                  Square overlapping left and right square  false  false  false
Empty LineString                          Empty GeometryCollection                  false  false  false
Empty LineString                          Empty LineString                          false  false  false
Empty LineString                          Empty Point                               false  false  false
Empty LineString                          Faraway point                             false  false  false
Empty LineString                          Line going through left and right square  false  false  false
Empty LineString                          NULL                                      NULL   NULL   NULL
Empty LineString                          Nested Geometry Collection                false  false  false
Empty LineString                          Point middle of Left Square               false  false  false
Empty LineString                          Point middle of Right Square              false  false  false
Empty LineString                          Square (left)                             false  false  false
Empty LineString                          Square (right)                            false  false  false
Empty LineString                          Square overlapping left and right square  false  false  false
Empty Point                               Empty GeometryCollection                  false  false  false
Empty Point                               Empty LineString                          false  false  false
Empty Point                               Empty Point                               false  false  false
Empty Point                               Faraway point                             false  false  false
Empty Point                               Line going through left and right square  false  false  false
Empty Point                               NULL                                      NULL   NULL   NULL
Empty Point                               Nested Geometry Collection                false  false  false
Empty Point                               Point middle of Left Square               false  false  false
Empty Point                               Point middle of Right Square              false  false  false
Empty Point                               Square (left)                             false  false  false
Empty Point                               Square (right)                            false  false  false
Empty Point                               Square overlapping left and right square  false  false  false
Faraway point                             Empty GeometryCollection                  false  false  false
Faraway point                             Empty LineString                          false  false  false
Faraway point                             Empty Point                               false  false  false
Faraway point                             Faraway point                             true   true   true
Faraway point                             Line going through left and right square  false  false  false
Faraway point                             NULL                                      NULL   NULL   NULL
Faraway point                             Nested Geometry Collection                false  false  false
Faraway point                             Point middle of Left Square               false  false  false
Faraway point                             Point middle of Right Square              false  false  false
Faraway point                             Square (left)                             false  false  false
Faraway point                             Square (right)                            false  false  false
Faraway point                             Square overlapping left and right square  false  false  false
Line going through left and right square  Empty GeometryCollection                  false  false  false
Line going through left and right square  Empty LineString                          false  false  false
Line going through left and right square  Empty Point                               false  false  false
Line going through left and right square  Faraway point                             false  false  false
Line going through left and right square  Line going through left and right square  true   true   true
Line going through left and right square  NULL                                      NULL   NULL   NULL
Line going through left and right square  Nested Geometry Collection                true   true   true
Line going through left and right square  Point middle of Left Square               true   true   true
Line going through left and right square  Point middle of Right Square              true   true   true
Line going through left and right square  Square (left)                             true   true   true
Line going through left and right square  Square (right)                            true   true   true
Line going through left and right square  Square overlapping left and right square  true   true   true
NULL                                      Empty GeometryCollection                  NULL   NULL   NULL
NULL                                      Empty LineString                          NULL   NULL   NULL
NULL                                      Empty Point                               NULL   NULL   NULL
NULL                                      Faraway point                             NULL   NULL   NULL
NULL                                      Line going through left and right square  NULL   NULL   NULL
NULL                                      NULL                                      NULL   NULL   NULL
NULL                                      Nested Geometry Collection                NULL   NULL   NULL
NULL                                      Point middle of Left Square               NULL   NULL   NULL
NULL                                      Point middle of Right Square              NULL   NULL   NULL
NULL                                      Square (left)                             NULL   NULL   NULL
NULL                                      Square (right)                            NULL   NULL   NULL
NULL                                      Square overlapping left and right square  NULL   NULL   NULL
Nested Geometry Collection                Empty GeometryCollection                  false  false  false
Nested Geometry Collection                Empty LineString                          false  false  false
Nested Geometry Collection                Empty Point                               false  false  false
Nested Geometry Collection                Faraway point                             false  false  false
Nested Geometry Collection                Line going through left and right square  true   true   true
Nested Geometry Collection                NULL                                      NULL   NULL   NULL
Nested Geometry Collection                Nested Geometry Collection                true   true   true
Nested Geometry Collection                Point middle of Left Square               false  false  false
Nested Geometry Collection                Point middle of Right Square              false  false  false
Nested Geometry Collection                Square (left)                             true   true   true
Nested Geometry Collection                Square (right)                            true   true   true
Nested Geometry Collection                Square overlapping left and right square  true   true   true
Point middle of Left Square               Empty GeometryCollection                  false  false  false
Point middle of Left Square               Empty LineString                          false  false  false
Point middle of Left Square               Empty Point                               false  false  false
Point middle of Left Square               Faraway point                             false  false  false
Point middle of Left Square               Line going through left and right square  true   true   true
Point middle of Left Square               NULL                                      NULL   NULL   NULL
Point middle of Left Square               Nested Geometry Collection                false  false  false
Point middle of Left Square               Point middle of Left Square               true   true   true
Point middle of Left Square               Point middle of Right Square              false  false  false
Point middle of Left Square               Square (left)                             true   true   true
Point middle of Left Square               Square (right)                            true   true   true
Point middle of Left Square               Square overlapping left and right square  true   true   true
Point middle of Right Square              Empty GeometryCollection                  false  false  false
Point middle of Right Square              Empty LineString                          false  false  false
Point middle of Right Square              Empty Point                               false  false  false
Point middle of Right Square              Faraway point                             false  false  false
Point middle of Right Square              Line going through left and right square  true   true   true
Point middle of Right Square              NULL                                      NULL   NULL   NULL
Point middle of Right Square              Nested Geometry Collection                false  false  false
Point middle of Right Square              Point middle of Left Square               false  false  false
Point middle of Right Square              Point middle of Right Square              true   true   true
Point middle of Right Square              Square (left)                             true   true   true
Point middle of Right Square              Square (right)                            true   true   true
Point middle of Right Square              Square overlapping left and right square  true   true   true
Square (left)                             Empty GeometryCollection                  false  false  false
Square (left)                             Empty LineString                          false  false  false
Square (left)                             Empty Point                               false  false  false
Square (left)                             Faraway point                             false  false  false
Square (left)                             Line going through left and right square  true   true   true
Square (left)                             NULL                                      NULL   NULL   NULL
Square (left)                             Nested Geometry Collection                true   true   true
Square (left)                             Point middle of Left Square               true   true   true
Square (left)                             Point middle of Right Square              true   true   true
Square (left)                             Square (left)                             true   true   true
Square (left)                             Square (right)                            true   true   true
Square (left)                             Square overlapping left and right square  true   true   true
Square (right)                            Empty GeometryCollection                  false  false  false
Square (right)                            Empty LineString                          false  false  false
Square (right)                            Empty Point                               false  false  false
Square (right)                            Faraway point                             false  false  false
Square (right)                            Line going through left and right square  true   true   true
Square (right)                            NULL                                      NULL   NULL   NULL
Square (right)                            Nested Geometry Collection                true   true   true
Square (right)                            Point middle of Left Square               true   true   true
Square (right)                            Point middle of Right Square              true   true   true
Square (right)                            Square (left)                             true   true   true
Square (right)                            Square (right)                            true   true   true
Square (right)                            Square overlapping left and right square  true   true   true
Square overlapping left and right square  Empty GeometryCollection                  false  false  false
Square overlapping left and right square  Empty LineString                          false  false  false
Square overlapping left and right square  Empty Point                               false  false  false
Square overlapping left and right square  Faraway point                             false  false  false
Square overlapping left and right square  Line going through left and right square  true   true   true
Square overlapping left and right square  NULL                                      NULL   NULL   NULL
Square overlapping left and right square  Nested Geometry Collection                true   true   true
Square overlapping left and right square  Point middle of Left Square               true   true   true
Square overlapping left and right square  Point middle of Right Square              true   true   true
Square overlapping left and right square  Square (left)                             true   true   true
Square overlapping left and right square  Square (right)                            true   true   true
Square overlapping left and right square  Square overlapping left and right square  true   true   true

# ST_Segmentize
query TTT
SELECT
  dsc,
  ST_AsText(ST_Segmentize(geog, 100000)),
  ST_AsText(ST_Segmentize(geog, 50000))
FROM geog_operators_test
ORDER BY dsc
----
Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                                                                       GEOMETRYCOLLECTION EMPTY
Empty LineString                          LINESTRING EMPTY                                                                               LINESTRING EMPTY
Empty Point                               POINT EMPTY                                                                                    POINT EMPTY
Faraway point                             POINT (5 5)                                                                                    POINT (5 5)
Line going through left and right square  LINESTRING (-0.5 0.5, -0 0.500019038226216, 0.5 0.5)                                           LINESTRING (-0.5 0.5, -0.250000000362479 0.500014278647005, -0 0.500019038226216, 0.250000000362479 0.500014278647005, 0.5 0.5)
NULL                                      NULL                                                                                           NULL
Nested Geometry Collection                GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))                                          GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))
Point middle of Left Square               POINT (-0.5 0.5)                                                                               POINT (-0.5 0.5)
Point middle of Right Square              POINT (0.5 0.5)                                                                                POINT (0.5 0.5)
Square (left)                             POLYGON ((-1 0, -0.5 0, 0 0, 0 0.5, 0 1, -0.5 1.000038070652873, -1 1, -1 0.5, -1 0))          POLYGON ((-1 0, -0.75 0, -0.5 0, -0.25 0, 0 0, 0 0.25, 0 0.5, 0 0.75, 0 1, -0.249999998550193 1.000028552944327, -0.5 1.000038070652873, -0.750000001449807 1.000028552944326, -1 1, -1 0.75, -1 0.5, -1 0.25, -1 0))
Square (right)                            POLYGON ((0 0, 0.5 0, 1 0, 1 0.5, 1 1, 0.5 1.000038070652873, 0 1, 0 0.5, 0 0))                POLYGON ((0 0, 0.25 0, 0.5 0, 0.75 0, 1 0, 1 0.25, 1 0.5, 1 0.75, 1 1, 0.750000001449807 1.000028552944327, 0.5 1.000038070652873, 0.249999998550193 1.000028552944327, 0 1, 0 0.75, 0 0.5, 0 0.25, 0 0))
Square overlapping left and right square  POLYGON ((-0.1 0, 0.45 0, 1 0, 1 0.5, 1 1, 0.45 1.000046065796834, -0.1 1, -0.1 0.5, -0.1 0))  POLYGON ((-0.1 0, 0.175 0, 0.45 0, 0.725 0, 1 0, 1 0.25, 1 0.5, 1 0.75, 1 1, 0.725000001929716 1.000034549281259, 0.45 1.000046065796834, 0.174999998070284 1.000034549281259, -0.1 1, -0.1 0.75, -0.1 0.5, -0.1 0.25, -0.1 0))

# ST_Buffer
query TTTT
SELECT
  a.dsc,
  ST_AsEWKT(ST_Buffer(a.geog, 10), 5),
  ST_AsEWKT(ST_Buffer(a.geog, 10, 2), 5),
  ST_AsEWKT(ST_Buffer(a.geog, 10, 'quad_segs=4 endcap=flat'), 5)
FROM geog_operators_test a
ORDER BY a.dsc
----
Empty GeometryCollection                  SRID=4326;POLYGON EMPTY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      SRID=4326;POLYGON EMPTY                                                                                                                                                                                      SRID=4326;POLYGON EMPTY
Empty LineString                          SRID=4326;POLYGON EMPTY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      SRID=4326;POLYGON EMPTY                                                                                                                                                                                      SRID=4326;POLYGON EMPTY
Empty Point                               SRID=4326;POLYGON EMPTY                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      SRID=4326;POLYGON EMPTY                                                                                                                                                                                      SRID=4326;POLYGON EMPTY
Faraway point                             SRID=4326;POLYGON ((5.00009 5, 5.00009 4.99998, 5.00008 4.99997, 5.00007 4.99995, 5.00006 4.99994, 5.00005 4.99992, 5.00003 4.99992, 5.00002 4.99991, 5 4.99991, 4.99998 4.99991, 4.99997 4.99992, 4.99995 4.99992, 4.99994 4.99994, 4.99992 4.99995, 4.99992 4.99997, 4.99991 4.99998, 4.99991 5, 4.99991 5.00002, 4.99992 5.00003, 4.99993 5.00005, 4.99994 5.00006, 4.99995 5.00008, 4.99997 5.00008, 4.99998 5.00009, 5 5.00009, 5.00002 5.00009, 5.00003 5.00008, 5.00005 5.00008, 5.00006 5.00006, 5.00008 5.00005, 5.00008 5.00003, 5.00009 5.00002, 5.00009 5))                                                                                      SRID=4326;POLYGON ((5.00009 5, 5.00006 4.99994, 5 4.99991, 4.99994 4.99994, 4.99991 5, 4.99994 5.00006, 5 5.00009, 5.00006 5.00006, 5.00009 5))                                                              SRID=4326;POLYGON EMPTY
Line going through left and right square  SRID=4326;POLYGON ((0.5 0.50009, 0.50002 0.50009, 0.50003 0.50008, 0.50005 0.50008, 0.50006 0.50006, 0.50007 0.50005, 0.50008 0.50003, 0.50009 0.50002, 0.50009 0.5, 0.50009 0.49998, 0.50008 0.49997, 0.50007 0.49995, 0.50006 0.49994, 0.50005 0.49992, 0.50003 0.49992, 0.50002 0.49991, 0.5 0.49991, -0.5 0.49991, -0.50002 0.49991, -0.50003 0.49992, -0.50005 0.49992, -0.50006 0.49994, -0.50007 0.49995, -0.50008 0.49997, -0.50009 0.49998, -0.50009 0.5, -0.50009 0.50002, -0.50008 0.50003, -0.50007 0.50005, -0.50006 0.50006, -0.50005 0.50008, -0.50003 0.50008, -0.50002 0.50009, -0.5 0.50009, 0.5 0.50009))                                 SRID=4326;POLYGON ((0.5 0.50009, 0.50006 0.50006, 0.50009 0.5, 0.50006 0.49994, 0.5 0.49991, -0.5 0.49991, -0.50006 0.49994, -0.50009 0.5, -0.50006 0.50006, -0.5 0.50009, 0.5 0.50009))                     SRID=4326;POLYGON ((0.5 0.50009, 0.5 0.49991, -0.5 0.49991, -0.5 0.50009, 0.5 0.50009))
NULL                                      NULL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         NULL                                                                                                                                                                                                         NULL
Nested Geometry Collection                SRID=4326;POLYGON ((0.00009 0, 0.00009 -0.00002, 0.00008 -0.00003, 0.00007 -0.00005, 0.00006 -0.00006, 0.00005 -0.00008, 0.00003 -0.00008, 0.00002 -0.00009, -0 -0.00009, -0.00002 -0.00009, -0.00003 -0.00008, -0.00005 -0.00008, -0.00006 -0.00006, -0.00007 -0.00005, -0.00008 -0.00003, -0.00009 -0.00002, -0.00009 -0, -0.00009 0.00002, -0.00008 0.00003, -0.00007 0.00005, -0.00006 0.00006, -0.00005 0.00008, -0.00003 0.00008, -0.00002 0.00009, -0 0.00009, 0.00002 0.00009, 0.00003 0.00008, 0.00005 0.00008, 0.00006 0.00006, 0.00007 0.00005, 0.00008 0.00003, 0.00009 0.00002, 0.00009 0))                                                     SRID=4326;POLYGON ((0.00009 0, 0.00006 -0.00006, -0 -0.00009, -0.00006 -0.00006, -0.00009 -0, -0.00006 0.00006, -0 0.00009, 0.00006 0.00006, 0.00009 0))                                                     SRID=4326;POLYGON EMPTY
Point middle of Left Square               SRID=4326;POLYGON ((-0.49991 0.5, -0.49991 0.49998, -0.49992 0.49997, -0.49993 0.49995, -0.49994 0.49994, -0.49995 0.49992, -0.49997 0.49992, -0.49998 0.49991, -0.5 0.49991, -0.50002 0.49991, -0.50003 0.49992, -0.50005 0.49992, -0.50006 0.49994, -0.50007 0.49995, -0.50008 0.49997, -0.50009 0.49998, -0.50009 0.5, -0.50009 0.50002, -0.50008 0.50003, -0.50007 0.50005, -0.50006 0.50006, -0.50005 0.50008, -0.50003 0.50008, -0.50002 0.50009, -0.5 0.50009, -0.49998 0.50009, -0.49997 0.50008, -0.49995 0.50008, -0.49994 0.50006, -0.49993 0.50005, -0.49992 0.50003, -0.49991 0.50002, -0.49991 0.5))                                           SRID=4326;POLYGON ((-0.49991 0.5, -0.49994 0.49994, -0.5 0.49991, -0.50006 0.49994, -0.50009 0.5, -0.50006 0.50006, -0.5 0.50009, -0.49994 0.50006, -0.49991 0.5))                                           SRID=4326;POLYGON EMPTY
Point middle of Right Square              SRID=4326;POLYGON ((0.50009 0.5, 0.50009 0.49998, 0.50008 0.49997, 0.50007 0.49995, 0.50006 0.49994, 0.50005 0.49992, 0.50003 0.49992, 0.50002 0.49991, 0.5 0.49991, 0.49998 0.49991, 0.49997 0.49992, 0.49995 0.49992, 0.49994 0.49994, 0.49993 0.49995, 0.49992 0.49997, 0.49991 0.49998, 0.49991 0.5, 0.49991 0.50002, 0.49992 0.50003, 0.49993 0.50005, 0.49994 0.50006, 0.49995 0.50008, 0.49997 0.50008, 0.49998 0.50009, 0.5 0.50009, 0.50002 0.50009, 0.50003 0.50008, 0.50005 0.50008, 0.50006 0.50006, 0.50007 0.50005, 0.50008 0.50003, 0.50009 0.50002, 0.50009 0.5))                                                                            SRID=4326;POLYGON ((0.50009 0.5, 0.50006 0.49994, 0.5 0.49991, 0.49994 0.49994, 0.49991 0.5, 0.49994 0.50006, 0.5 0.50009, 0.50006 0.50006, 0.50009 0.5))                                                    SRID=4326;POLYGON EMPTY
Square (left)                             SRID=4326;POLYGON ((-1.00009 -0, -1.00009 1, -1.00009 1.00002, -1.00008 1.00003, -1.00007 1.00005, -1.00006 1.00006, -1.00005 1.00008, -1.00003 1.00008, -1.00002 1.00009, -1 1.00009, 0 1.00009, 0.00002 1.00009, 0.00003 1.00008, 0.00005 1.00008, 0.00006 1.00006, 0.00007 1.00005, 0.00008 1.00003, 0.00009 1.00002, 0.00009 1, 0.00009 0, 0.00009 -0.00002, 0.00008 -0.00003, 0.00007 -0.00005, 0.00006 -0.00006, 0.00005 -0.00008, 0.00003 -0.00008, 0.00002 -0.00009, 0 -0.00009, -1 -0.00009, -1.00002 -0.00009, -1.00003 -0.00008, -1.00005 -0.00008, -1.00006 -0.00006, -1.00007 -0.00005, -1.00008 -0.00003, -1.00009 -0.00002, -1.00009 -0))     SRID=4326;POLYGON ((-1.00009 -0, -1.00009 1, -1.00006 1.00006, -1 1.00009, 0 1.00009, 0.00006 1.00006, 0.00009 1, 0.00009 0, 0.00006 -0.00006, 0 -0.00009, -1 -0.00009, -1.00006 -0.00006, -1.00009 -0))     SRID=4326;POLYGON ((-1.00009 -0, -1.00009 1, -1.00008 1.00003, -1.00006 1.00006, -1.00003 1.00008, -1 1.00009, 0 1.00009, 0.00003 1.00008, 0.00006 1.00006, 0.00008 1.00003, 0.00009 1, 0.00009 0, 0.00008 -0.00003, 0.00006 -0.00006, 0.00003 -0.00008, 0 -0.00009, -1 -0.00009, -1.00003 -0.00008, -1.00006 -0.00006, -1.00008 -0.00003, -1.00009 -0))
Square (right)                            SRID=4326;POLYGON ((-0.00009 0, -0.00009 1, -0.00009 1.00002, -0.00008 1.00003, -0.00007 1.00005, -0.00006 1.00006, -0.00005 1.00008, -0.00003 1.00008, -0.00002 1.00009, -0 1.00009, 1 1.00009, 1.00002 1.00009, 1.00003 1.00008, 1.00005 1.00008, 1.00006 1.00006, 1.00007 1.00005, 1.00008 1.00003, 1.00009 1.00002, 1.00009 1, 1.00009 -0, 1.00009 -0.00002, 1.00008 -0.00003, 1.00007 -0.00005, 1.00006 -0.00006, 1.00005 -0.00008, 1.00003 -0.00008, 1.00002 -0.00009, 1 -0.00009, -0 -0.00009, -0.00002 -0.00009, -0.00003 -0.00008, -0.00005 -0.00008, -0.00006 -0.00006, -0.00007 -0.00005, -0.00008 -0.00003, -0.00009 -0.00002, -0.00009 0))      SRID=4326;POLYGON ((-0.00009 0, -0.00009 1, -0.00006 1.00006, -0 1.00009, 1 1.00009, 1.00006 1.00006, 1.00009 1, 1.00009 -0, 1.00006 -0.00006, 1 -0.00009, -0 -0.00009, -0.00006 -0.00006, -0.00009 0))      SRID=4326;POLYGON ((-0.00009 0, -0.00009 1, -0.00008 1.00003, -0.00006 1.00006, -0.00003 1.00008, -0 1.00009, 1 1.00009, 1.00003 1.00008, 1.00006 1.00006, 1.00008 1.00003, 1.00009 1, 1.00009 -0, 1.00008 -0.00003, 1.00006 -0.00006, 1.00003 -0.00008, 1 -0.00009, -0 -0.00009, -0.00003 -0.00008, -0.00006 -0.00006, -0.00008 -0.00003, -0.00009 0))
Square overlapping left and right square  SRID=4326;POLYGON ((-0.10009 0, -0.10009 1, -0.10009 1.00002, -0.10008 1.00003, -0.10007 1.00005, -0.10006 1.00006, -0.10005 1.00008, -0.10003 1.00008, -0.10002 1.00009, -0.1 1.00009, 1 1.00009, 1.00002 1.00009, 1.00003 1.00008, 1.00005 1.00008, 1.00006 1.00006, 1.00007 1.00005, 1.00008 1.00003, 1.00009 1.00002, 1.00009 1, 1.00009 -0, 1.00009 -0.00002, 1.00008 -0.00003, 1.00007 -0.00005, 1.00006 -0.00006, 1.00005 -0.00008, 1.00003 -0.00008, 1.00002 -0.00009, 1 -0.00009, -0.1 -0.00009, -0.10002 -0.00009, -0.10003 -0.00008, -0.10005 -0.00008, -0.10006 -0.00006, -0.10007 -0.00005, -0.10008 -0.00003, -0.10009 -0.00002, -0.10009 0))  SRID=4326;POLYGON ((-0.10009 0, -0.10009 1, -0.10006 1.00006, -0.1 1.00009, 1 1.00009, 1.00006 1.00006, 1.00009 1, 1.00009 -0, 1.00006 -0.00006, 1 -0.00009, -0.1 -0.00009, -0.10006 -0.00006, -0.10009 0))  SRID=4326;POLYGON ((-0.10009 0, -0.10009 1, -0.10008 1.00003, -0.10006 1.00006, -0.10003 1.00008, -0.1 1.00009, 1 1.00009, 1.00003 1.00008, 1.00006 1.00006, 1.00008 1.00003, 1.00009 1, 1.00009 -0, 1.00008 -0.00003, 1.00006 -0.00006, 1.00003 -0.00008, 1 -0.00009, -0.1 -0.00009, -0.10003 -0.00008, -0.10006 -0.00006, -0.10008 -0.00003, -0.10009 0))

# ST_Intersection for geography
query TT
SELECT
  dsc,
  st_asewkt(st_intersection(a, b), 5)
FROM ( VALUES
  ('empty', 'POINT EMPTY'::geography, 'POINT EMPTY'::geography),
  ('non intersecting', 'POINT (1.5 1.5)'::geography, 'POINT (1.6 1.6)'::geography),
  ('intersecting', 'LINESTRING (0 0, 1 1)'::geography, 'LINESTRING (0 1, 1 0)'::geography)
) t(dsc, a, b)
----
empty             SRID=4326;GEOMETRYCOLLECTION EMPTY
non intersecting  SRID=4326;POINT EMPTY
intersecting      SRID=4326;POINT (0.50019 0.50006)

# ST_Centroid for Geography
query TTT
SELECT
  a.dsc,
  ST_AsEWKT(ST_Centroid(a.geog, false)),
  ST_AsEWKT(ST_Centroid(a.geog, true))
FROM geog_operators_test a
WHERE a.dsc != 'Nested Geometry Collection' -- unhandled in ST_Centroid, like in PostGIS.
ORDER BY a.dsc
----
Empty GeometryCollection                  SRID=4326;GEOMETRYCOLLECTION EMPTY                      SRID=4326;GEOMETRYCOLLECTION EMPTY
Empty LineString                          SRID=4326;GEOMETRYCOLLECTION EMPTY                      SRID=4326;GEOMETRYCOLLECTION EMPTY
Empty Point                               SRID=4326;GEOMETRYCOLLECTION EMPTY                      SRID=4326;GEOMETRYCOLLECTION EMPTY
Faraway point                             SRID=4326;POINT (5 5)                                   SRID=4326;POINT (5 5)
Line going through left and right square  SRID=4326;POINT (0 0.500019038226216)                   SRID=4326;POINT (0 0.500019038226216)
NULL                                      NULL                                                    NULL
Point middle of Left Square               SRID=4326;POINT (-0.5 0.5)                              SRID=4326;POINT (-0.5 0.5)
Point middle of Right Square              SRID=4326;POINT (0.5 0.5)                               SRID=4326;POINT (0.5 0.5)
Square (left)                             SRID=4326;POINT (-0.499999999033419 0.500006343417203)  SRID=4326;POINT (-0.500000083989543 0.500006428376563)
Square (right)                            SRID=4326;POINT (0.500000000966581 0.500006343417203)   SRID=4326;POINT (0.499999916010457 0.500006428376563)
Square overlapping left and right square  SRID=4326;POINT (0.45000000128654 0.500010341293701)    SRID=4326;POINT (0.449999907835107 0.50001042625301)

statement error st_centroid\(\): unhandled geography type GeometryCollection
SELECT ST_Centroid('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING EMPTY)'::geography, true)

query T
SELECT ST_AsText(ST_Segmentize('MULTIPOINT (0 0, 1 1)'::geography, -1))
----
MULTIPOINT (0 0, 1 1)

statement error st_segmentize\(\): maximum segment length must be positive
SELECT ST_Segmentize('POLYGON((0.0 0.0, 1.0 0.0, 1.0 1.0, 0.0 1.0, 0.0 0.0))'::geography, 0)

query TTT
SELECT
  dsc,
  ST_AsText(ST_Segmentize(geom, 1)),
  ST_AsText(ST_Segmentize(geom, 0.3))
FROM geom_operators_test
ORDER BY dsc
----
Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY                                      GEOMETRYCOLLECTION EMPTY
Empty LineString                          LINESTRING EMPTY                                              LINESTRING EMPTY
Empty Point                               POINT EMPTY                                                   POINT EMPTY
Faraway point                             POINT (5 5)                                                   POINT (5 5)
Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)                                LINESTRING (-0.5 0.5, -0.25 0.5, 0 0.5, 0.25 0.5, 0.5 0.5)
NULL                                      NULL                                                          NULL
Nested Geometry Collection                GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))         GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))
Point middle of Left Square               POINT (-0.5 0.5)                                              POINT (-0.5 0.5)
Point middle of Right Square              POINT (0.5 0.5)                                               POINT (0.5 0.5)
Square (left)                             POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0))                        POLYGON ((-1 0, -0.75 0, -0.5 0, -0.25 0, 0 0, 0 0.25, 0 0.5, 0 0.75, 0 1, -0.25 1, -0.5 1, -0.75 1, -1 1, -1 0.75, -1 0.5, -1 0.25, -1 0))
Square (right)                            POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))                           POLYGON ((0 0, 0.25 0, 0.5 0, 0.75 0, 1 0, 1 0.25, 1 0.5, 1 0.75, 1 1, 0.75 1, 0.5 1, 0.25 1, 0 1, 0 0.75, 0 0.5, 0 0.25, 0 0))
Square overlapping left and right square  POLYGON ((-0.1 0, 0.45 0, 1 0, 1 1, 0.45 1, -0.1 1, -0.1 0))  POLYGON ((-0.1 0, 0.175 0, 0.45 0, 0.725 0, 1 0, 1 0.25, 1 0.5, 1 0.75, 1 1, 0.725 1, 0.45 1, 0.175 1, -0.1 1, -0.1 0.75, -0.1 0.5, -0.1 0.25, -0.1 0))

query T
SELECT ST_AsText(ST_Segmentize('MULTIPOINT (0 0, 1 1)'::geometry, -1))
----
MULTIPOINT (0 0, 1 1)

statement error st_segmentize\(\): maximum segment length must be positive
SELECT ST_Segmentize('POLYGON ((0.0 0.0, 1.0 0.0, 1.0 1.0, 0.0 1.0, 0.0 0.0))'::geometry, -1)

# ST_Force*
query TT
SELECT
  dsc,
  ST_AsEWKT(ST_Force2D(geom))
FROM geom_operators_test
ORDER BY dsc
----
Empty GeometryCollection                  GEOMETRYCOLLECTION EMPTY
Empty LineString                          LINESTRING EMPTY
Empty Point                               POINT EMPTY
Faraway point                             POINT (5 5)
Line going through left and right square  LINESTRING (-0.5 0.5, 0.5 0.5)
NULL                                      NULL
Nested Geometry Collection                GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))
Point middle of Left Square               POINT (-0.5 0.5)
Point middle of Right Square              POINT (0.5 0.5)
Square (left)                             POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0))
Square (right)                            POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))
Square overlapping left and right square  POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0))

subtest st_srid

statement ok
CREATE TABLE geo_st_srid(
  id int primary key,
  geog geography(geometry),
  geom geometry(point)
)

statement ok
INSERT INTO geo_st_srid VALUES
  (1, ST_GeogFromText('SRID=4004;POINT(1.0 2.0)'), ST_GeomFromText('POINT(5.0 5.0)', 0)),
  (2, ST_GeogFromText('SRID=4326;POINT(1.0 2.0)'), ST_GeomFromText('POINT(5.0 5.0)', 4326)),
  (3, ST_SetSRID(ST_GeogFromText('SRID=4326;POINT(1.0 2.0)'), 4004), ST_SetSRID(ST_GeomFromText('POINT(5.0 5.0)', 4326), 3857))

query III
SELECT
  id,
  st_srid(geog),
  st_srid(geom)
FROM geo_st_srid
ORDER BY id
----
1  4004  0
2  4326  4326
3  4004  3857

subtest transform_test

statement ok
CREATE TABLE transform_test(geom geometry); INSERT INTO transform_test VALUES
  ('SRID=4326;POINT(1.0 1.0)'::geometry),
  ('SRID=3857;POINT(1.0 1.0)'::geometry),
  ('SRID=4326;LINESTRING(1.0 1.0, 2.0 2.0)'::geometry),
  ('SRID=3857;LINESTRING(1.0 1.0, 2.0 2.0)'::geometry),
  ('SRID=4326;POLYGON((0.0 0.0, 1.0 0.0, 1.0 1.0, 0.0 1.0, 0.0 0.0))'::geometry),
  ('SRID=3857;POLYGON((0.0 0.0, 1.0 0.0, 1.0 1.0, 0.0 1.0, 0.0 0.0))'::geometry),
  ('SRID=4326;MULTIPOINT((1.0 1.0), (2.0 2.0))'::geometry),
  ('SRID=3857;MULTIPOINT((1.0 1.0), (2.0 2.0))'::geometry),
  ('SRID=4326;MULTILINESTRING((1.0 1.0, 2.0 2.0), (3.0 3.0, 4.0 4.0))'::geometry),
  ('SRID=3857;MULTILINESTRING((1.0 1.0, 2.0 2.0), (3.0 3.0, 4.0 4.0))'::geometry),
  ('SRID=4326;MULTIPOLYGON(((0.0 0.0, 1.0 0.0, 1.0 1.0, 0.0 1.0, 0.0 0.0)))'::geometry),
  ('SRID=3857;MULTIPOLYGON(((0.0 0.0, 1.0 0.0, 1.0 1.0, 0.0 1.0, 0.0 0.0)))'::geometry),
  ('SRID=4326;GEOMETRYCOLLECTION (POINT (40 10),LINESTRING (10 10, 20 20, 10 40))'::geometry),
  ('SRID=3857;GEOMETRYCOLLECTION (POINT (40 10),LINESTRING (10 10, 20 20, 10 40))'::geometry)

# Temporarily do not display full numbers for now, as they can be inaccurate.
# This can be displayed when ST_AsText can have rounding.
query TBB
SELECT
  ST_AsEWKT(a.geom) d,
  ST_Transform(a.geom, 4326) = a.geom,
  ST_Transform(a.geom, 3857) = a.geom
FROM transform_test a
ORDER BY d ASC
----
SRID=3857;GEOMETRYCOLLECTION (POINT (40 10), LINESTRING (10 10, 20 20, 10 40))  false  true
SRID=3857;LINESTRING (1 1, 2 2)                                                 false  true
SRID=3857;MULTILINESTRING ((1 1, 2 2), (3 3, 4 4))                              false  true
SRID=3857;MULTIPOINT (1 1, 2 2)                                                 false  true
SRID=3857;MULTIPOLYGON (((0 0, 1 0, 1 1, 0 1, 0 0)))                            false  true
SRID=3857;POINT (1 1)                                                           false  true
SRID=3857;POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))                                   false  true
SRID=4326;GEOMETRYCOLLECTION (POINT (40 10), LINESTRING (10 10, 20 20, 10 40))  true   false
SRID=4326;LINESTRING (1 1, 2 2)                                                 true   false
SRID=4326;MULTILINESTRING ((1 1, 2 2), (3 3, 4 4))                              true   false
SRID=4326;MULTIPOINT (1 1, 2 2)                                                 true   false
SRID=4326;MULTIPOLYGON (((0 0, 1 0, 1 1, 0 1, 0 0)))                            true   false
SRID=4326;POINT (1 1)                                                           true   false
SRID=4326;POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))                                   true   false

query TBB
SELECT
  ST_AsEWKT(a.geom) d,
  ST_Transform(a.geom, '+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs', '+proj=longlat +datum=WGS84 +no_defs') = a.geom,
  ST_Transform(a.geom, '+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs', 3857) = a.geom
FROM transform_test a
ORDER BY d ASC
----
SRID=3857;GEOMETRYCOLLECTION (POINT (40 10), LINESTRING (10 10, 20 20, 10 40))  false  true
SRID=3857;LINESTRING (1 1, 2 2)                                                 false  true
SRID=3857;MULTILINESTRING ((1 1, 2 2), (3 3, 4 4))                              false  true
SRID=3857;MULTIPOINT (1 1, 2 2)                                                 false  true
SRID=3857;MULTIPOLYGON (((0 0, 1 0, 1 1, 0 1, 0 0)))                            false  true
SRID=3857;POINT (1 1)                                                           false  true
SRID=3857;POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))                                   false  true
SRID=4326;GEOMETRYCOLLECTION (POINT (40 10), LINESTRING (10 10, 20 20, 10 40))  false  false
SRID=4326;LINESTRING (1 1, 2 2)                                                 false  false
SRID=4326;MULTILINESTRING ((1 1, 2 2), (3 3, 4 4))                              false  false
SRID=4326;MULTIPOINT (1 1, 2 2)                                                 false  false
SRID=4326;MULTIPOLYGON (((0 0, 1 0, 1 1, 0 1, 0 0)))                            false  false
SRID=4326;POINT (1 1)                                                           false  false
SRID=4326;POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))                                   false  false

subtest translate_test

query TT
SELECT
  ST_AsText(a.geom) d,
  ST_AsText(ST_Translate(a.geom, 1, 1))
FROM geom_operators_test a
ORDER BY d ASC
----
NULL                                                   NULL
GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))  GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (1 1)))
GEOMETRYCOLLECTION EMPTY                               GEOMETRYCOLLECTION EMPTY
LINESTRING (-0.5 0.5, 0.5 0.5)                         LINESTRING (0.5 1.5, 1.5 1.5)
LINESTRING EMPTY                                       LINESTRING EMPTY
POINT (-0.5 0.5)                                       POINT (0.5 1.5)
POINT (0.5 0.5)                                        POINT (1.5 1.5)
POINT (5 5)                                            POINT (6 6)
POINT EMPTY                                            POINT EMPTY
POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0))           POLYGON ((0.9 1, 2 1, 2 2, 0.9 2, 0.9 1))
POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0))                 POLYGON ((0 1, 1 1, 1 2, 0 2, 0 1))
POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))                    POLYGON ((1 1, 2 1, 2 2, 1 2, 1 1))

query T
SELECT ST_Summary('POINT(0 0)'::geometry)
----
Point[B]

subtest st_summary

query T
SELECT ST_Summary('POINT(0 0)'::geometry)
----
Point[B]

query T
SELECT ST_Summary('SRID=4326;POINT(0 0)'::geometry)
----
Point[BS]

query T
SELECT ST_Summary('POINT(0 0 0)'::geometry)
----
Point[B]

query T
SELECT ST_Summary('POINT(0 0 0 0)'::geometry)
----
Point[B]

query T
SELECT ST_Summary('MULTIPOINT(0 0)'::geometry)
----
MultiPoint[B] with 1 element
  Point[]

query T
SELECT ST_Summary('SRID=4326;MULTIPOINT(0 0)'::geometry)
----
MultiPoint[BS] with 1 element
  Point[S]

query T
SELECT ST_Summary('GEOMETRYCOLLECTION(MULTILINESTRING((0 0, 1 0),(2 0, 4 4)),MULTIPOINT(0 0))'::geometry)
----
GeometryCollection[B] with 2 elements
  MultiLineString[] with 2 elements
    LineString[] with 2 points
    LineString[] with 2 points
  MultiPoint[] with 1 element
    Point[]


query T
SELECT ST_Summary('SRID=4326;GEOMETRYCOLLECTION(MULTILINESTRING((0 0, 1 0),(2 0, 4 4)),MULTIPOINT(0 0))'::geometry)
----
GeometryCollection[BS] with 2 elements
  MultiLineString[S] with 2 elements
    LineString[S] with 2 points
    LineString[S] with 2 points
  MultiPoint[S] with 1 element
    Point[S]

query T
SELECT ST_Summary('POINT(0 0)'::geography)
----
Point[BGS]

query T
SELECT ST_Summary('SRID=4326;POINT(0 0)'::geography)
----
Point[BGS]

query T
SELECT ST_Summary('POINT(0 0 0)'::geography)
----
Point[BGS]

query T
SELECT ST_Summary('POINT(0 0 0 0)'::geography)
----
Point[BGS]

query T
SELECT ST_Summary('MULTIPOINT(0 0)'::geography)
----
MultiPoint[BGS] with 1 element
  Point[GS]

query T
SELECT ST_Summary('SRID=4326;MULTIPOINT(0 0)'::geography)
----
MultiPoint[BGS] with 1 element
  Point[GS]

query T
SELECT ST_Summary('GEOMETRYCOLLECTION(MULTILINESTRING((0 0, 1 0),(2 0, 4 4)),MULTIPOINT(0 0))'::geography)
----
GeometryCollection[BGS] with 2 elements
  MultiLineString[GS] with 2 elements
    LineString[GS] with 2 points
    LineString[GS] with 2 points
  MultiPoint[GS] with 1 element
    Point[GS]


query T
SELECT ST_Summary('SRID=4326;GEOMETRYCOLLECTION(MULTILINESTRING((0 0, 1 0),(2 0, 4 4)),MULTIPOINT(0 0))'::geography)
----
GeometryCollection[BGS] with 2 elements
  MultiLineString[GS] with 2 elements
    LineString[GS] with 2 points
    LineString[GS] with 2 points
  MultiPoint[GS] with 1 element
    Point[GS]

query RR
SELECT
	degrees(ST_Azimuth(ST_Point(25, 45)::geography, ST_Point(75, 90)::geography)) AS degA_B,
	degrees(ST_Azimuth(ST_Point(75, 90)::geography, ST_Point(25, 45)::geography)) AS degB_A
----
0  -130

query R
SELECT ST_Azimuth(ST_Point(0, 0)::geography, ST_Point(0, 0)::geography)
----
NULL

statement error POINT EMPTY
SELECT st_azimuth('0101000020E6100000000000000000F87F000000000000F87F':::GEOGRAPHY::GEOGRAPHY, '0101000020E6100000000000000000F03F000000000000F03F':::GEOGRAPHY::GEOGRAPHY)::FLOAT8

# Test for string arguments being cast to GEOMETRY.
query RTTTR
SELECT
  ST_Area(geom_str),
  ST_AsEWKT(geom_str),
  ST_AsGeoJSON(geom_str),
  ST_AsText(geom_str),
  ST_Length(geom_str)
FROM (VALUES
  ('POLYGON((0 0, 1 0, 1 1, 0 1, 0 0 ))'),
  ('LINESTRING(0 0, 1 1, 2 2)')
) t(geom_str)
----
1  POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))  {"type":"Polygon","coordinates":[[[0,0],[1,0],[1,1],[0,1],[0,0]]]}  POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))  0
0  LINESTRING (0 0, 1 1, 2 2)           {"type":"LineString","coordinates":[[0,0],[1,1],[2,2]]}             LINESTRING (0 0, 1 1, 2 2)           2.82842712474619

# Test for 2+ arguments string arguments which resolve and get cast to GEOMETRY.
query BBRBB
SELECT
  ST_CoveredBy(a, b),
  ST_Covers(a, b),
  ST_Distance(a, b),
  ST_DWithin(a, b, 10),
  ST_Intersects(a, b)
FROM ( VALUES
  ('POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))', 'POINT(1.0 1.0)'),
  ('POINT(3 0)', 'POINT(10 0)'),
  ('POINT(3 0)', 'POINT(100 0)')
) t(a, b)
----
false  true   0   true   true
false  false  7   true   false
false  false  97  false  false

# Test for 2+ string arguments for Geometry where one side of the arguments
# raises an error.
statement error Unknown type: 'ABC'
SELECT ST_Intersects('abc'::string, 'POINT(1 0)'::string)

statement error Unknown type: 'ABC'
SELECT ST_Intersects('POINT(1 0)'::string, 'abc'::string)

subtest scale_test

query TTTT
SELECT
  ST_AsText(a.geom) d,
  ST_AsText(ST_Scale(a.geom, .5 , 2)),
  ST_AsText(ST_Scale(a.geom, 'Point(.25 3)')),
  ST_AsText(ST_Scale(a.geom, 'Point(2 2)', 'Point(1 1)'))
FROM geom_operators_test a
ORDER BY d ASC
----
NULL                                                   NULL                                                   NULL                                                      NULL
GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))  GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))  GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (0 0)))     GEOMETRYCOLLECTION (GEOMETRYCOLLECTION (POINT (-1 -1)))
GEOMETRYCOLLECTION EMPTY                               GEOMETRYCOLLECTION EMPTY                               GEOMETRYCOLLECTION EMPTY                                  GEOMETRYCOLLECTION EMPTY
LINESTRING (-0.5 0.5, 0.5 0.5)                         LINESTRING (-0.25 1, 0.25 1)                           LINESTRING (-0.125 1.5, 0.125 1.5)                        LINESTRING (-2 0, 0 0)
LINESTRING EMPTY                                       LINESTRING EMPTY                                       LINESTRING EMPTY                                          LINESTRING EMPTY
POINT (-0.5 0.5)                                       POINT (-0.25 1)                                        POINT (-0.125 1.5)                                        POINT (-2 0)
POINT (0.5 0.5)                                        POINT (0.25 1)                                         POINT (0.125 1.5)                                         POINT (0 0)
POINT (5 5)                                            POINT (2.5 10)                                         POINT (1.25 15)                                           POINT (9 9)
POINT EMPTY                                            POINT EMPTY                                            POINT EMPTY                                               POINT EMPTY
POLYGON ((-0.1 0, 1 0, 1 1, -0.1 1, -0.1 0))           POLYGON ((-0.05 0, 0.5 0, 0.5 2, -0.05 2, -0.05 0))    POLYGON ((-0.025 0, 0.25 0, 0.25 3, -0.025 3, -0.025 0))  POLYGON ((-1.2 -1, 1 -1, 1 1, -1.2 1, -1.2 -1))
POLYGON ((-1 0, 0 0, 0 1, -1 1, -1 0))                 POLYGON ((-0.5 0, 0 0, 0 2, -0.5 2, -0.5 0))           POLYGON ((-0.25 0, 0 0, 0 3, -0.25 3, -0.25 0))           POLYGON ((-3 -1, -1 -1, -1 1, -3 1, -3 -1))
POLYGON ((0 0, 1 0, 1 1, 0 1, 0 0))                    POLYGON ((0 0, 0.5 0, 0.5 2, 0 2, 0 0))                POLYGON ((0 0, 0.25 0, 0.25 3, 0 3, 0 0))                 POLYGON ((-1 -1, 1 -1, 1 1, -1 1, -1 -1))