Functions That Test Spatial Relations Between Geometry Objects • ST_HausdorffDistance( g1 ,  g2  [,  unit ]) Returns the discrete Hausdorff distance between two geometries, reflecting how similar the geometries are. The result is a double-precision number measured in the length unit of the spatial reference system (SRS) of the geometry arguments, or in the length unit of the  unit  argument if that argument is given. This function implements the discrete Hausdorff distance, which means it is restricted to distances between the points of the geometries. For example, given two  LineString  arguments, only the points explicitly mentioned in the geometries are considered. Points on the line segments between these points are not considered. ST_HausdorffDistance()  handles its geometry arguments as described in the introduction to this section, with these exceptions: •If the geometry arguments are in the same Cartesian or geographic SRS, but are not in a supported combination, an  ER_NOT_IMPLEMENTED_FOR_CARTESIAN_SRS  or ER_NOT_IMPLEMENTED_FOR_GEOGRAPHIC_SRS  error occurs, depending on the SRS type. These combinations are supported: • LineString  and  LineString • Point  and  MultiPoint • LineString  and  MultiLineString • MultiPoint  and  MultiPoint • MultiLineString  and  MultiLineString ST_HausdorffDistance()  handles its optional  unit  argument as described in the introduction to this section. This function was added in MySQL 8.0.23. Returns 1 or 0 to indicate whether  g1  spatially intersects  g2 . • ST_Intersects( g1 ,  g2 ) 2329 +----------------------------------+ | ST_HausdorffDistance(@ls1, @ls2) | +----------------------------------+ | 1 | +----------------------------------+ +----------------------------------+ | ST_HausdorffDistance(@ls1, @ls2) | +----------------------------------+ | 111319.49079326246 | +----------------------------------+ +------------------------------------------+ | ST_HausdorffDistance(@ls1, @ls2, ’foot’) | +------------------------------------------+ | 365221.4264870815 | +------------------------------------------+ mysql>  SET @ls1 = ST_GeomFromText(’LINESTRING(0 0,0 5,5 5)’); mysql>  SET @ls2 = ST_GeomFromText(’LINESTRING(0 1,0 6,3 3,5 6)’); mysql>  SELECT ST_HausdorffDistance(@ls1, @ls2); mysql>  SET @ls1 = ST_GeomFromText(’LINESTRING(0 0,0 5,5 5)’, 4326); mysql>  SET @ls2 = ST_GeomFromText(’LINESTRING(0 1,0 6,3 3,5 6)’, 4326); mysql>  SELECT ST_HausdorffDistance(@ls1, @ls2); mysql>  SELECT ST_HausdorffDistance(@ls1, @ls2, ’foot’);