The sqlite int space is 64 bits. You'd have to generate 1 billion keys per second for ~600 years to exhaust the space. Is my math right?
Eric > Hello, > > My Primary Key is an integer. In the lifetime of a product, it may > increase to the maximum possible value of an integer. Our processor will > make it overflow into a very large negative number and so on. > > My specific question is, if overflow occurs, how does sqlite deal with > it? > > 1. What if its a large negative number ? > 2. What if there is already a PK with the rolled over value, say 1? > > This maybe a common problem you all may have ran into. Hope you can > help answer. > > Thanks, > Kavita > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Eric A. Smith Aeropalmics (ayr o palm' iks), n.: The study of wind resistance conducted by holding a cupped hand out the car window. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
