View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006217 | SymmetricDS | Bug | public | 2024-01-31 13:55 | 2024-02-15 20:28 |
| Reporter | mistermij | Assigned To | |||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.2 | ||||
| Target Version | 3.15.4 | Fixed in Version | 3.15.4 | ||
| Summary | 0006217: Schema information missing from drop index query generated by DDL on PostgreSQL | ||||
| Description | The query the DDL generates for dropping an index, silently fails when the owning table is on a different schema. | ||||
| Steps To Reproduce | On a PostgreSQL have two schemas: public & sym. Have SymmetricDS engine use the `sym` schema. Create a table with an index on `public` schema. Send the schema to transfer the table ddl. Edit the table, dropping the index. Send the schema to transfer the table ddl. If you've the debug logs enabled, you'll notice the execution of the drop index failed, because the index was not found. | ||||
| Tags | ddl/schema, dialect: postgresql | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-01-31 13:55 | mistermij | New Issue | |
| 2024-01-31 13:55 | mistermij | Tag Attached: ddl/schema | |
| 2024-01-31 13:55 | mistermij | Tag Attached: dialect: postgresql | |
| 2024-02-14 19:10 | emiller | Status | new => resolved |
| 2024-02-14 19:10 | emiller | Resolution | open => fixed |
| 2024-02-14 19:10 | emiller | Fixed in Version | => 3.15.4 |
| 2024-02-15 20:28 | mistermij | Changeset attached | => SymmetricDS 3.15 9a4f050b |
| 2024-03-19 16:20 | admin | Status | resolved => closed |