M5V2ZUXK

1DROP PROCEDURE IF EXISTS csgRunLoop;
2DROP TABLE IF EXISTS testUUID;
3CREATE TABLE testUUID (id binary(16) PRIMARY KEY);
4
5BEGIN
6DECLARE x, y INT DEFAULT 1;
7
8--  WHILE x  <= 3 DO
9--  INSERT INTO testUUID VALUES(UUID_TO_BIN(UUID()));
10--  SET  x = x + 1; 
11--  END WHILE;
12
13-- Move the two INSERT statments below WHILE loop or run here above WHILE loop 
14-- and the output is not consistent with the order the statements were declared
15   INSERT INTO testUUID VALUES(UUID_TO_BIN('d6c03d84-2eed-4f15-b681-90fe627fcacf'));
16   INSERT INTO testUUID VALUES(UUID_TO_BIN('d6c03d84-2eed-4f15-b681-90fe627fcacf', true));
17
18   WHILE y  <= 3 DO
19   INSERT INTO testUUID VALUES(UUID_TO_BIN(UUID(), true));
20   SET  y = y + 1; 
21   END WHILE;
22
23END$$
24DELIMITER ;
25
26CALL csgRunLoop();
27
28-- time shifted
29SELECT BIN_TO_UUID(id) FROM testUUID;
30
31-- untime shifted
32--SELECT BIN_TO_UUID(id, true) FROM testUUID WHERE id LIKE('%');