SQL IS BEAUTIFUL

DROP PROCEDURE IF EXISTS sp;
DELIMITER //
CREATE PROCEDURE sp(LABELS_PER_ISSUE INT)
BEGIN
DECLARE MAX_LABEL INT DEFAULT 100000000;
DECLARE x INT;

-- replace by real jira_issue table
DROP TEMPORARY TABLE IF EXISTS issues;
CREATE TEMPORARY TABLE IF NOT EXISTS issues  (
  issueid INT
);

INSERT INTO issues VALUES (1),(2),(3),(4),(5);

-- replace by real labels table

DROP TEMPORARY TABLE IF EXISTS labels;
CREATE TEMPORARY TABLE IF NOT EXISTS labels  (
  id INT,
  issueid INT,
  label VARCHAR(20)
);

DROP TEMPORARY TABLE IF EXISTS timesTemp;
CREATE TEMPORARY TABLE IF NOT EXISTS timesTemp  (
  id INT
);

SET x = 0;

WHILE x<LABELS_PER_ISSUE DO
SET x=x+1;
INSERT INTO timesTemp VALUES (x);
END WHILE;

-- it should be corresponging to last number from seq id, we should increase seq id after this query
SET @row_number = 10000;
-- SET @row_number = (SELECT SEQ_ID FROM SEQUENCE_VALUE_ITEM WHERE SEQ_NAME = 'Label');



-- make inner join correct and align data with sequence ids.
INSERT INTO label SELECT (@row_number:=@row_number+1), NULL, tbl.id, CAST(CAST(RAND() * MAX_LABEL as SIGNED) as CHAR(10))
FROM (SELECT jiraissue.id FROM timesTemp INNER JOIN jiraissue ON 1=1) as tbl;

INSERT INTO SEQUENCE_VALUE_ITEM VALUES ('Label', @row_number);

END//
DELIMITER ;