[Bug] where condition a in ('A', 'B', 'V') and a in A') return error result 

**Describe the bug**
As the titile

This is a bug introduce by #4999 

As the same time. The Class of `ColumnRangeValue` and `Olap Scan Node` with a lot of inefficient, unreasonable code, we should take advantage of this opportunity to do a small refactoring to make the code more readable and efficient.
