• unknown's avatar
    WL#3228 (NDB) : RBR using different table defs on slave/master · 0e0b05ec
    unknown authored
    This patch adds the ability to store extra field metadata in the table
    map event. This data can include pack_length() or field_lenght() for
    fields such as CHAR or VARCHAR enabling developers to add code that
    can check for compatibilty between master and slave columns. More 
    importantly, the extra field metadata can be used to store data from the
    master correctly should a VARCHAR field on the master be <= 255 bytes 
    while the same field on the slave is > 255 bytes. '
    
    The patch also includes the needed changes to unpack to ensure that data
    which is smaller on the master can be unpacked correctly on the slave.
    
    
    mysql-test/extra/rpl_tests/rpl_log.test:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch changes the test to display slave status vertically.
    mysql-test/r/rpl_ndb_log.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/r/rpl_rbr_to_sbr.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/r/rpl_row_basic_11bugs.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/r/rpl_row_create_table.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/r/rpl_row_flsh_tbls.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/r/rpl_row_inexist_tbl.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/r/rpl_row_log.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/r/rpl_row_log_innodb.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/r/rpl_row_max_relay_size.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/r/rpl_row_until.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/r/rpl_stm_log.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the rpl_log.test modifications.
    mysql-test/r/rpl_truncate_7ndb.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/t/binlog_row_mix_innodb_myisam.test:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch changes the test to coincide with changes to binlog
      size of table map event.
    mysql-test/t/rpl_row_create_table.test:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch changes the test to coincide with changes to binlog
      size of table map event.
    mysql-test/t/rpl_row_flsh_tbls.test:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch changes the test to coincide with changes to binlog
      size of table map event.
    sql/field.cc:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch includes updates to the unpack() methods for the variable
      length fields. A new parameter was added (from_length) that is the
      value stored in the field_metadata of the table map from the table_def
      class. If the value is non-zero and less than what the field on the 
      slave is then use the from_length else use the original value from the
      field on the slave.
    sql/field.h:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch includes updates to the unpack() methods for the variable
      length fields. A new parameter was added (from_length) that is the
      value stored in the field_metadata of the table map from the table_def
      class.
    sql/log_event.cc:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch adds methods to calculate the field metadata size, prepare
      the field metadata for writing to the binlog, and additions to the
      Table_map_log_event::write_body method to include the field metadata 
      in the table map that is written to the binlog.
    sql/log_event.h:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch adds method declarations and variables needed to support
      storing field metadata in the table map that is written to the binlog.
    sql/rpl_record.cc:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch modifies the unpack_row() method to unpack fields passing in
      the value from the table_def class. This value is the extra field
      metadata stored there from the master.
    sql/rpl_rli.h:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch adds a helper function to retrieve the table_def for a given
      table in the RPL_TABLE_LIST structure.
    sql/rpl_utility.cc:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch adds a helper method that retrieves the correct size 
      parameter for the field. This method is used to compare the size as
      sent by the master with that on the slave for all types of fields that
      can vary in size and storage requirements.
    sql/rpl_utility.h:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch changes the table_def class constructor to pass in the raw
      data read from the table map and extract it into an array of dimension
      size (number of fields). It also adds a method to return the field 
      metadata for any field. The method returns the data stored in the table
      map or 0 if no data was stored for that field. Lastly, a method to return
      the results of field->maybe_null() is included so that the slave can
      determine if a field that is not on the slave is null.
    mysql-test/r/rpl_colSize.result:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a result file for the new test designed to test the 
      feature of having columns on the master that are smaller than what is 
      on the slave.
    mysql-test/t/rpl_colSize.test:
      WL#3228 : RBR using different table defs on slave/master
      
      This patch contains a new test designed to test the feature of having
      columns on the master that are smaller than what is on the slave.
    0e0b05ec
rpl_colSize.result 4.39 KB