On 2017-03-28 19:08, John Andersen wrote:
On 03/26/2017 06:27 PM, Carlos E. R. wrote:
On 2017-03-26 15:13, gumb wrote:
Thanks, I've now saved the search so will hopefully find it again in future. I'm a bit miffed how searching for all bugs with my username finds nothing, yet searching with my full email brings them up, considering my username forms part of that email. But my head would now prefer a cup of tea to trying to decipher that.
A real name can have variants, in order, case, spacing, errors... An email is a fixed token, case not important.
Once you allow for ignoring case, its all the same. A character is a character. a string is a string.
I suspect the real issue here is how the data is indexed. I suspect email is an indexed field, and real name isn't.
Searching for real name then requires some grep like operation where as email uses an index.
Yes, that would make sense. -- Cheers / Saludos, Carlos E. R. (from 42.2 x86_64 "Malachite" (Minas Tirith))