I need the message ids and endpoints of messages from whom endpoints in multicast_message_recovery_processed is not in the list of endpoints of the multicast_endpoints table, for a given prcs_id, prcs_run_id, multicast_id.
For a given `prcs_id = 100, prcs_run_id = 1, multicast_id = multiX`, the query should return:
This essentially means that message 1 has not reached `destB` and `destD` while message 2 has not reached `destA`, `destC` and `destD`.
posted 4 years ago
Try this query.
I shortended name of multicast_message_recovery_processed table since my database accepts only names up to 30 characters.