Today I encountered a serious bug in SQL Server 2012 Developer Edition SP1.
After deploying changes to some indexed views, another (non indexed) view on top of them did not return any data anymore!
After rebuilding the clustered indexes of the indexes views, results appeared!
After pinpointing the root cause of no data:
Following query returned data:
FROM [IndexedView] as I
Next query did not return data (while it should because of the left join):
FROM [IndexedView] AS I
LEFT JOIN [OTHERVIEW] AS O ON I.Id = O.Id
Because of time shortage I could not analyse further. I expect first query accessed based table, while second query accessed the indexed view, but I did not check execution plans.