SQLでfizzbuzz問題

gistfile1.sql

CREATE DATABASE IF NOT EXISTS test_db;
USE test_db;
CREATE TABLE IF NOT EXISTS unya
    (
        id INT(11),
        message TEXT
    );
DROP PROCEDURE IF EXISTS find_treasure;
DELIMITER //
CREATE PROCEDURE find_treasure()
BEGIN
    DECLARE id int default 1;
    DECLARE text TEXT default null;
    WHILE id <= 100 DO
        CASE
            when mod(id,15)= 0 then set text='fizzbuzz';
            when mod(id,5) = 0 then set text='buzz';
            when mod(id,3) = 0 then set text='fizz';
            else set text = id;
        END CASE;
        INSERT INTO unya VALUES(id,text);
        SET id = id + 1;
    END WHILE;
END;
CALL find_treasure();
SELECT * FROM unya;