project = AAAA AND affectedVersion > "5.01.01"

The above query will return result affectedVersion later than 5.01.01 (refer screenshot: later_than.png)

project = AAAA AND affectedVersion < "6.01.01"

The above query will return result affectedVersion older than 6.01.01 (refer screenshot: older_than.png)

project = AAAA AND affectedVersion >= "5.01.01" AND affectedVersion < "6.01.01"

The above query should have returned result affectedVersion later than 5.01.01 and older than 6.01.01 which is affectedVersion 5.01.x only. However, the result have issues with multiple affectedVersion, eg 3.13.01, 6.02.17 (refer screenshot: intersect.png)