It is successfully working on my end. So, in your situation, I would troubleshoot this issue by performing the below steps:
1. I would check whether the incremental cache join condition has been applied on the primary key defined on the base view.
2. Then, I would analyze the execution trace in detail to check the SQL sentences that has been applied on the data source as well as cache and then would check the join condition that has applied to fetch the records.
4. If the above options are unsuccessful, then I would change the cache mode to Full Cache and check if it works fine (for both selecting the full view i.e., "select * from <view>" as well as selecting particular fields of the view "select column1, column2 from <view>)
Hope this helps!