Is the SQL WHERE clause short-circuit evaluated?

by

ANSI SQL Draft 2003 5WD-01-Framework-2003-09.pdf

6.3.3.3 Rule evaluation order

[…]

Where the precedence is not determined by the Formats or by
parentheses, effective evaluation of expressions is generally
performed from left to right. However, it is
implementation-dependent whether expressions are actually evaluated left to right, particularly when operands or operators might
cause conditions to be raised or if the results of the expressions
can be determined without completely evaluating all parts of the
expression.

More Related Contents:

  1. How can prepared statements protect from SQL injection attacks?
  2. SQL update query using joins
  3. Does the join order matter in SQL?
  4. Case insensitive searching in Oracle
  5. Combining “LIKE” and “IN” for SQL Server [duplicate]
  6. How to use ANY instead of IN in a WHERE clause?
  7. Is there a shortcut for SELECT * FROM?
  8. sql statement error: “column .. does not exist”
  9. How to get difference between two rows for a column field?
  10. Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
  11. How to find the employee with the second highest salary?
  12. SQL Server SELECT into existing table
  13. Rewriting mysql select to reduce time and writing tmp to disk
  14. Including null values in an Apache Spark Join
  15. Can I do a max(count(*)) in SQL?
  16. How to kill a running SELECT statement
  17. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  18. Is there AUTO INCREMENT in SQLite?
  19. INNER JOIN in UPDATE sql for DB2
  20. Why postgres returns unordered data in select query, after updation of row?
  21. How to Alter Constraint
  22. Group by with CLOB in select-statement
  23. SQL Server Operating system error 5: “5(Access is denied.)”
  24. Performance of Cross join with WHERE clause compared to Inner join
  25. Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
  26. Select first record in a One-to-Many relation using left join
  27. How to pass a temp table as a parameter into a separate stored procedure
  28. Operator does not exist: json = json
  29. Editing Record issues in Access / SQL (Write Conflict)
  30. case statement in SQL, how to return multiple variables?

Leave a Comment