I have a long-running query that I run against a MySQL 8 database via JDBC. My goal is to be able to exit this query on some trigger (e.g. external signal, data processing error, etc.) and have the query cancel. Based on my tests and research on MySQL forums, the statement.cancel() does not actually do anything.