v.21.7Improvement

Add == Operator for Time Conditions in sequenceMatch and sequenceCount Functions

Add == operator on time conditions for sequenceMatch and sequenceCount functions. For eg: sequenceMatch('(?1)(?t==1)(?2)')(time, data = 1, data = 2). #25299 (Christophe Kalenzaga).
Added the == operator for time conditions in the sequenceMatch and sequenceCount functions.

Why it matters

This feature allows users to specify exact equality conditions on timestamps within sequence pattern matching, enhancing expressiveness and precision in event sequence queries where exact time matches are required.

How to use it

Use the == operator inside time conditions within the pattern string of sequenceMatch or sequenceCount. For example:

SELECT sequenceMatch('(?1)(?t==1)(?2)')(time, data = 1, data = 2) FROM table

This checks that the time condition is exactly equal to 1 between the matched events.