Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-9

Valid SQL query throws an SQLSyntaxException

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • 1.1.0
    • 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.

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            heiko Heiko Tropartz (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.