[Summary view] [Print] [Text view]

   1  UPDATE {$NAMESPACE}_differential.differential_revision SET
   2    dateCommitted = (
   3      SELECT MIN(dateCreated)
   4      FROM {$NAMESPACE}_differential.differential_comment
   5      WHERE revisionID = differential_revision.id AND action = 'commit'
   6    )
   7    WHERE status = 3 AND dateCommitted IS NULL;