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

Syntax error RENAME TABLE

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 3.0.4, 3.0.5
    • N/A
    • 2.7 compatibility
    • None
    • MariaDB 10.4.18 Docker Image

    Description

      Using MariaDB Java Client version 3.0.4 (and latest Spring Data JPA/Hibernate), we get following exception:

      java.sql.SQLSyntaxErrorException: (conn=8) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'RENAME TABLE x_partial TO x' at line 1
      	at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:270)
      	at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:358)
      	at org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:133)
      	at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:815)
      	at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:754)
      	at org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:673)
      	at org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:616)
      	at org.mariadb.jdbc.Statement.executeInternal(Statement.java:906)
      	at org.mariadb.jdbc.Statement.execute(Statement.java:1031)
      	at org.mariadb.jdbc.Statement.execute(Statement.java:441)
      	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
      	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
      	at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:422)
      	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)

      Was working with MariaDB Java Client 2.7.5 (and all older 2.x versions).

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            pneyer Patrick Neyer
            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.