Subject RE: [firebird-support] Re: The only user
Author Simon Carter
> -----Original Message-----
> 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.

I just tested this and if you create a generator and set it to
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/