ST_GeomFromText (and ST_GeomFromWKB?) cannot create empty geometries

[Pieter Roggemans]

Hello!

It seems that creating empty geometries from WKT doesn't work, they always end up as NULL.

I'm not 100% sure, but I think I noticed the same problem with WKB in the past (spatialite 5.0.1), but it is not so easy to create a trivial test case while it is not possible to use  ST_GeomFromText() for it :-).

Some examples:

SELECT ST_AsText(ST_GeomFromText('POINT EMPTY'));

Result: NULL

SELECT ST_AsText(ST_GeomFromText('GEOMETRYCOLLECTION EMPTY'));

Result: NULL

SELECT ST_IsEmpty(ST_AsText(ST_GeomFromText('POINT EMPTY')));

Result: -1, should be 1

Regards,

Pieter

[a.fu...@lqt.it]

it's simply another of the peculiarities of SpatiaLite; empty
geometries are not supported and are considered NULL

Like it or not, it's something so deeply rooted that any
attempt to modify it would shatter the entire architecture.

bye Sandro

[Pieter Roggemans]

OK, I'll look for a way around it...

Op zaterdag 7 oktober 2023 om 11:12:59 UTC+2 schreef a.fu...@lqt.it: