Firebird Documentation IndexFirebird 2.0.6 Release NotesNew in Firebird 2.0 → New Implementation of String Search Operators
Firebird Home Firebird Home Prev: Lock Timeout for WAIT TransactionsFirebird Documentation IndexUp: New in Firebird 2.0Next: Reworking of Updatable Views

New Implementation of String Search Operators

N. Samofatov

  1. 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.

  2. Pattern matching now uses a single-pass Knuth-Morris-Pratt algorithm, improving performance when complex patterns are used.

  3. The engine no longer crashes when NULL is used as ESCAPE character for LIKE

Prev: Lock Timeout for WAIT TransactionsFirebird Documentation IndexUp: New in Firebird 2.0Next: Reworking of Updatable Views
Firebird Documentation IndexFirebird 2.0.6 Release NotesNew in Firebird 2.0 → New Implementation of String Search Operators