[#MDEV-22644] Query processor ran out of internal resources and could not produce a query plan”

SELECT COUNT(loan_payment) as setcolumn FROM table1 WHERE paydate between {d '2020-05-01'} and {d '2020-05-31'} and period_code = 'MONTHLY' AND company_id = 11111 AND ( emp_id IN ('DO2071406','DO2073897','DO2073464','DO2071522','DO2071400','DO2071401','DO2071402','DO2071403','DO2073538','DO2074215','DO2074233','DO2070850','DO2071618','DO2070442','DO2071741','DO2071739','DO2071740','DO2071751') OR emp_id IN ('DO2071406','DO2073897','DO2073464','DO2071522','DO2071400','DO2071401','DO2071402','DO2071403','DO2073538','DO2074215','DO2074233','DO2070850','DO2071618','DO2070442','DO2071741','DO2071739','DO2071740','DO2071751')OR emp_id IN ('DO2071406','DO2073897','DO2073464','DO2071522','DO2071400','DO2071401','DO2071402','DO2071403','DO2073538','DO2074215','DO2074233','DO2070850','DO2071618','DO2070442','DO2071741','DO2071739','DO2071740','DO2071751')OR emp_id IN ('DO2071406','DO2073897','DO2073464','DO2071522','DO2071400','DO2071401','DO2071402','DO2071403','DO2073538','DO2074215','DO2074233','DO2070850','DO2071618','DO2070442','DO2071741','DO2071739','DO2071740','DO2071751')

this error come from limitation mariadb ? when i using " where in () and or in ()" multiple and so much record ??

[MDEV-22644] Query processor ran out of internal resources and could not produce a query plan” Created: 2020-05-20 Updated: 2020-06-28 Resolved: 2020-06-28
Status:	Closed
Project:	MariaDB Server
Component/s:	Data Manipulation - Subquery
Affects Version/s:	None
Fix Version/s:	N/A

[MDEV-22644] Query processor ran out of internal resources and could not produce a query plan” Created: 2020-05-20 Updated: 2020-06-28 Resolved: 2020-06-28