Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22644

Query processor ran out of internal resources and could not produce a query plan”

    XMLWordPrintable

    Details

      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 ??

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            febridev febriyant
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.