View Issue Details

IDProjectCategoryView StatusLast Update
0004750SymmetricDSBugpublic2021-01-11 13:47
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.0.0 
Target Version3.12.6Fixed in Version3.12.6 
Summary0004750: On SQL-Server can't drop trigger, incorrect syntax
DescriptionOn 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 Reproducecreate 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'.
Tagsdialect: sql-server, trigger

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.12 924637d2

2021-01-08 18:11:01

admin

Details Diff
0004750: On SQL-Server can't drop trigger, incorrect syntax Affected Issues
0004750
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlSymmetricDialect.java Diff File

Issue History

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