When I specify eight or more values in a WHERE IN clause and execute it, an error occurs.

Is there a limit to the number of values that can be specified in a WHERE IN clause?

↓Error

select * FROM Vendors WHERE (id in (1, 2, 3, 4, 5, 6, 7, 8, 9))

↓Success

select * FROM Vendors WHERE (id in (1, 2, 3, 4, 5, 6, 7, 8))