View Issue Details

IDProjectCategoryView StatusLast Update
0002550SymmetricDSBugpublic2017-02-09 13:26
ReporterelongAssigned Toelong 
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionfixed 
Product Version3.7.31 
Target Version3.7.32Fixed in Version3.7.32 
Summary0002550: Typo in trigger text broke trigger generation on SQL Server
DescriptionIssue 0002535 caused a typo in the trigger text for SQL Server that prevents insert triggers from being created.

The issue was attempting to replace hard-coded occurrences of "sym" with the prefix specified by the user.
TagsNo tags attached.

Relationships

related to 0002535 closedelong Some SQL has sym_ hardcoded in table name 

Activities

mmichalek

2017-02-09 13:25

administrator   ~0000968

Last edited: 2017-02-09 13:26

View 2 revisions

This may show up in practice like this:
org.jumpmind.db.sql.SqlException: Incorrect syntax near '('.
...
With the problem being this text in the trigger definition: ($prefixName)_node_disabled()

Related Changesets

SymmetricDS: 3.7 2482150a

2016-04-06 08:44:21

admin

Details Diff
0002550: Typo in trigger text broke trigger generation on SQL Server
0002550
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql/MsSqlTriggerTemplate.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mssql2000/MsSql2000TriggerTemplate.java Diff File

Issue History

Date Modified Username Field Change
2016-04-06 08:40 elong New Issue
2016-04-06 08:40 elong Status new => assigned
2016-04-06 08:40 elong Assigned To => elong
2016-04-06 08:40 elong Relationship added related to 0002535
2016-04-06 09:00 admin Changeset attached => SymmetricDS 3.7 2482150a
2016-04-06 13:23 elong Status assigned => resolved
2016-04-06 13:23 elong Fixed in Version => 3.7.32
2016-04-06 13:23 elong Resolution open => fixed
2016-04-06 16:25 admin Status resolved => closed
2017-02-09 13:25 mmichalek Note Added: 0000968
2017-02-09 13:25 mmichalek Status closed => feedback
2017-02-09 13:25 mmichalek Resolution fixed => reopened
2017-02-09 13:25 mmichalek Status feedback => closed
2017-02-09 13:25 mmichalek Resolution reopened => fixed
2017-02-09 13:25 mmichalek Status closed => feedback
2017-02-09 13:25 mmichalek Resolution fixed => reopened
2017-02-09 13:26 mmichalek Note Edited: 0000968 View Revisions
2017-02-09 13:26 mmichalek Status feedback => closed
2017-02-09 13:26 mmichalek Resolution reopened => fixed