Re: [Phpwiki-talk] replaced INNER JOIN with LEFT JOIN - still WikiFatalError

[Jeff D. <da...@da...>]

On Fri, 09 Nov 2001 18:46:06 +0100
"Tara Star" <te...@cl...> wrote:

Argh.  Okay, it seems CASE WHEN ... is unsupported in MySQL before
3.23.x.

(And I don't think postgres supports MySQL other conditional operators,
which is why I used the CASE WHEN...)

Try replacing
   CASE WHEN cond THEN val END
by
   IF(cond, val, NULL)

I.e. 
"CASE WHEN minor_edit=0 THEN version END" 
   becomes "IF(minor_edit=0,version,NULL)"
and

"CASE WHEN minor_edit<>0 THEN version END"
  becomes "IF(minor_edit<>0, version, NULL)"

At least you're making progress!

Jeff