Oh, and separably the has_unread function had a CASE statement which didn't declare a default ELSE handler but did explicitly handle every scenario it could ever encounter. For whatever reason, the lack of an ELSE sometimes caused the query optimiser to throw an error occasionally.
So a few people may have seen Internal Server Error pages since 8pm yestereve, and it is down to the ELSE not being declared. Fixing that appears to have sped things up a little everywhere.
Oh, and separably the
has_unread
function had a CASE statement which didn't declare a default ELSE handler but did explicitly handle every scenario it could ever encounter. For whatever reason, the lack of an ELSE sometimes caused the query optimiser to throw an error occasionally.So a few people may have seen
Internal Server Error
pages since 8pm yestereve, and it is down to the ELSE not being declared. Fixing that appears to have sped things up a little everywhere.