Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-1931

Support Sub Queries in Query Analytics for MySQL

    Details

      Description

      1. Install PMM 1.5.3
      2. Enable MySQL QAN monitoring
      3. Try to execute query with subquery , for example
        SELECT  ID, NAME    FROM CUSTOMERS    INNER JOIN  (SELECT OID from ORDERS as ORDERS) go ON CUSTOMERS.ID = CUSTOMERS.ID
        

        Result: QAN doesn't show this query and there is an error in qan-api.log:

        WARN: query crashes sqlparser: SELECT  ID, NAME    FROM CUSTOMERS    INNER JOIN  (SELECT OID from ORDERS as ORDERS) go ON CUSTOMERS.ID = CUSTOMERS.ID
        

      Expected result: QAN shows the query

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  nailya.kutlubaeva Nailya Kutlubaeva
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated: