User defined variable containing result of `UUID()` returns different result on each select.
To reproduce run in mysql command line client:
set @b := UUID();
|
select @b;
|
select @b;
|
select @b;
|
Below are my results:
MariaDB [test]> set @b := UUID();
|
Query OK, 0 rows affected (0,032 sec)
|
|
MariaDB [test]> select @b;
|
+--------------------------------------+
|
| @b |
|
+--------------------------------------+
|
| 5981fba1-dc91-11ef-91a2-ac1f6b47855a |
|
+--------------------------------------+
|
1 row in set (0,035 sec)
|
|
MariaDB [test]> select @b;
|
+--------------------------------------+
|
| @b |
|
+--------------------------------------+
|
| 59829ca8-dc91-11ef-90e4-0cc47aa9252e |
|
+--------------------------------------+
|
1 row in set (0,042 sec)
|
|
MariaDB [test]> select @b;
|
+--------------------------------------+
|
| @b |
|
+--------------------------------------+
|
| 5981fba1-dc91-11ef-91a2-ac1f6b47855a |
|
+--------------------------------------+
|
1 row in set (0,034 sec)
|
|
MariaDB [test]> select @b;
|
+--------------------------------------+
|
| @b |
|
+--------------------------------------+
|
| 59829ca8-dc91-11ef-90e4-0cc47aa9252e |
|
+--------------------------------------+
|
1 row in set (0,041 sec)
|
|
Bug
Major
