weird query behaviour

I’ve solved this issue but I’d love some insight into why I ran into it. Two screenshots show queries on an adId column with the where clause not returning the correct number of rows, I then changed the query to another column to then filter the rows I don’t require which gave me the correct result. I’m using NEON db with Tanstack query and Next JS.