Hi,
Thank you very much for the details, it helped a lot!
Luckily the issue was very minor, the index table engine was not selected, and the regular engine was not sufficient to execute the request. I switched to the index table engine (much better and faster), now it should be okay.