View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004519 | SymmetricDS | Bug | public | 2020-09-03 15:23 | 2021-05-06 12:56 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.0 | ||||
| Target Version | 3.12.4 | Fixed in Version | 3.12.4 | ||
| Summary | 0004519: Database name with special character like minus sign, fails to create trigger when in same database | ||||
| Description | On MySQL, the database name had a minus (-) sign in the name, which caused trigger creation to fail. org.jumpmind.db.sql.SqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near | ||||
| Steps To Reproduce | create database my-test; | ||||
| Tags | dialect: mysql/mariadb | ||||
| related to | 0004470 | closed | pmarzullo | Database name with special character like minus sign, fails to create trigger when in same database |
| related to | 0004518 | closed | pmarzullo | Database name with special character like minus sign, fails to create trigger when in same database |
| related to | 0004976 | closed | elong | MySQL: Drop trigger silently fails |
|
SymmetricDS: 3.12 b8ba16ac 2020-09-03 11:54:01 Details Diff |
0004519: Database name with special character like minus sign, fails to create trigger |
Affected Issues 0004519 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mysql/MySqlSymmetricDialect.java | Diff File | ||
|
SymmetricDS: 3.12 791bfee9 2020-09-04 13:53:28 Details Diff |
0004519: Database name with special character like minus sign, fails to create trigger |
Affected Issues 0004519 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mysql/MySqlSymmetricDialect.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-09-03 15:23 | pmarzullo | New Issue | |
| 2020-09-03 15:23 | pmarzullo | Status | new => assigned |
| 2020-09-03 15:23 | pmarzullo | Assigned To | => pmarzullo |
| 2020-09-03 15:23 | pmarzullo | Tag Attached: dialect: mysql/mariadb | |
| 2020-09-03 15:24 | pmarzullo | Relationship added | related to 0004470 |
| 2020-09-03 15:24 | pmarzullo | Relationship added | related to 0004518 |
| 2020-09-03 15:53 | pmarzullo | Summary | 0004518: Database name with special character like minus sign, fails to create trigger => Database name with special character like minus sign, fails to create trigger |
| 2020-09-03 15:55 | pmarzullo | Status | assigned => resolved |
| 2020-09-03 15:55 | pmarzullo | Resolution | open => fixed |
| 2020-09-03 15:55 | pmarzullo | Fixed in Version | => 3.12.4 |
| 2020-09-03 16:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 b8ba16ac |
| 2020-09-04 18:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 791bfee9 |
| 2020-09-04 18:24 | pmarzullo | Summary | Database name with special character like minus sign, fails to create trigger => Database name with special character like minus sign, fails to create trigger when in same database |
| 2020-09-23 20:34 | admin | Status | resolved => closed |
| 2021-05-06 12:56 | elong | Relationship added | related to 0004976 |