Compatability with Percona Server 8.0.36-28

Hi there,

Is it planned compatibility with Percona server ? I tried running the sql files on the above Percona server version and only create_user_and_db.sql was executed without errors .

mysql> \s
--------------
mysql  Ver 8.0.36-28 for Linux on x86_64 (Percona Server (GPL), Release '28', Revision '47601f19'$)

Connection id:      24443
Current database:   
Current user:       admin@localhost
SSL:            Not in use
Current pager:      stdout
Using outfile:      ''
Using delimiter:    ;
Server version:     8.0.36-28 Percona Server (GPL), Release '28', Revision '47601f19'$
Protocol version:   10
Connection:     Localhost via UNIX socket
Server characterset:    utf8mb3
Db     characterset:    utf8mb3
Client characterset:    utf8mb4
Conn.  characterset:    utf8mb4
UNIX socket:        /var/lib/mysql/mysql.sock
Binary data as:     Hexadecimal
Uptime:         1 day 3 hours 41 min 50 sec

Threads: 5  Questions: 1324244  Slow queries: 62  Opens: 890508  Flush tables: 7  Open tables: 4096  Queries per second avg: 13.280
--------------

mysql> \! ls -l /root/dbstat
total 76
-rw-r--r-- 1 root root 18092 Mar 15 11:26 LICENSE
-rw-r--r-- 1 root root  4041 Mar 15 11:26 README.md
-rw-r--r-- 1 root root  1076 Mar 15 11:26 create_global_status.sql
-rw-r--r-- 1 root root  1657 Mar 15 11:26 create_global_variables.sql
-rw-r--r-- 1 root root  2899 Mar 15 11:26 create_metadata_lock.sql
-rw-r--r-- 1 root root  1569 Mar 15 11:26 create_processlist.sql
-rw-r--r-- 1 root root  1617 Mar 15 11:26 create_table_size.sql
-rw-r--r-- 1 root root  2653 Mar 15 11:26 create_trx_and_lck.sql
-rw-r--r-- 1 root root   479 Mar 15 11:26 create_user_and_db.sql
-rw-r--r-- 1 root root  2307 Mar 15 11:26 query_global_status.sql
-rw-r--r-- 1 root root   236 Mar 15 11:26 query_global_variables.sql
-rw-r--r-- 1 root root   281 Mar 15 11:26 query_metadata_lock.sql
-rw-r--r-- 1 root root   986 Mar 15 11:26 query_processlist.sql
-rw-r--r-- 1 root root  1246 Mar 15 11:26 query_table_size.sql
-rw-r--r-- 1 root root   547 Mar 15 11:26 query_trx_and_lck.sql
mysql> source /root/dbstat/create_user_and_db.sql;
Query OK, 0 rows affected (0.02 sec)

Query OK, 1 row affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> use dbstat;
Database changed
mysql> source /root/dbstat/create_global_status.sql;
Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EVENT gather_global_status
ON SCHEDULE EVERY 1 MINUTE
DO
BEGIN
  INSERT INTO `gl' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EVENT purge_global_status
ON SCHEDULE EVERY 1 MINUTE
DO
BEGIN
  DELETE FROM `glo' at line 1
mysql> source /root/dbstat/create_global_variables.sql;
Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EVENT gather_global_variables
ON SCHEDULE EVERY 1 MINUTE
DO
BEGIN
  DECLARE done' at line 1
mysql>

Obviously the create event part is not working correctly and the event is not created in the DB. Please advise, thank you.

FromDual / dbstat

Compatability with Percona Server 8.0.36-28 #1