View Issue Details

IDProjectCategoryView StatusLast Update
0005942SymmetricDSBugpublic2023-07-31 18:00
Reporterpmarzullo Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.8 
Target Version3.14.9Fixed in Version3.14.9 
Summary0005942: SQLAnywhere DDL problems with dropping indexes and triggers, and trigger syntax issue for version 11 and earlier
DescriptionKey variables declare needs semicolon at end of declare in version 12, but not in 11 and earlier.
Drop of external index needs only schema and table name, not database name.
Drop trigger needs to check for blank schema name, and use default if specified schema is blank.
Tagsdialect: sql anywhere

Activities

Related Changesets

SymmetricDS: 3.14 30fc2d19

2023-07-31 15:58:48

pmarzullo

Details Diff
0005942: SQLAnywhere DDL problems with dropping indexes and triggers,
and trigger syntax issue for version 11 and earlier
Affected Issues
0005942
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/sqlanywhere/SqlAnywhere12TriggerTemplate.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/sqlanywhere/SqlAnywhereSymmetricDialect.java Diff File
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/sqlanywhere/SqlAnywhereTriggerTemplate.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/sqlanywhere/SqlAnywhereDdlBuilder.java Diff File

SymmetricDS: 3.14 f9a3a519

2023-07-31 17:13:41

pmarzullo

Details Diff
0005942: SQLAnywhere DDL problems with dropping indexes and triggers,
and trigger syntax issue for version 11 and earlier
Affected Issues
0005942
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/sqlanywhere/SqlAnywhereSymmetricDialect.java Diff File

Issue History

Date Modified Username Field Change
2023-07-31 15:57 pmarzullo New Issue
2023-07-31 15:57 pmarzullo Status new => assigned
2023-07-31 15:57 pmarzullo Assigned To => pmarzullo
2023-07-31 15:57 pmarzullo Tag Attached: dialect: sql anywhere
2023-07-31 16:00 pmarzullo Changeset attached => SymmetricDS 3.14 30fc2d19
2023-07-31 17:22 pmarzullo Status assigned => resolved
2023-07-31 17:22 pmarzullo Resolution open => fixed
2023-07-31 17:22 pmarzullo Fixed in Version => 3.14.9
2023-07-31 17:22 pmarzullo Note Added: 0002363
2023-07-31 18:00 pmarzullo Changeset attached => SymmetricDS 3.14 f9a3a519
2023-08-25 20:13 admin Status resolved => closed