prestodb/presto

ST_Centroid (Java) does not comply with ISO spec

Open

#26,947 建立於 2026年1月12日

在 GitHub 查看
 (3 留言) (0 反應) (0 負責人)Java (15,558 star) (5,240 fork)batch import
buggood first issue

描述

In the ISO spec, ST_Centroid(empty_geometry) returns NULL, but in the Java code it returns an empty geometry. This is fixed for Velox/native in https://github.com/facebookincubator/velox/pull/15985 , but should also be fixed in Java.

Expected Behavior

ST_Centroid(ST_GeometryFromText('LINESTRING EMPTY')) IS NULL

Current Behavior

ST_IsEmpty(ST_Centroid(ST_GeometryFromText('LINESTRING EMPTY')))

Possible Solution

The ST_Centroid function should check for an empty input geometry and return null.

Steps to Reproduce

SELECT ST_Centroid(ST_GeometryFromText('LINESTRING EMPTY'))

貢獻者指南

技術棧
java
領域
databasebackend
議題類型
bug
難度面向新貢獻者的預計實作難度，1 表示很小改動，5 表示專家級工作。
2
預計時間有經驗貢獻者完成調查、實作、測試並準備 pull request 的粗略時間範圍。
under 1 hour
活動狀態議題目前的可參與程度：新鮮、活躍、陳舊、阻塞或等待維護者輸入。
fresh
清晰度議題是否清楚說明預期改動、驗收標準和下一步。
clear
前置要求
JavaSQL geometry functions
新手友善度1-100 的估計分數，表示該議題對首次貢獻者的友善程度。
80
研究方向
The issue references a fix in Velox (https://github.com/facebookincubator/velox/pull/15985). The Java implementation of ST Centroid likely lives in the presto geospatial module. Locate the ST Centroid function, add a check for empty geometry input, and return null as per ISO spec. Review the existing test cases for spatial functions to ensure proper coverage.
ST_Centroid (Java) does not comply with ISO spec · prestodb/presto#26947 | Good First Issue