Correlated subquery will not build index ranges when the it is contained by a scalar function

[winoros]

Enhancement

We support constructing index ranges with correlated columns. But only support the most simple case col op cor_col.

But we'll fail to do it when the correlated column is contained by a scalar function, like col op cor_col while they have different types. In this case the final expr will become col op cast(cor_col), which will fail to construct index ranges.