"Axel Tietje" <[EMAIL PROTECTED]> wrote:
> Hi everyone...
>
> I actually have two servers:
>
> 1. Server: MySQL 4.0.12
> 2. Server: MySQL 3.23.38
>
> This query:
>
> SELECT o_obj,
> MAX(CASE WHEN o_key = '69B96431' THEN o_val END) AS _69B96431,
> MAX(CASE WHEN o_key = '69B96431' TH
Some of the values passed to the CASE expressions are NULL.
There was a bug in handling NULL in CASE that was fixed in
MySQL 4.0.8:
http://www.mysql.com/doc/en/News-4.0.8.html
Note the last item on the page. I believe this explains the
differences that you are seeing.
At 16:28 +0200 6/12/03, Axel
Hi everyone...
I actually have two servers:
1. Server: MySQL 4.0.12
2. Server: MySQL 3.23.38
This query:
SELECT o_obj,
MAX(CASE WHEN o_key = '69B96431' THEN o_val END) AS _69B96431,
MAX(CASE WHEN o_key = '69B96431' THEN o_typ END) AS T_69B96431,
MAX(CASE WHEN o_key = 'AA0
