Description:
The "user" table is renamed to "SYSTEM_USER" in DIGEST_TEXT of performance_schema.events_statements_history when performing operations on the "user" table
How to repeat:
CREATE DATABASE db1;
USE db1;
CREATE TABLE user(id int not null AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE user2(id int not null AUTO_INCREMENT PRIMARY KEY);
INSERT INTO user() VALUES();
UPDATE user SET id = -1;
DELETE FROM user;
INSERT INTO user2() VALUES();
UPDATE user2 SET id = -1;
DELETE FROM user2;
SELECT SQL_TEXT, DIGEST_TEXT FROM performance_schema.events_statements_history;
+----------------------------------------------------------------+--------------------------------------------------------------------------------+
| SQL_TEXT | DIGEST_TEXT |
+----------------------------------------------------------------+--------------------------------------------------------------------------------+
| UPDATE user SET id = -1 | UPDATE SYSTEM_USER SET `id` = - ? |
| DELETE FROM user | DELETE FROM SYSTEM_USER |
| INSERT INTO user2() VALUES() | INSERT INTO `user2` ( ) VALUES ( ) |
| UPDATE user2 SET id = -1 | UPDATE `user2` SET `id` = - ? |
| DELETE FROM user2 | DELETE FROM `user2` |
| show databases | SHOW SCHEMAS |
| show tables | SHOW TABLES |
| CREATE TABLE user(id int not null AUTO_INCREMENT PRIMARY KEY) | CREATE TABLE SYSTEM_USER ( `id` INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ) |
| CREATE TABLE user2(id int not null AUTO_INCREMENT PRIMARY KEY) | CREATE TABLE `user2` ( `id` INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ) |
| INSERT INTO user() VALUES() | INSERT INTO SYSTEM_USER ( ) VALUES ( ) |
+----------------------------------------------------------------+--------------------------------------------------------------------------------+