Firebird Documentation Index → Firebird 2.0.6 Release Notes → New in Firebird 2.0 → New Implementation of String Search Operators |
The operators now work correctly with BLOBs of any size. Issues with only the first segment being searched and with searches missing matches that straddle segment boundaries are now gone.
Pattern matching now uses a single-pass Knuth-Morris-Pratt algorithm, improving performance when complex patterns are used.
The engine no longer crashes when NULL is used as ESCAPE character for LIKE
Firebird Documentation Index → Firebird 2.0.6 Release Notes → New in Firebird 2.0 → New Implementation of String Search Operators |