drop table if exists tp01 ;
create temp table tp01 ( nome varchar(100) ) with no log ;
insert into tp01 select first 1000 tabname from systables ;
create index i1_tp01 on tp01( nome bts_varchar_ops) using bts ;
select * from tp01 where bts_contains (nome, 'sys')
#(BTS92) - bts error - CLucene index does not exist
Why is it useful?
|Who would benefit from this IDEA?||all the customers who are using BTS on temp table|
How should it work?
it should allow user to create and use this index
|Priority Justification||I need this feature to be fixed as soon as possible|
|Customer Name||VULCABRAS DO NORDESTE S/A|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "email@example.com" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions