From 4d4fc2eaa18f2c643d95684022e424bd7441eef3 Mon Sep 17 00:00:00 2001
From: Martin Willi <martin@strongswan.org>
Date: Tue, 13 May 2008 07:39:24 +0000
Subject: fixed "pool --purge" on mysql

---
 src/charon/plugins/sql/pool.c | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/charon/plugins/sql')

diff --git a/src/charon/plugins/sql/pool.c b/src/charon/plugins/sql/pool.c
index 136c7e16f..709c18c12 100644
--- a/src/charon/plugins/sql/pool.c
+++ b/src/charon/plugins/sql/pool.c
@@ -308,7 +308,7 @@ static void purge(char *name)
 	{
 		purged = db->execute(db, NULL,
 					"DELETE FROM leases WHERE pool = ? "
-					"AND released NOTNULL AND released < ?",
+					"AND released IS NOT NULL AND released < ?",
 					DB_UINT, id, DB_UINT, time(NULL) - timeout);
 	}
 	query->destroy(query);
-- 
cgit v1.2.3