All pastes #480250 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-05-10 05:25 UTC
rendered paste body
  INSERT INTO FOO 
  .... 
  ON DUPLICATE KEY UPDATE
  FOO.COL_A = NOW() + FOO.COL_B 

/*   WHERE COL_B is '01:00:00'

...... and randomly a number of columns are beign set to 0000-00-00 00:00:00 

... which seems like a bug.

 */