Columns With Default Values Not Syncing Automatically

Issue

Some columns that have default values at the time of table creation are not automatically synced to the destination.

Environment

Connector: MySQL

Resolution

You need to re-sync the tables in which these particular columns reside. This populates the columns with the defined values.

Cause

Values set for a column using default do not generate any DML entries in the change log, so the connector does not recognize these values, and they are not synced to the destination.