LIKE Support for Long Objects Home
From Ingres Community Wiki
This project addresses shortcomings in the support for pattern matching in large objects with Ingres. The primary requirement is to support LONG VARCHAR support in the SQL LIKE predicate. This support will be structured to easily extend to LONG NVARCHAR and also other regular expression pattern forms beyond the SQL standard including the shorthand forms of BEGINNING, CONTAINING or ENDING. From the outset this support will encompass multi-pattern scanning allowing a single trawl through the object with the scans apparently executing in a parallel manner.
Ingres Enhancement Number
SIR 120260
Detailed Design Specification
The original DDS for this feature is available here.
DDS Version 1.4 for this feature is available here.
