search

TIBCOSoftware / be-contribution

This repository is to add various contributions across different modules within TIBCO BusinessEvents. It will include contributions by TIBCO BusinessEvents team as well external users/customers/fields teams.
BSD 3-Clause "New" or "Revised" License
0 stars 9 forks source link

Cassandra Channel || Able to receive message at engine side for update/delete operation when record is not present #94

Closed praagraw-tibco closed 1 year ago

praagraw-tibco commented 1 year ago

Version Information

Software Version(s)
BusinessEvents 6.3.0
OS Type?
OS Version?

If a record is not present in Cassandra DB and update/delete operation is being performed then also event triggers at engine side. As we have CDC enabled and data is not present inside DB, shouldn't we receive any kind of message from the topic (in case of data not present)

authProvider_none_V6.log

rakulkar-tibco commented 1 year ago

In Cassandra - Unlike in SQL, UPDATE does not check the prior existence of the row by default. The row is created if none existed before, and updated otherwise. Furthermore, there is no means of knowing which action occurred.

Reference : https://cassandra.apache.org/doc/latest/cassandra/cql/dml.html#update-statement

Ifif exists clause is used with update/insert query then no message will be received on pulsar topic if data is not present already in a db.

praagraw-tibco commented 1 year ago

Closed as per comment