[ASTERIXDB-3067] NullPointerException thrown while applying spatial predicates on 'GeometryCollection' type geometry object

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.8
• Component/s: FUN - Functions
• Assignee: Unassigned
• Reporter: Tomal Majumder
• Created: 22/Aug/22 21:26
• Updated: 23/Aug/22 18:43

Description

It throws  java.lang.NullPointerException running the following query:

DROP  DATAVERSE GISTest IF EXISTS;
CREATE  DATAVERSE GISTest;
USE GISTest;
 
CREATE TYPE GeometryType AS {   id : int,   g : geometry };
 
CREATE DATASET Geometries (GeometryType) PRIMARY KEY id;

INSERT INTO Geometries ([
{"id": 1, "g": st_geom_from_text('POINT(40 10)')},
{"id": 2, "g": st_geom_from_text('GEOMETRYCOLLECTION (POINT (40 10),LINESTRING (10 10, 20 20, 10 40),POLYGON ((40 40, 20 45, 45 30, 40 40)))')}
]);

USE GISTest;
SELECT id, st_intersects(g, st_make_point(40, 10)) from Geometries;
 

The result should be:

{ "id": 1, "$1": true }

{ "id": 2, "$1": true }

 Instead the output reports the following exceprtion:
java.lang.NullPointerException: Cannot invoke "com.esri.core.geometry.Geometry.getType()" because "geometry_a" is null [HyracksDataException]