3 ms·
So such issues can appear in more products and more datatypes (int and bigint have same problem). This is really bad rule for SQL's "equality" operator. Still
by Sankozi 7mo ago
So such issues can appear in more products and more datatypes (int and bigint have same problem).
This is really bad rule for SQL's "equality" operator.
Still optimizer should be able to handle it - if the result is the same, optimizer should take faster path.