Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
None
-
None
Description
MariaDB [test]> create or replace table tb1 as SELECT st_validate(POINTFROMTEXT(' POINT( 4 1 ) ')) a ;
|
Query OK, 1 row affected (0,070 sec)
|
Records: 1 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> show create table tb1;
|
+-------+---------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+---------------------------------------------------------------------------------------------------------------------+
|
| tb1 | CREATE TABLE `tb1` (
|
`a` point DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci |
|
+-------+---------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0,001 sec)
|
|
MariaDB [test]> create or replace table tb1 as SELECT st_validate(ST_GeomFromText (' linestring( 4 1,4 4 ) ')) a ;
|
ERROR 1366 (22007): Incorrect POINT value: 'LINESTRING(4 1,4 4)' for column `test`.`tb1`.`a` at row 1
|
|
MariaDB [test]> SELECT (st_validate (ST_collect(( POINTFROMTEXT(' POINT( 4 1 ) ') )) )) a ;
|
+------------------------------------+
|
| a |
|
+------------------------------------+
|
| @ �? |
|
+------------------------------------+
|
1 row in set (0,001 sec)
|
|
MariaDB [test]> create table tb2 as SELECT (st_validate (ST_collect(( POINTFROMTEXT(' POINT( 4 1 ) ') )) )) a ;
|
ERROR 1366 (22007): Incorrect POINT value: 'MULTIPOINT(4 1)' for column `test`.`tb2`.`a` at row 1
|
|
Attachments
Issue Links
- is caused by
-
MDEV-34137 Implement the GIS function ST_Validate
- In Testing