Subject | RE: [firebird-support] Re: The only user |
---|---|
Author | Simon Carter |
Post date | 2005-07-25T17:33:43Z |
> -----Original Message-----I just tested this and if you create a generator and set it to
> Neither. It goes to 2,147,483,649. A generator is a BigInt
> and will roll over when it surpasses
> 9,223,372,036,854,775,808 - around the same time as Hell freezes over.
9223372036854775806 then use gen_id(gen, 1) it goes to
9223372036854775807
-9223372036854775808
-9223372036854775807
Etc, etc. So it doesn't just roll over to 0 which is good news (imo), and
it never reaches 9223372036854775808 so hell should never freeze over :-)
Rgds
Si Carter
http://www.fbtalk.net/
http://www.tectsoft.net/