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

Query fingerprint is displayed incorrectly when using UNION ALL

    Details

    • Type: Bug
    • Status: Open
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: 1.8.1, 1.14.1
    • Fix Version/s: None
    • Component/s: QAN Agent, QAN App
    • Labels:

      Description

      The fingerprint when using a UNION ALL statement leads to the word ALL running into the next SELECT.

      Actual query executed:

      select sleep(1) union all select pk from t1 where c2='c';

      Current 1.8.1 display:

      Current record from query_classes:

      mysql> select * from query_classes where checksum ='B8ED92A9D0851273';
      +----------------+------------------+-----------------+--------------------------------------------------------+--------+---------------------+---------------------+--------+
      | query_class_id | checksum | abstract | fingerprint | tables | first_seen | last_seen | status |
      +----------------+------------------+-----------------+--------------------------------------------------------+--------+---------------------+---------------------+--------+
      | 227 | B8ED92A9D0851273 | SELECT UNION t1 | select sleep(?) union all select pk from t? where c?=? | | 2018-03-14 20:35:00 | 2018-03-14 21:07:00 | new |
      +----------------+------------------+-----------------+--------------------------------------------------------+--------+---------------------+---------------------+--------+
      1 row in set (0.00 sec)

      Expected fingerprint:

      select sleep(?) union all select pk from t? where c?=?;

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                michael.coburn@percona.com Michael Coburn
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: