partial numeric match?

[kevin12]

Why would a column full of numbers return hits for matches of parts of the numbers?

TSQL > select groups from article2 where groups like '(50)' ;

groups
------------+
50164 7651
10329 61350 61560 45980 90344
...etc.

The index was created without any addexp's in effect.

[Kai]

Was the Metamorph index created on just the groups field? Is it up to date?

[kevin12]

Yes the index was just on the groups field, no it wasn't up to date. The problem went away when I brought the index up to date. What's up with that, do you know?

[John]

The default langc settings do not include digits, so a substring search is done searching linearly. You could do the following to bring the linear search behaviour in line with the index behaviour:

set langc='[\alnum\'']';
set wordc='[\alnum\''\-]';