The WHERE clause (col1 = 11) is not returning the row whereas (col1 > 10.99 and col1 < 11.01) is returning the row. This happens in the context of a larger query-
SELECT .... FROM ... WHERE ... AND EXISTS(SELECT 1 FROM tab1 WHERE .... correlated conditions ... AND col1 = 11)
SELECT * FROM tab1 WHERE col1 = 11
returns the row.
Has anyone else come across this behavior?
Does this have something to do with storage indexes?
How should we proceed?