Bug #117129 Potential bug in ST_Crosses

• Submitted: 8 Jan 6:33
• Modified: 8 Jan 7:15
• Reporter: shijie li
• Status: Verified
• Category: MySQL Server: GIS
• Severity: S3 (Non-critical)
• Version: 8.0.40
• OS: Any
• CPU Architecture: Any

[8 Jan 6:33] shijie li

Description:
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-object-
shapes.html#function_st-crosses
It is specifically pointed out that,ST_Crosses() will return NULL when g1 is of dimension 2 (Polygon or MultiPolygon) or g2 is of dimension 1 (Point or MultiPoint). 

But when I tested with a Linestring whose dimension is 1, it returns T.

How to repeat:
SET @g1 = ST_GeomFromText ('LINESTRING (0 0, 4 4)');
SET @g2 = ST_GeomFromText ('LINESTRING (4 0, 0 4)');
SELECT ST_Crosses(@g1, @g2), ST_Dimension(@g1), ST_Dimension(@g2);

-- result:{t, 1, 1}

Suggested fix:
This should be a document description error, the dimension of the point should be 0.

[8 Jan 7:15] MySQL Verification Team

Hello shijie li,

Thank you for the report and feedback.

regards,
Umesh