Error executing SQL statement #186
Description
Database: MySQL 8
Is there a way of debugging or getting more detail of what may be causing this error?
The SQL is valid as it runs both within the host application and from an SQL Query Tool
I can trace the code to the following line of pyJasperReport code but I cannot see beyond this because it goes into the Jasper Java packages.
self.jasper_print = self.jvJasperFillManager.fillReport(self.jasper_report, parameters, con)
Is there anyway to get more detail from the Java side? The SQL looks fine visually and runs as expected in numerous toolsets