After summer 16 upgrade , SOQLs fail to return expected rows if there is a skinny table on queried object
Trailblazer Community

After summer 16 upgrade , SOQLs fail to return expected rows if there is a skinny table on queried object

Apex , Summer 16

Last updated 2021-04-08 ·Reference W-3085778 ·Reported By 28 users

Fixed in version 202500000

Summary
Summer 16 upgraded orgs might see the SOQLs failing to return expected rows and customers might see:

System.QueryException: List has no rows for assignment to SObject

Or if results being assigned to a list, will notice lists being null as no rows returned by SOQL

Repro
SOQL query on an object on which a skinny table was created prior to Summer 16 upgrade

Workaround
Reach out to Support with reference to this known issue and ask for temporarily 'Disabling' the skinny table.

Updates
The fix has been delivered not through a patch release, but through a database update on all instances.

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.