Re: Constraints elimination during runtime

On Wed, 2025-04-16 at 11:16 +, Weck, Luis wrote: > 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-o

Constraints elimination during runtime

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 ( val