View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004492SymmetricDSBugpublic2020-08-07 12:312020-09-01 12:20
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.5 
Target Version3.12.3Fixed in Version3.12.3 
Summary0004492: MySQL before 5.0.32 does not have drop trigger if exists
DescriptionThe "drop trigger if exists" syntax was introduced in MySQL 5.0.32, so check if that version is being used before using that syntax. The dialect will drop triggers in response to configuration changes.
Tagsdialect: mysql/mariadb

Relationships

related to 0003478 closedjosh-a-hicks Sync triggers in MySQL will fail if there is an active trigger history record but the table was removed manually 

Activities

elong

2020-08-07 12:35

developer  

patch-0004492.jar (5,825 bytes)

Related Changesets

SymmetricDS: 3.12 e98ca739

2020-08-07 08:32:26

admin

Details Diff 		0004492: MySQL before 5.0.32 does not have drop trigger if exists Affected Issues
0004492
mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mysql/MySqlSymmetricDialect.java Diff File

Issue History

Date Modified Username Field Change
2020-08-07 12:31 elong New Issue
2020-08-07 12:31 elong Status new => assigned
2020-08-07 12:31 elong Assigned To => elong
2020-08-07 12:31 elong Tag Attached: dialect: mysql/mariadb
2020-08-07 12:35 elong File Added: patch-0004492.jar
2020-08-07 12:35 elong Status assigned => resolved
2020-08-07 12:35 elong Resolution open => fixed
2020-08-07 12:35 elong Fixed in Version => 3.12.3
2020-08-07 12:38 elong Relationship added related to 0003478
2020-08-07 13:00 admin Changeset attached => SymmetricDS 3.12 e98ca739
2020-09-01 12:20 elong Status resolved => closed