Ingres supports time-based UUIDs on all platforms.
However, on windows, the default is random UUIDs.
This can be changed to time-based UUIDs by setting II_UUID_MAC=TRUE
using ingsetenv.
On older Ingres versions (e.g. 2.6) you might need a patch to support
this.

Gerard


>>> I just got access to my Sun system again, and I see that Ingres II
9.1.0
>>> (su9.us5/119) produces Version 1 UUIDs, as documented! E.g.:
>>
>> I don't like the dissimilar behaviour. I am inclined to say it is a
>> nasty
>> mis-feature if not an outright bug.
>>
>I'd certainly call it a bug.

I certainly won't argue about that.

I do understand the problems that the various different versions of UUID
are
supposed to solve, and each version has its uses. That is presumably
why
they are thought of as different versions of the same thing rather than
successive replacements of a defective solution.

In the short term I want the behaviour of Version 1 UUIDs, so reverting
to
the Unix code for Windows would suit me fine. On the other hand it was
probably changed for a reason, so maybe that's a bigger problem than it
sounds.

In the long term maybe Ingres needs to support all the versions. Who
knows?
Personally, at the moment I don't care about anything except Version 1.
But
whatever happens, the behaviour obviously needs to be consistent across
platforms.

Roy