Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
-
None
-
Ubuntu 12.04
MySQL DB 5.5.28
MariaDB JDBC driver 1.0.0
JDK 1.6.0_26
Crystal Report Runtime API
Description
We switched from MySQL JDBC driver to the SkySQL JDBC driver.
No we got a lot of SQLSyntaxExceptions when we execute the "example" query:
<code>SELECT `call`.`call_id` FROM `statistic`.`call` `call`</code>
It seems the problem occurs because the table alias equals the table name. If we change it to (i.e. "e") then it works.
The SQL queries are generated by Crystal Report at run-time so we have no impact. And with the MySQL/Solid/Postgres JDBC driver it works.
I also created a discussion in support forum:
http://www.skysql.com/forums/mysql-database-and-tools/connectors/jdbc-driver-and-sql-query.
There you will also find a short stack-trace.