Re: Should the optimiser convert a CASE into a WHERE if it can?

On Wed, 27 Jan 2010, Віталій Тимчишин wrote:
> How  about SELECT SUM (case when id > 1200000 and id < 1210000 then 1 end)
> from tbl_tracker;

That is very interesting.

> * All the functions should be noop for null input

Alas, not true for COUNT(*), AVG(), etc.

Matthew

--
 An optimist sees the glass as half full, a pessimist as half empty,
 and an engineer as having redundant storage capacity.