View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003726 | SymmetricDS | Bug | public | 2018-09-18 16:11 | 2022-08-01 18:58 |
| Reporter | josh-a-hicks | Assigned To | JJ_Starrett | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.10.4 | Fixed in Version | 3.10.4 | ||
| Summary | 0003726: Delete or truncate should quote table name and include catalog/schema | ||||
| Description | While requesting a delete first or truncate first load the wildcard to replace table %s does replace with a fully qualified table name (catalog.schema.table) but does not quote it if necessary. The Table.java getter for the fully qualified name does provide the proper logic but the load events do not. | ||||
| Tags | initial/partial load | ||||
|
|
Per Josh, confirmed. |
|
|
Perhaps a better solution would be to implement a more generic way to do the truncate. |
|
|
Seems to work fine for the truncate case, but not the 'delete from %s' case. |
|
|
Example I tested was on H2 using the following table: create table "bar!foo" (id varchar(50), mystring varchar(250), primary key (id)); Load Data...Delete first.... fails. Load Data...Truncate Table....works. changing initial.load.delete.first.sql to "truncate table %s" works as well. |
|
SymmetricDS: 3.10 30ce396a 2019-07-01 12:58:53 Details Diff |
0003726: Delete or truncate should quote table name and include catalog/schema |
Affected Issues 0003726 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/IDatabasePlatform.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/kafka/KafkaPlatform.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/Db2As400DatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/Db2DatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/db2/Db2zOsDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/firebird/FirebirdDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/interbase/InterbaseDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2000DatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2005DatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSql2008DatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/raima/RaimaDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/sqlite/SqliteDatabasePlatform.java | Diff File | ||
|
SymmetricDS: 3.10 72d52643 2019-07-23 12:15:21 Details Diff |
0003726: Delete or truncate should quote table name and include catalog/schema Commented out code previously committed to handle delete -> was able to replicate delete issue on postgres with table bar!foo -> uncommented delete code -> delete load went through. Not sure if there's another issue, will continue to test. |
Affected Issues 0003726 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
| mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-09-18 16:11 | josh-a-hicks | New Issue | |
| 2018-09-19 12:05 | hanes | Status | new => confirmed |
| 2018-10-03 17:59 | hanes | Status | confirmed => new |
| 2018-10-10 13:50 | hanes | Status | new => confirmed |
| 2018-10-10 13:50 | hanes | Note Added: 0001265 | |
| 2018-10-10 18:08 | hanes | Target Version | => 3.10.0 |
| 2018-12-05 19:20 | hanes | Note Added: 0001362 | |
| 2018-12-05 20:01 | hanes | Priority | normal => low |
| 2019-03-14 12:39 | admin | Target Version | 3.10.0 => 3.10.1 |
| 2019-04-23 13:46 | elong | Target Version | 3.10.1 => 3.10.2 |
| 2019-04-24 18:57 | elong | Tag Attached: initial/partial load | |
| 2019-05-08 12:51 | admin | Target Version | 3.10.2 => 3.10.3 |
| 2019-06-21 17:30 | elong | Priority | low => high |
| 2019-06-21 17:30 | elong | Summary | Table reload requests that use %s for table replacement are not quoted if needed => Delete or truncate should quote table name and include catalog/schema |
| 2019-06-24 17:45 | elong | Target Version | 3.10.3 => 3.10.4 |
| 2019-07-01 16:59 |
|
Assigned To | => user606 |
| 2019-07-01 16:59 |
|
Status | confirmed => resolved |
| 2019-07-01 16:59 |
|
Resolution | open => fixed |
| 2019-07-01 16:59 |
|
Fixed in Version | => 3.10.4 |
| 2019-07-01 17:00 | jfrees | Changeset attached | => SymmetricDS 3.10 30ce396a |
| 2019-07-08 17:12 | hanes | Assigned To | user606 => |
| 2019-07-08 17:12 | hanes | Status | resolved => feedback |
| 2019-07-08 17:12 | hanes | Resolution | fixed => reopened |
| 2019-07-08 17:12 | hanes | Note Added: 0001551 | |
| 2019-07-08 17:14 | hanes | Note Added: 0001552 | |
| 2019-07-08 17:24 | hanes | Assigned To | => JJ_Starrett |
| 2019-07-08 17:24 | hanes | Status | feedback => assigned |
| 2019-07-08 17:24 | hanes | Fixed in Version | 3.10.4 => |
| 2019-07-22 19:01 | JJ_Starrett | Status | assigned => resolved |
| 2019-07-22 19:01 | JJ_Starrett | Resolution | reopened => fixed |
| 2019-07-23 14:14 | JJ_Starrett | Status | resolved => assigned |
| 2019-07-23 21:00 | JJ_Starrett | Changeset attached | => SymmetricDS 3.10 72d52643 |
| 2019-08-09 18:25 | elong | Status | assigned => resolved |
| 2019-08-09 18:25 | elong | Fixed in Version | => 3.10.4 |
| 2019-08-23 16:46 | admin | Status | resolved => closed |
| 2020-01-22 18:13 | elong | Relationship added | related to 0004260 |
| 2020-01-22 18:13 | elong | Relationship added | related to 0004259 |
| 2022-08-01 18:58 | elong | Relationship added | related to 0005387 |