Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4335

RMDB Default value should be optional

    XMLWordPrintable

Details

    • 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 

      Attachments

        Activity

          People

            Unassigned Unassigned
            camilesing Camile Sing (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: