On Tue, 29 Nov 2011 10:26:10 +0100, Dimitry Sibiryakov <s...@ibphoenix.com> wrote: > 29.11.2011 10:20, Mark Rotteveel wrote: >> Wouldn't that give false positives? Or does the engine also compare the >> actual (full) value after identifying a row in the index? > > Yes, real values are always evaluated for rows selected by index.
Then I think truncating the entry would be a wise move :) Mark ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel