For years people were looking for ways to query more than 50.000 records in Salesforce without running into Too many query rows: 50001
. Event doing a COUNT() query was impossible.
By accident, I just did a query on a type with more than 1 million records. In the Query Editor of the Dev Console. And it worked!
When I tried the same in Apex it failed as expected. Why?