Database Documentation wrong

[Jens168]

In an exportet documentation for a database function I get this code for a function:

Code: Select all

DELIMITER $$
CREATE FUNCTION UUID2BIN(_uuid CHAR(36))
  RETURNS BINARY(16)
  DETERMINISTIC
  SQL SECURITY INVOKER
RETURN
        UNHEX(CONCAT(
            SUBSTR(, 15, 4),
            SUBSTR(, 10, 4),
            SUBSTR(,  1, 8),
            SUBSTR(, 20, 4),
            SUBSTR(, 25) ))
$$
DELIMITER ;

(SUBSTR is missing the first parameter.)

"SHOW CREATE FUNCTION UUID2BIN;" shows this:

Code: Select all

CREATE DEFINER=`root`@`%` FUNCTION `UUID2BIN`(_uuid CHAR(36)) RETURNS binary(16)
    DETERMINISTIC
    SQL SECURITY INVOKER
RETURN
        UNHEX(CONCAT(
            SUBSTR(_uuid, 15, 4),
            SUBSTR(_uuid, 10, 4),
            SUBSTR(_uuid,  1, 8),
            SUBSTR(_uuid, 20, 4),
            SUBSTR(_uuid, 25) ))

[alexa]

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.