incubator-lokahi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tob...@apache.org
Subject svn commit: r584916 - /incubator/lokahi/lokahi/trunk/database/mysql/procs.sql
Date Mon, 15 Oct 2007 20:59:05 GMT
Author: toback
Date: Mon Oct 15 13:59:04 2007
New Revision: 584916

URL: http://svn.apache.org/viewvc?rev=584916&view=rev
Log:
Replaced Sysdate with Now() for mysql compatability.

Re: https://issues.apache.org/jira/browse/LOKAHI-2

Patch by Ludovic MaƮtre.



Re

Modified:
    incubator/lokahi/lokahi/trunk/database/mysql/procs.sql

Modified: incubator/lokahi/lokahi/trunk/database/mysql/procs.sql
URL: http://svn.apache.org/viewvc/incubator/lokahi/lokahi/trunk/database/mysql/procs.sql?rev=584916&r1=584915&r2=584916&view=diff
==============================================================================
--- incubator/lokahi/lokahi/trunk/database/mysql/procs.sql (original)
+++ incubator/lokahi/lokahi/trunk/database/mysql/procs.sql Mon Oct 15 13:59:04 2007
@@ -2194,7 +2194,7 @@
 	IF V_STATEID >= CURRENTSTATE THEN
 		BEGIN
     			UPDATE TMC_JOB
-			SET STATE_ID=V_STATEID, FINISH_TIME=SYSDATE
+			SET STATE_ID=V_STATEID, FINISH_TIME=NOW()
 			WHERE JOB_ID=V_PK;
 			SET RETURNVAL = 1;
 		END;



Mime
View raw message