Bug #100883 Performance Schema - Statement Tables - Digest is Null in Stored Procedures

• Submitted: 17 Sep 2020 19:21
• Modified: 22 Sep 2020 12:02
• Reporter: Pravdomil Toman
• Status: Can't repeat
• Category: MySQL Server: Performance Schema
• Severity: S3 (Non-critical)
• Version: 8.0.12
• OS: Linux
• CPU Architecture: Any

[17 Sep 2020 19:21] Pravdomil Toman

Description:
Running simple select in stored procedure does not produce digest for sql_text in events_statements_history table.

How to repeat:
# Run in db-fiddle.com (do not forget to choose MySQL 8).

##########################
DELIMITER ;;
CREATE PROCEDURE TEST()
BEGIN
    SELECT 12345;
END;;
DELIMITER ;

#
TRUNCATE TABLE performance_schema.events_statements_history;

#
SELECT 12345;

#
CALL TEST;

#
SELECT SQL_TEXT, DIGEST_TEXT, DIGEST
FROM performance_schema.events_statements_history
WHERE SQL_TEXT LIKE '%12345%';

#
#SELECT *
#FROM performance_schema.setup_actors;

#
#SELECT *
#FROM performance_schema.setup_consumers;

#
#SELECT *
#FROM performance_schema.setup_objects;

##########################

Suggested fix:
Compute digest in the same way as outside procedures.

[22 Sep 2020 12:02] MySQL Verification Team

Hi Mr. Toman,

Thank you for your bug report, however, I can't repeat the problem that you are reporting.

I am, of course, using our latest release for bug fixing, which is 8.0.21.

This is what I get:

+-------+
| 12345 |
+-------+
| 12345 |
+-------+
+-------+
| 12345 |
+-------+
| 12345 |
+-------+
+--------------+-------------+------------------------------------------------------------------+
| SQL_TEXT     | DIGEST_TEXT | DIGEST                                                           |
+--------------+-------------+------------------------------------------------------------------+
| SELECT 12345 | SELECT ?    | d1b44b0c19af710b5a679907e284acd2ddc285201794bc69a2389d77baedddae |
| SELECT 12345 | NULL        | NULL                                                             |
+--------------+-------------+------------------------------------------------------------------+