[Dbix-class] Lazy Columns

Peter Rabbitson rabbit+dbic at rabbit.us
Wed May 12 08:08:23 GMT 2010


Bill Moseley wrote:
> 
> Is this the "blanket increment/decrement" that's referring to?
> 
> sqlite> update track set pos = pos - 1 where cd = 1 and pos > 2;
> 

No need for where conds and the like. The most minimal test case is
to create a table with 1 column, with a unique constraint, and put
in the numbers 1..5. Then try:

UPDATE tab SET col = col + 1;

and

UPDATE tab SET col = col - 1;

On sqlite (at least) on of these fails. Not sure for other databases,
never had the time to test.



More information about the DBIx-Class mailing list