[
http://tracker.firebirdsql.org/browse/CORE-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Adriano dos Santos Fernandes reopened CORE-3238:
------------------------------------------------
> Makes GEN_UUID return a compliant RFC-4122 UUID.
> ------------------------------------------------
>
> Key: CORE-3238
> URL: http://tracker.firebirdsql.org/browse/CORE-3238
> Project: Firebird Core
> Issue Type: Bug
> Components: Engine
> Affects Versions: 2.5.0, 2.5.1
> Environment: WindowsXP and Linux ubuntu64 10.04 LTS ... and I think
> all
> Reporter: Christoph Theuring
> Assignee: Adriano dos Santos Fernandes
> Fix For: 2.5.2, 3.0 Alpha 1
>
> Attachments: rfc4122.txt
>
>
> In compliance with rfc4122 every UUID gives his (build)version at the 1st
> digit of the 3rd block and ALL generated UUIDs with the same code MUST have
> the SAME digit at this place xxxxxxxx-xxxx-4xxx-xxxx-xxxxxxxxxxxx (this is an
> example for a version 4 UUID)
> The FireBird UUID is a version 4 UUID (?) and must have the digit 4 at this
> place. But
> - every time you generate an UUID THIS digit is different
> - THIS digit is mostly NOT a '4'
> examples of created UUIDs with FireBird 2.5.0 with SELECT
> uuid_to_char(gen_uuid()) FROM RDB$DATABASE;
> A2A1ED80-1824-101D-C7A6-382DB19A57D1 -> seems to be version 1
> AE5E1BCF-E6F2-4D93-5517-B23DDCE6F579 -> seems to be version 4
> FF1259D0-87D6-8787-D926-1F7E162A4FE1 -> no legal version
> 8B0E0580-ED77-360C-7D89-37B69FE1E3C5 -> seems to be a version 3
> Include in my FreeAdhocUDF there are functions to create UUIDs of version 1
> and 4 - and a UDF to read the version from a generated UUID - see
> http://freeadhocudf.org/documentation_english/dok_eng_uuid.html also with a
> description
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
