Hi, we have a situation where some queries fail when requesting and explain of them in QAN.
The errors can be categorized in two groups:
Error 1046: No database selected
Example of failing query:
select * from table where arbitrary_no = '11111111'
Error 1064: 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 '‘1111111 …’ at line 1
For some queries like this: (with a very long in clause)
SELECT id FROM table WHERE id in( '5522555', '2224452', '3444434', '5544223', '5653343', '111 ...
We are currently running PMM 2.15.1.
How can we get those queries having their explain working on QAN?