Query fingerprint doesn't match example

Impact on the user:

User getting 2 different presentation about the query. this makes vey big confusion and brakes the trust to the tool because "it's obwious bug, so we don't know what query presentation to trust"

STR:

1. Open QAN

2. Select the first query:
   SELECT `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` AS `events` , `performance_schema` . `events_waits_summary_global_by_event_name` . `COUNT_STAR` AS `total` , `performance_schema` . `events_waits_summary_global_by_event_name` . `SUM_TIMER_WAIT` AS `total_latency` , `performance_schema` . `events_waits_summary_global_by_event_name` . `AVG_TIMER_WAIT` AS `avg_latency` , `performance_schema` . `events_waits_summary_global_by_event_name` . `MAX_TIMER_WAIT` AS `max_latency` FROM `performance_schema` . `events_waits_summary_global_by_event_name` WHERE ( ( `performance_schema` . `events_waits_summary_global_by_event_name` . `EVENT_NAME` != ? ) AND ( `performance_schema` . `events_waits_summary_global_by_event_name` . `SUM_TIMER_WAIT` > ? ) ) ORDER BY `performance_schema` . `events_waits_summary_global_by_event_name` . `SUM_TIMER_WAIT` DESC

3. Open Examples tab

Actual result:

select
table_schema,
table_name,
table_type,
ifnull(engine, 'none') as engine,
ifnull(version, '0') as version,
ifnull(row_format, 'none') as row_format,
ifnull(table_rows, '0') as table_rows,
ifnull(data_length, '0') as data_length,
ifnull(index_length, '0') as index_length,
ifnull(data_free, '0') as data_free,
ifnull(create_options, 'none') as create_options
from
information_schema.tables
where
table_schema = 'sys'

Expected result:

Example and fingerprint should not be different

***
Observed only with perfshema
Seems to be affecting only 3 MySQL specific queries:

Found the same issue also in PMM1. Same query with perfschema and slowlog - see attachments.

DOD:

 - all queries much theirs fingerprints.

Suggested fix:

• Use method to create fingerprint (same as for slowlog) if query example does not much query fingerprint in performance schema

• The "fix" will slow down our agent

• There is no trusted bug fix!

• Problem is on MySQL side

• Problem exists with some system queries