MySQL Greatest Common Divisor function

gcd.sql

CREATE FUNCTION `GCD`(a INTEGER, b INTEGER) RETURNS int(11) DETERMINISTIC
BEGIN
    DECLARE dividend INT;
    DECLARE divisor INT;
    DECLARE remainder INT;
    SET dividend := GREATEST(a, b);
    SET remainder := LEAST(a, b);
    SET divisor := 1;
    
    WHILE remainder != 0 DO
        SET divisor = remainder;
        SET remainder = MOD(dividend, divisor);
        SET dividend = divisor;
    END WHILE;
    
    RETURN divisor;
END