I haven’t had anything quite that bad, but I’ve had an interview where I was being tested on SQL, but the interviewer didn’t actually know the SQL keywords I used.

It happens. It’s a strong sign you want to work elsewhere anyway. The problem is one of finding the right Elsewhere.