On Wed, Jul 06, 2022 at 11:40:22AM +0200, Peter Eisentraut wrote: > On 06.07.22 11:31, Stefan Froehlich wrote: > >I have a database returing these result sets for two almost > >identical queries: > > > >#v+ > >$ select id, pid, length(pid), md5(pid) from product where pid like '8000000'; > >(1 row) > > > >$ select id, pid, length(pid), md5(pid) from product where pid like '%8000000'; > >(2 rows) > >#v- > Check the EXPLAIN output for the two queries. Maybe there is index > corruption somewhere. OMG. Thanks, this was the root of the problem. Never run into this before so it did not come to my mind. Bye, Stefan
