Description:
use function st_contains to check whether multilinstring A contains multilinestring B, the result is obviously wrong.
multilinstring A: 'MULTILINESTRING((10 10, 20 20 ), (15 15 , 30 15))'
multilinestring B: 'MULTILINESTRING((10 10, 20 20), (60 -60, 30 15))'
How to repeat:
Server version: 8.0.26 Source distribution
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select st_contains(ST_GeomFromText('MULTILINESTRING((10 10, 20 20 ), (15 15 , 30 15))'),ST_GeomFromText('MULTILINESTRING((10 10, 20 20), (60 -60, 30 15))'));
+-------------------------------------------------------------------------------------------------------------------------------------------------------+
| st_contains(ST_GeomFromText('MULTILINESTRING((10 10, 20 20 ), (15 15 , 30 15))'),ST_GeomFromText('MULTILINESTRING((10 10, 20 20), (60 -60, 30 15))')) |
+-------------------------------------------------------------------------------------------------------------------------------------------------------+
| 1 |
+-------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
Description: use function st_contains to check whether multilinstring A contains multilinestring B, the result is obviously wrong. multilinstring A: 'MULTILINESTRING((10 10, 20 20 ), (15 15 , 30 15))' multilinestring B: 'MULTILINESTRING((10 10, 20 20), (60 -60, 30 15))' How to repeat: Server version: 8.0.26 Source distribution Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select st_contains(ST_GeomFromText('MULTILINESTRING((10 10, 20 20 ), (15 15 , 30 15))'),ST_GeomFromText('MULTILINESTRING((10 10, 20 20), (60 -60, 30 15))')); +-------------------------------------------------------------------------------------------------------------------------------------------------------+ | st_contains(ST_GeomFromText('MULTILINESTRING((10 10, 20 20 ), (15 15 , 30 15))'),ST_GeomFromText('MULTILINESTRING((10 10, 20 20), (60 -60, 30 15))')) | +-------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | +-------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.01 sec)