When trying to execute a query having subqueries, a case switch with joins caused the SQL parser to consume all system memory and eventually crashed the system.
Note: This serious server issue requires the server to be updated if queries having "case then" (searched case) are used.