Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.13, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
-
Darwin crest.fritz.box 17.4.0 Darwin Kernel Version 17.4.0: Sun Dec 17 09:19:54 PST 2017; root:xnu-4570.41.2~1/RELEASE_X86_64 x86_64
Description
The following code returns one uuid with count 10 instead of 10 uuids with count 1 for each line.
mysql test --execute 'select count(1), uuid() as uid from seq_0_to_9 group by uid;'
|
This seems as if the uuid function is only ever actually called once, instead of once for each element in the sequence.
This does not happen fi you leave of the group by like this:
mysql yeepa_test --execute 'select seq, uuid() as uid from seq_0_to_9;'
|
To my understanding this is wrong and the sequence should return 10 uuids with a count of one each.
Attachments
Issue Links
- relates to
-
MDEV-15624 Changing the default character set to utf8mb4 changes query evaluation in a very surprising way
- Closed