Problem in spatial queries in MariaDB

[kndol]

ST_GeomFromText('POINT(longitude latitude)', srid)

is a correct query.
But phpmyadmin makes query with

ST_GeomFromText('\'POINT(longitude latitude)\', srid')

, and the result is null.

• Operating system: UNIX
• Web server:
• Database version: 10.1.13-MariaDB
• PHP version: 7.0.0p1
• phpMyAdmin version: 4.8.5

[williamdes]

@kndol Thanks for the report, totally explains why I could not make the UI work each time I tried !

[williamdes]

[ShailuJain]

Hey @williamdes
I checked into the issue and found that typing 'POINT(1 2)',0 into the text field produces the error but if POINT(1 2),0 is typed there is no error. So how should we proceed with the issue?

[williamdes]

@ShailuJain If all MySQL and MariaDB versions agree that POINT(1 2),0 is a valid syntax then we can safely remove the quotes
If you find some documentation can you post it here ?

[ShailuJain]

In my opinion if POINT(1 2),1 is given the executing query will be
INSERT INTO table_name (id, shape) VALUES (NULL, ST_GeomFromText('POINT(1 2),0'))
which is a valid query and if given 'POINT(1 2)',1,
INSERT INTO table_name (id, shape) VALUES (NULL, ST_GeomFromText('\'POINT(1 2)\',0'))
is produced which is why this error is produced. But then too if a find some documentation i will post it here.