Steps to reproduce:

use zabbix with mysql 8.4 and run

zabbix_agent2 -t mysql.replication.get_slave_status

Result:
mysql.replication.get_slave_status            [m|ZBX_NOTSUPPORTED] [Cannot fetch data: Cannot fetch data: 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 'SLAVE STATUS' at line 1.]

Expected:

'show slave status' deprecated ( https://docs.oracle.com/cd/E17952_01/mysql-8.0-en/show-replica-status.html ) and removed in mysql 8.4. Plugin should use 'show replica status' for mysql 8.0 or recent.