I’ve noticed that quick filtering INT (or BIGINT) columns behaves differently than quick filtering CHAR (or VARCHAR) and other types (like FLOAT).
It seems to me that GCE uses
WHERE col LIKE '%val%' for filtering CHAR, VARCHAR, FLOAT and other types and
WHERE col = val for INT/BIGINT, DECIMAL and possibly other types.
Wouldn’t it be a good idea to maintain uniformity across all quick search filtering, regardless of the type of the field/column? I don’t know if every DBMS supports using the
LIKE operator for every data type, but I think mysql/mariadb does…
I understand that for many things using the ‘equal’ operator with INT fields makes more sense. The problem is that many of us is using BIGINT for codes or small UUIDs and filtering using ‘like’ operator makes more sense.
I also understand that we can have many filtering options/operators in the filter modal window. But is it possible to customize the behaviour of the quick filtering per column/field?
Thanks in advance!