summaryrefslogtreecommitdiff
path: root/lib/Multi/IRC.pm
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-10-24 15:52:08 +0200
committerYorhel <git@yorhel.nl>2009-10-24 15:52:08 +0200
commit705d661d27287b2f7c6548e8764ab7a1291f5d83 (patch)
treefe222add784714b78fb4f62f3fb828cd72d1d89e /lib/Multi/IRC.pm
parent5251f791de0a0e1684107b373a08cfe3a17fc447 (diff)
Multi::IRC: Fixed SQL syntax error
Introduced in 69d8738688ebb72707fe377b7ce7c717407aea96
Diffstat (limited to 'lib/Multi/IRC.pm')
-rw-r--r--lib/Multi/IRC.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/Multi/IRC.pm b/lib/Multi/IRC.pm
index 4225e6b8..359e8e4b 100644
--- a/lib/Multi/IRC.pm
+++ b/lib/Multi/IRC.pm
@@ -266,7 +266,7 @@ sub notify { # name, pid, payload
return if !$_[HEAP]{$k};
my $q = $_[ARG0] eq 'newrevision' ? q|SELECT
- CASE WHEN c.type, c.rev, c.comments, c.id AS lastrev,
+ c.type, c.rev, c.comments, c.id AS lastrev,
COALESCE(vr.vid, rr.rid, pr.pid) AS id, COALESCE(vr.title, rr.title, pr.name) AS title, u.username
FROM changes c
LEFT JOIN vn_rev vr ON c.type = 'v' AND c.id = vr.id