View Issue Details

IDProjectCategoryView StatusLast Update
0005558SymmetricDSImprovementpublic2022-11-30 19:49
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.14.3Fixed in Version3.14.3 
Summary0005558: Create table without defaults if in error
DescriptionIf an error occurs when creating a table from a "create" event (either send schema or initial load), then try to create the table without defaults for columns if the target platform is different than the source platform. Many table create errors are when column defaults are using database specific tokens and functions that are not converted to the target platform. When dataloader.create.table.without.defaults.on.error=true (default), it will remove the column defaults on an error. The user can turn off the parameter if they want to see the errors and use the default.values.to.leave.unquoted and default.values.to.translate parameters from issue 0005551 to properly convert column defaults.
Tagsddl/schema

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 c491e0ba

2022-10-27 15:20:18

admin

Details Diff
0005558: Create table without defaults if in error Affected Issues
0005558
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/extract/SelectFromSymDataSource.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/load/AbstractDataLoaderFactory.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java Diff File
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/IDatabasePlatform.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DatabaseWriterSettings.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/writer/DefaultDatabaseWriter.java Diff File

SymmetricDS: 3.14 e9b9b02f

2022-10-31 12:49:32

admin

Details Diff
0005558: Create table without defaults if in error Affected Issues
0005558
mod - symmetric-db/src/main/java/org/jumpmind/db/model/Table.java Diff File

Issue History

Date Modified Username Field Change
2022-10-27 15:06 elong New Issue
2022-10-27 15:06 elong Status new => assigned
2022-10-27 15:06 elong Assigned To => elong
2022-10-27 15:06 elong Tag Attached: ddl/schema
2022-10-27 15:06 elong Project SymmetricDS Pro => SymmetricDS
2022-10-27 15:22 elong Status assigned => resolved
2022-10-27 15:22 elong Resolution open => fixed
2022-10-27 15:22 elong Fixed in Version => 3.14.3
2022-10-27 16:00 admin Changeset attached => SymmetricDS 3.14 c491e0ba
2022-10-31 13:00 admin Changeset attached => SymmetricDS 3.14 e9b9b02f
2022-11-30 19:49 admin Status resolved => closed