I am not sure if this list is the most appropriate, but I figured I’d share it here…
If a column has a check constraint, such as CHECK (length(value) < 10) or even something like a VARCHAR(10) shouldn’t a query like this become a no-op/false instantly?
create table test_constraint (
value varchar(10) // could be a CHECK constraint also
);
insert into test_constraint values (‘small’);
-- shouldn’t this qual always evaluate to false?
select * from test_constraint where value = ‘way too big to fit anyway’;