L
Laura Stern
Guest
The rationale is that if we can't evaluate the expression we are trying to compare to, we cannot tell if it satisfies the WHERE clause or not. We can't assume the programmer knew what they were doing if they give us something that really can't be evaluated. So just concluding that the record doesn't satisfy the query is a bit dangerous. It is better to give an error and make the programmer give us a valid expression than to give the wrong query results. The results of a query can have significant real-world consequences! We need to be sure the answer is correct.
Continue reading...
Continue reading...