ST_AddPoint wants a LINESTRING as input

[gpetit]

I'm using the last snapshot downloaded here https://github.com/orbisgis/h2gis/actions/runs/15487102470

I was checking the documentation of ST_AddPoint (source code) and I discovered that there is a problem when executing the examples.

All SQL instructions where the input IS NOT a LINESTRING returns this error message

First argument must be a LINESTRING; SQL statement

Example

SELECT ST_AddPoint('POLYGON((1 1, 1 5, 5 5, 5 1, 1 1),
                            (2 2, 4 2, 4 4, 2 4, 2 2))',
                   'POINT(3 3)', 1);

gives

First argument must be a LINESTRING; SQL statement:
SELECT ST_AddPoint('POLYGON((1 1, 1 5, 5 5, 5 1, 1 1),
                            (2 2, 4 2, 4 4, 2 4, 2 2))',
                   'POINT(3 3)', 1) [0-232] null/0 [(Aide)](https://h2database.com/javadoc/org/h2/api/ErrorCode.html#c0)

Linked with #1416

[ebocher]

That is the expected behavior. St_AddPoint works only with a LINESTRING. To add a point on a polygon uses ST_InsertPoint (https://github.com/orbisgis/h2gis/blob/master/h2gis-functions/src/main/java/org/h2gis/functions/spatial/edit/ST_InsertPoint.java)
hummm... It seems there is not doc for this function ;((