Basic Text Search
Hi!
IDS 11.50FC5
When I use search with Basic Text Search
query return error:
select
*
FROM test_customer
WHERE
bts_contains(cust_name, 'qwerty')
937: User Defined Routine error.
bts index:
create index idx_bts_test on test_customer (cust_name bts_char_ops)
using bts in sbs1
Table test_customer contains 554163 rows.
When this table contains 515000 rows - no error.
This is bag or limitation?
Hi,
I am the development lead for the Basic Text Search DataBlade (BTS). We
have done some extensive testing on BTS in the 11.50.xC3 and 11.50.xC4
timeframe with a 35 Million row table using a column of type char with up to
300,000 unique words in the vocabulary so I don't think you have hit any
known limitations.
I have not seen any other similar problems reported. It was a simple matter
for me to I plugged in the parameters to do a test harness I have and
perform a similar test on the version of the BTS in IDS 11.50.FC5 (Linux in
this case):
> Unique word 'qwerty' inserted on row 180991
> 554163 total row(s) inserted.
...
> create index bts_idx on bts_tab(text bts_char_ops) using bts inbts_sbspace1;
> Index created.
...
> select * from bts_tab where bts_contains(text, 'qwerty')>
> pid 180991
> text qwerty decrescendo ... [ 18 other words deleted... ]
>
> 1 row(s) retrieved.
Everything worked fine for me. So it sounds like it may have hit a bug of
some sort so may I suggest you contact support with this problem.
I hope this helps. Thank you.
Mark Ashworth
> -----Original Message-----
> From: informix-list-bounces@iiug.org [mailto:informix-list-
> bounces@iiug.org] On Behalf Of zaiets.komus@gmail.com
> Sent: September 2, 2009 6:27 PM
> To: informix-list@iiug.org
> Subject: [Bulk] Basic Text Search
>
> Hi!
> IDS 11.50FC5
>
> When I use search with Basic Text Search
> query return error:
> select
> *
> FROM test_customer
> WHERE
> bts_contains(cust_name, 'qwerty')
>
> 937: User Defined Routine error.>
> bts index:
> create index idx_bts_test on test_customer (cust_name bts_char_ops)
> using bts in sbs1>
> Table test_customer contains 554163 rows.
> When this table contains 515000 rows - no error.
>
> This is bag or limitation?
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list