demdxx

-- for calculation of norm vector --
DELIMITER $$

CREATE FUNCTION vector_norm( vector JSON )
RETURNS DOUBLE
READS SQL DATA
DETERMINISTIC
BEGIN
  DECLARE array_length INTEGER(11);
  DECLARE retval DOUBLE(19,2);