Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
None
Description
i some query like this
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') |
i got error message like this
Query processor ran out of internal resources and could not produce a query plan
*detail error message on attachment
this error come from limitation mariadb ? when i using " where in () and or in ()" multiple and so much record ??
