From cad7e814d7f14e84d8ccf3836dde93b86af28138 Mon Sep 17 00:00:00 2001
From: Magnus Hagander <magnus@hagander.net>
Date: Wed, 4 Mar 2009 16:08:06 +0100
Subject: [PATCH] Dept of really stupid. COALESCE works the other way..

---
 gitdump.py | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/gitdump.py b/gitdump.py
index a04ae91..bdb9236 100644
--- a/gitdump.py
+++ b/gitdump.py
@@ -45,10 +45,10 @@ class AuthorizedKeysDumper(object):
 		curs = self.db.cursor()
 		curs.execute("""
 SELECT name,anonymous,web,description,initialclone,
-		COALESCE('',
+		COALESCE(
 		(SELECT min(first_name) FROM repository_permissions AS rp
 			LEFT JOIN auth_user AS au ON au.username=rp.userid
-			WHERE rp.level=2 AND rp.repository=r.repoid)),
+			WHERE rp.level=2 AND rp.repository=r.repoid),''),
 		 CASE WHEN EXISTS
 			(SELECT * FROM remoterepositories WHERE remoterepositories.id=r.remoterepository_id)
 		 THEN 1 ELSE 0 END
-- 
2.39.5