Re: CASE in where statement. BUG ??

Csaba Nagy wrote:
> Because that's a syntax check, which does NOT evaluate any of the
> expressions, only the types of them. Even if it will not be executed
> ever, it is still wrong, and it should generate an error, because it
> means a mistake on your side which potentially could leave to results
> you didn't expect if executed as is.
> If it would not generate error in these cases, you would scream when you
> by mistake write a wrong query and it doesn't give you the right errors.
> Say thanks to the parser that it catches your errors and doesn't let you
> do detective work to find out why your queries are not working as you
> expect them to work.

Maybe you are right. Thanks.

>
> Cheers,
> Csaba.
>
>
>
>