View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0005436||SymmetricDS||Bug||public||2022-09-02 17:42||2022-10-04 15:15|
|Target Version||3.14.2||Fixed in Version||3.14.2|
|Summary||0005436: Sybase ASE issues when upgrading SymmetricDS from an older version to 3.14.*|
|Description||There are several Sybase ASE issues when upgrading SymmetriicDS from an older version to 3.14.*.|
1. When adding a primary key (actually in this case the primary key changed so a remove and an add of the primary key is executed), the desired model of the database needs to be used in case the columns used in the primary key have been added to the table (or renamed).
2. When the DatabaseUpgradeListener is run before the upgrade of the database schema, the changes that are executed by the beforeUpgrade() methods are not seen when analyzing the differences between the current database and the desired database because a snapshot of the current database is taken before running the beforeUpgrade() methods.
3. Identity columns that are added to a table need to check to see if the sqltype that is read from the database has the "identity" keyword as part of the sqltype because it looks like the sqltype being returned from the metadata is something like "numeric identity" instead of just "numeric".
4. Sybase doesn't seem to allow dropping indexes using the "catalog.schema.table.indexname" format. You have to "USE catalog", then drop "table.indexname".
5. Foreign keys to the sym_node table need to be dropped before upgrading schema because sym_node table is migrated to sym_node_ then back to sym_node, which means that the sym_node table is dropped.
|Tags||ddl/schema, dialect: sybase|
SymmetricDS: 3.14 5fcc801f
2022-09-12 16:13:28Details Diff
|0005436: Sybase ASE issues when upgrading SymmetricDS from an older
version to 3.14.*
|mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractSymmetricDialect.java||Diff File|
|mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/DatabaseUpgradeListener.java||Diff File|
|mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java||Diff File|
|mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ase/AseDdlBuilder.java||Diff File|
|2022-09-02 17:42||pmarzullo||New Issue|
|2022-09-02 17:42||pmarzullo||Status||new => assigned|
|2022-09-02 17:42||pmarzullo||Assigned To||=> pmarzullo|
|2022-09-02 17:42||pmarzullo||Tag Attached: ddl/schema|
|2022-09-02 17:42||pmarzullo||Tag Attached: dialect: sybase|
|2022-09-12 16:14||pmarzullo||Status||assigned => resolved|
|2022-09-12 16:14||pmarzullo||Resolution||open => fixed|
|2022-09-12 16:14||pmarzullo||Fixed in Version||=> 3.14.2|
|2022-09-12 17:00||pmarzullo||Changeset attached||=> SymmetricDS 3.14 5fcc801f|
|2022-10-04 15:15||admin||Status||resolved => closed|