Removing MySQL Orphan Tables in Google's Managed MySQL
Your theory is correct about your cloudSQL since it is a Google managed service. 

If you would like to have full access over your mysql database, you can use it through a Compute Engine instance in which you will have super user privileges. 

Nevertheless, about your current issue please fill a bug here which is under a private component and you can share if there is a need, sensitive information.