Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6.11
-
None
Description
MariaDB is complaining about use of variables inside geometry constructor.
-- Define 2 simple points
|
SET @p1=POINT(1, 1), @p2=POINT(2,2); |
|
-- Check their types
|
SELECT ST_GEOMETRYTYPE(@p1), ST_GEOMETRYTYPE(@p2); |
|
-- Try to create a multipoint without variables - works as expected
|
SELECT MULTIPOINT(POINT(1, 1), POINT(2, 2)); |
|
-- Try to create a multipoint with variables - Fail
|
SELECT MULTIPOINT(@p1, @p2); |
-- Fail with message Illegal non geometric '@`p1`' value found during parsing |
Attachments
Issue Links
- duplicates
-
MDEV-27666 User variable not parsed as geometry variable in geometry function
- Closed