Re: Should this query raise an exception?

> "Steve Kass" <skass_at_drew.edu> wrote in message
> news:3D5D361B.C4E72171_at_drew.edu...
> select
> 1/a as R,
> b
> from t

If an expression doesn't need to be evaluated, then it's implementation-defined whether it shall be evaluated. For example, in this case, it's up to the vendor to decide whether to return with divide-by-zero or with the result, which doesn't depend on that division.

Peter Gulutzan

Co-producer of THE OCELOT SQL DBMS, which returns a result (download from sourceforge.net/projects/ocelot)

Co-author of SQL-99 Complete, Really

Co-author of SQL Performance Tuning:
http://ourworld.compuserve.com/homepages/ocelotsql/tuning.htm Received on Sat Aug 17 2002 - 11:44:50 CDT