No result on * but result with explicit colums (probably related to window function)

I had a strange behavoir on one of my  Sql server (Azure) query:   select TOP 10 * from custom.View_Migration_LastState where [status] = N'Created'   Return 0 row.   select top 10 [emai...