Concaternar valores en una funcion.

[RIVERMILLOS]

Creo que deberia ir asi

Código MySQL:

-- Switch delimiter so the ; will work in the function body
DELIMITER $$
 
-- Create the function
CREATE FUNCTION distance (a double, b double) RETURNS double
    DETERMINISTIC
    COMMENT 'Calculate the distance between two points'
    BEGIN
        RETURN GLength(GeomFromText('linestring(', a ,',', b ,')'));
    END$$
 
-- Switch the delimiter back to ;
DELIMITER ;
 

Pero me sale un error al crear la funcion


Script line: 5 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '',', b ,')'));
END' at line 5


que puede ser?


saludos