In the case of MySQL, we create a table and set a default value. like this:

-- test.persons definition
CREATE TABLE `persons` (
  `P_Id` int(11) NOT NULL,
  `LastName` varchar(255) NOT NULL,
  `FirstName` varchar(255) DEFAULT NULL,
  `Address` varchar(255) DEFAULT NULL,
  `City` varchar(255) DEFAULT 'Sandnes'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

then we insert data:

insert into persons values(2,'ababa',null,null,null) 

now data of table :

but CDC will parse default value 'Sandnes'.

sometimes we need data exactly the same. like we just said, if we 'insert insert into persons values(2,'ababa',null,null,null)' , we don't expect 'insert insert into persons values(2,'ababa',null,null,Sandnes)' .

so I think we can add a property to choose CDC to need to parse default value. every RMDB connector property can be added.

if we think it's necessary to do, I'm pleasure to do it