For those who would be curious, I made another table with the same columns but no primary key, transferred everything to it, shifted the value, flushed the original table, and reinserted everything back. I'm looking for something less... moronic?
–
MPelletierMar 18 '11 at 15:36

And yes, shifting a primary key is suspicious, I agree. It was a time field that was off by a few hours. I know, I feel dirty.
–
MPelletierMar 18 '11 at 15:37

OMG. Are you using a time field as your primary key? Definitely not a good idea. Probably best to use an auto sequence integer as the PK, and keep the time in a separate field. I suppose SQLLite doesn't take care of updating primary keys, many main-stream RDBMS will not have prob with your UPDATE query. Nevertheless, it is an embedded database, so it may not have all the features of mainstream products.
–
Stephen ChungMar 18 '11 at 15:52

@StephenChung: In my defense, the database is not my design. I'm just a victim.
–
MPelletierMar 18 '11 at 15:59

@StephenChung: And in the real-life case, that key is a two-fielder...
–
MPelletierMar 18 '11 at 16:02