|
|
|
New logic has been added to improve optimizer strategies for execution plan construction. This logic avoids unnecessary table scans when the scan condition is known to be false because of comparing a field with a value out of the range of possible values for that field. For example:
f1 < -200
when f1 is a tinyint (valid values ‑128...+127).
