I just solved the issue by adding a new index ( not necessary since I was using the clustered one)

the query started working, then I removed the new index and the issue is gone

The table was new and not corrupted, so this was indeed some kind of bug