Tested with 10.6.11-6-MariaDB server,
rocky linux 8 (also seen at several more RPM-linuxes),
only if spider plugin is enabled during MariaDB server build (cmake -DPLUGIN_SPIDER=YES).

Use any database and any non-existing table name.

DROP TABLE non_existing_table;

• should be:
  ERROR 42S02: Unknown table 'auto_test_local.non_existing_table'
• actual:
  Query OK, 0 rows affected (0.005 sec)

DROP TABLE IF EXISTS non_existing_table;

• should be:
  Warnings: Note 1051 Unknown table 'non_existing_table'
• actual:
  Query OK, 0 rows affected (0.005 sec)