I created an index in the following manner:
<sql "set keepnoise=1"></sql>
<sql "set delexp=0"></sql>
<sql "set addexp='\alnum{2,50}'"></sql>
<sql "set addexp='[\alnum\x80-\xff]{1,70}'"></sql>
<sql "create metamorph inverted index xwgaztxt
on worldgaz(name\altnames\adm1\adm2\adm3\cc\country,geo,pop)"></sql>
There are country codes in the cc field. When I search the index non-noise country codes it works fine , but for US and IT it returns nothing.
www% tsql "set indexaccess=1;select * from xwgaztxt where Word = 'gb'" | more
Texis Version 05.01.1109947850(20050304) Copyright (c) 1988-2005 Thunderstone EPI
Word Count
------------+------------+
gb 2670
www% tsql "set indexaccess=1;select * from xwgaztxt where Word = 'us'" | more
Texis Version 05.01.1109947850(20050304) Copyright (c) 1988-2005 Thunderstone EPI
Word Count
------------+------------+
www% tsql "set indexaccess=1;select * from xwgaztxt where Word = 'it'" | more
Texis Version 05.01.1109947850(20050304) Copyright (c) 1988-2005 Thunderstone EPI
Word Count
------------+------------+
www%
Whats up with this?
<sql "set keepnoise=1"></sql>
<sql "set delexp=0"></sql>
<sql "set addexp='\alnum{2,50}'"></sql>
<sql "set addexp='[\alnum\x80-\xff]{1,70}'"></sql>
<sql "create metamorph inverted index xwgaztxt
on worldgaz(name\altnames\adm1\adm2\adm3\cc\country,geo,pop)"></sql>
There are country codes in the cc field. When I search the index non-noise country codes it works fine , but for US and IT it returns nothing.
www% tsql "set indexaccess=1;select * from xwgaztxt where Word = 'gb'" | more
Texis Version 05.01.1109947850(20050304) Copyright (c) 1988-2005 Thunderstone EPI
Word Count
------------+------------+
gb 2670
www% tsql "set indexaccess=1;select * from xwgaztxt where Word = 'us'" | more
Texis Version 05.01.1109947850(20050304) Copyright (c) 1988-2005 Thunderstone EPI
Word Count
------------+------------+
www% tsql "set indexaccess=1;select * from xwgaztxt where Word = 'it'" | more
Texis Version 05.01.1109947850(20050304) Copyright (c) 1988-2005 Thunderstone EPI
Word Count
------------+------------+
www%
Whats up with this?