Details
-
Enhancement
-
Resolution: Done
-
Critical
-
None
-
None
-
None
-
False
-
False
Description
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