Anatoly Loy
Results
2
comments of
Anatoly Loy
> This is a typical case, and I suppose the NULL comparison should be removed by the engine here, as this is a simple scenario. In more complex cases, however,...
The Firebird 2.5 makes the same result. The INNER JOIN makes the same result. SELECT COUNT(*) FROM T2 -- 10 000 records JOIN T3 ON T3.T1_ID = NULL -- *...