In this post, you’ll learn more about the MariaDB Error 1104 ER_TOO_BIG_SELECT with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1104 – ER_TOO_BIG_SELECT with the sqlState 42000
Error Description for the MariaDB Error ER_TOO_BIG_SELECT
The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay