View Revisions: Issue #3196

Back to Issue
Summary 0003196: Behaviour changed for `sym_trigger` `use_stream_lobs` and `use_capture_lobs` fields
Revision 2017-07-11 20:28 by arsreedh
Steps To Reproduce
Extending the corp-store example add a new table :

CREATE TABLE `corp`.`bin_test` (
  `bin_uuid` BINARY(16) NOT NULL,
  `description` VARCHAR(45) NULL,
  PRIMARY KEY (`bin_uuid`));



CREATE TABLE `store`.`bin_test` (
  `bin_uuid` BINARY(16) NOT NULL,
  `description` VARCHAR(45) NULL,
  PRIMARY KEY (`bin_uuid`));



INSERT INTO `corp`.`sym_trigger`
    (`trigger_id`, `source_table_name`, `channel_id`,
    last_update_time, create_time) VALUES ('bin_test', 'bin_test',
    'sale_transaction', current_timestamp, current_timestamp);


INSERT INTO `corp`.`sym_trigger_router`
    (`trigger_id`, `router_id`, `initial_load_order`, `create_time`,
    `last_update_time`) VALUES ('bin_test', 'corp_2_store', '100',
    current_timestamp, current_timestamp);



UPDATE `corp`.`sym_channel` SET `contains_big_lob`='1' WHERE `channel_id`='sale_transaction';
UPDATE `corp`.`sym_trigger` SET `use_stream_lobs`='1', `use_capture_lobs`='1' WHERE `trigger_id`='bin_test';



Now when you do an insert into this table:

insert into corp.bin_test(bin_uuid,description) values('9fad5e9eefdfb449', 'abc!');

It throws the above stated exception. Where as in 3.7.x this never threw an error.
Revision 2017-07-12 17:49 by chenson
Steps To Reproduce Extending the corp-store example add a new table :

CREATE TABLE `corp`.`bin_test` (
  `bin_uuid` BINARY(16) NOT NULL,
  `description` VARCHAR(45) NULL,
  PRIMARY KEY (`bin_uuid`));



CREATE TABLE `store`.`bin_test` (
  `bin_uuid` BINARY(16) NOT NULL,
  `description` VARCHAR(45) NULL,
  PRIMARY KEY (`bin_uuid`));



INSERT INTO `corp`.`sym_trigger`
    (`trigger_id`, `source_table_name`, `channel_id`,
    last_update_time, create_time) VALUES ('bin_test', 'bin_test',
    'sale_transaction', current_timestamp, current_timestamp);


INSERT INTO `corp`.`sym_trigger_router`
    (`trigger_id`, `router_id`, `initial_load_order`, `create_time`,
    `last_update_time`) VALUES ('bin_test', 'corp_2_store', '100',
    current_timestamp, current_timestamp);



UPDATE `corp`.`sym_channel` SET `contains_big_lob`='1' WHERE `channel_id`='sale_transaction';
UPDATE `corp`.`sym_trigger` SET `use_stream_lobs`='1', `use_capture_lobs`='1' WHERE `trigger_id`='bin_test';



Now when you do an insert into this table:

insert into corp.bin_test(bin_uuid,description) values('9fad5e9eefdfb449', 'abc!');

It throws the above stated exception. Where as in 3.7.x this never threw an error.