[Bug] subquey and row number bug in release 2.1.3

[carlaikrypton]

Search before asking

• I had searched in the issues and found no similar issues.

Version

release 2.1.3

What's Wrong?

in release 2.0.3 this sql can work
select vin,file_name from ( select row_number() over **)as subquery WHERE row_num < 10
but after upgrade to 2.1.3 this sql can‘t search any record with the same data
i notice that the last condition is reason
when i set the 'row_num>10' it can work but slowly

what happen in release 2.1.3?

What You Expected?

select vin,file_name from ( select row_number() over **)as subquery WHERE row_num < 10
in release 2.1.3 this sql can‘t search any record
i notice that the last condition is reason
when i set the 'row_num>10' it can work but slowly

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct