uuid() returns the same value for all uses in a statement

[zachmu]

Like rand(), uuid() should never be evaluated early. It should return a new value for each evaluation.

select uuid(), uuid();
+--------------------------------------+--------------------------------------+
| uuid()                               | uuid()                               |
+--------------------------------------+--------------------------------------+
| e98d77a2-c736-11ec-96cf-e00af64e177e | e98d77b3-c736-11ec-96cf-e00af64e177e |
+--------------------------------------+--------------------------------------+