IN clause not working on mysql 8.0.17
Have you tried a simple IN clause other than the one in your code?  If not, I would write a couple simple ones and try them to see if they run.  If they run successfully, it's either you copied it incorrectly, OR it's got to be something specific with how your code is using the IN statement.  

If no IN statements run, something was changed, either by design or it's a bug.