I am benchmarking several queries on Aria and Columnstore. Some of these queries take longer on the Columnstore. Hence, I wanted to abort long-running queries using the `max_statement_time` option. I use the Python SQLAlchemy and pymysql library to connect to the database.
When profiling my queries, I have no issues using `max_statement_time` along with Aria Tables. However, I have several issues when I attempt to profile the same queries on the Columnstore tables.
First, a long-running query is aborted and shows as killed in the PROCESSLIST. However, this query doesn't end and stays indefinitely on the server, requiring a restart. Second, I noticed that the `max_statement_time` fails specifically on queries where I have several CTEs, not queries that are simple SELECT statements.
This behaviour is odd as there is no issue for the Aria engine and the same CTE queries alogn with `max_statement_time`.