Hello all,

i was just playing with gen_uuid() in firebird 2.1.2

i did the following
add a field to a existing table with a little more then 2 mio record

guid16 varchar(32) charset octets ;



update the table with the uuids

update rechnungszeile z set z.guid16 = gen_uuid() ;



run a select on it

select strlen(z.guid16), count(*) from rechnungszeile z group by 1

should the result not be a stringlength of 16 for all ?

Result
#STRLEN COUNT
0 7917
1 7787
2 7856
3 7698
4 7836
5 7836
6 7749
9 7716
10 7799
11 7651
12 7602
13 7461
14 7523
15 7567
16 1923177




--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...