search

wise-coders / dbschema

DbSchema Database Designer
https://dbschema.com
72 stars 3 forks source link

Relationships do not appear in MariaDb if database has a `-` in the name #67

Closed rippo closed 2 years ago

rippo commented 2 years ago

Log error message is

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 '-gateway' at line 1

09:00:48 ==== 2022-04-25 09:00:48 DbSchema #220412 Windows 10 10.0 Java AdoptOpenJDK 15.0.2 ==

The steps to reproduce this issue. create a database using MariaDb and put a dash in the database name. Create 2 tables with a simple one-to-many join

2022-04-25_09-01-09

Perform a "Compare model with the database"

2022-04-25_08-59-09

As you can see the relationships do not appear

Log files

09:05:38 Error occurred during schema reverse engineering. 
  Reasons can be missing rights to select from system tables or query incompatibility 
  ( view Edit / RdbmsSettings / Reverse engineering ). Inform DbSchema team using 
  Help / Technical Support.

java.sql.SQLSyntaxErrorException: (conn=1326) 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 '-gateway' at line 1
  at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:270)
wise-coders commented 2 years ago

Thank you for writing about this. The issue will be fixed right tomorrow. On Wednesday morning a beta update will be available under https://dbschema.com/beta.php The version number will be the same, the build number will increase.

rippo commented 2 years ago

Thanks I can confirm this now works using build 220425