View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004750 | SymmetricDS | Bug | public | 2021-01-08 18:08 | 2021-01-11 13:47 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.0.0 | ||||
| Target Version | 3.12.6 | Fixed in Version | 3.12.6 | ||
| Summary | 0004750: On SQL-Server can't drop trigger, incorrect syntax | ||||
| Description | On SQL-Server, when triggers are created, the schema is quoted to allow use of reserved words and special characters. The drop trigger syntax does not quote the schema, so the trigger can't be dropped and gets an error instead. | ||||
| Steps To Reproduce | create schema "case"; create table "case".casetable (id integer); 2021-01-08 13:04:23,985 ERROR [server] [TriggerRouterService] [qtp1929661663-172] Error while dropping trigger SYM_ON_U_FOR_CSCSTBL_SRVR for table casetable org.jumpmind.db.sql.SqlException: Incorrect syntax near the keyword 'case'. | ||||
| Tags | dialect: sql-server, trigger | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-01-08 18:08 | elong | New Issue | |
| 2021-01-08 18:08 | elong | Status | new => assigned |
| 2021-01-08 18:08 | elong | Assigned To | => elong |
| 2021-01-08 18:08 | elong | Tag Attached: dialect: sql-server | |
| 2021-01-08 18:08 | elong | Tag Attached: trigger | |
| 2021-01-08 18:11 | elong | Status | assigned => resolved |
| 2021-01-08 18:11 | elong | Resolution | open => fixed |
| 2021-01-08 18:11 | elong | Fixed in Version | => 3.12.6 |
| 2021-01-08 18:11 | elong | Summary | On SQL-Server can't drop trigger, inccorect syntax => On SQL-Server can't drop trigger, incorrect syntax |
| 2021-01-08 19:00 | admin | Changeset attached | => SymmetricDS 3.12 924637d2 |
| 2021-01-11 13:47 | admin | Status | resolved => closed |