v.19.5New Features
Hyperscan Multiple Regular Expression Matching Was Added (functions Multimatchany, Multimatchanyindex, Multifuzzymatchany, Multifuzzymatchanyindex)
Hyperscan multiple regular expression matching was added (functionsmultiMatchAny,multiMatchAnyIndex,multiFuzzyMatchAny,multiFuzzyMatchAnyIndex). #4780, #4841 (Danila Kutenin)
Why it matters
This feature leverages the Hyperscan library to enable efficient matching of multiple regular expressions simultaneously. It improves performance and convenience by allowing users to run multiple regex matches in a single function call, reducing overhead compared to individual regex evaluations.How to use it
Use the new functionsmultiMatchAny, multiMatchAnyIndex, multiFuzzyMatchAny, or multiFuzzyMatchAnyIndex in your SQL queries to perform multiple regex matches concurrently. These functions accept arrays of patterns and return results according to their matching semantics.