From: Johan De Meersman Date: March 14 2011 3:08pm Subject: Re: "IF" List-Archive: http://lists.mysql.com/mysql/224634 Message-Id: <349caf2c-7435-4347-b205-6c576bf05087@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable ----- Original Message ----- > From: "S=C3=A1ndor Hal=C3=A1sz" > > Does the _function_ 'IF' always evaluate its arguments? or only the > two that it is needful to evaluate? I'm afraid I'm not authoritative on this, but it seems to me that it would = be very very bad if the third, unused expression were to be evaluated - not= only from a performance point of view, but who is to say that that express= ion is not a user-defined function that modifies the database ? -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel