Res: BTS Developers Support...
Isn't exactly the same problem, it's similar...
I already using IDS 11.50 , BTS 1.10 , because this I don't try the workaround, but... I will try...
Thanks
Cesar
----- Mensagem original ----
De: Fernando Nunes <domusonline@gmail.com>
Para: informix-list@iiug.org
Enviadas: Terça-feira, 29 de Julho de 2008 19:42:48
Assunto: Re: BTS Developers Support...
Cesar Inacio Martins wrote:
> Hi,
>
> I using the BTS 1.10 with IDS 11.50 UC1 Developer.
> I have a situation here thats appear like a Bug.
>
> I found this APAR what look like my situation:
> http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&context=SSZ2HS&context=SSP6X2&context=SSVHPS&context=SSHPYE&q1=bts&q2=basic+text+search&uid=swg1IC54959&loc=en_US&cs=utf-8〈=en
>
> How works the support to BTS? Basead on this APAR I think will need
> the Informix Support or have any official group of developers what we
> can contact?
>
>
> Information about my situation:
> When execute a bts_contains with OR (SQL statement) a error occur:
>
> select count(*)
> from t_pergunta p, t_tag_perg t , outer t_resposta_cl r, t_tags tg
> where p.cod_pergunta = t.cod_pergunta
> and r.cod_pergunta = p.cod_pergunta
> and tg.cod_tag = t.cod_tag
> OR bts_contains(r.resposta , "DML") ;>
> (BTS22) - bts error - bts_contains requires an index on the search
> column
>
> When change the OR to AND , works fine:
>
> select count(*)
> from t_pergunta p, t_tag_perg t , outer t_resposta_cl r, t_tags tg
> where p.cod_pergunta = t.cod_pergunta
> and r.cod_pergunta = p.cod_pergunta
> and tg.cod_tag = t.cod_tag
> AND bts_contains(r.resposta , "DML") ;>
> (count(*))
>
> 250
>
>
>
>
>
> ------------------------------------------------------------------------
> Novos endereços, o Yahoo! que você conhece. Crie um email novo
> <http://br.rd.yahoo.com/mail/taglines/mail/*http://br.new.mail.yahoo.com/addresses>;
> com a sua cara @ymail.com ou @rocketmail.com.
If it is the same problem as the APAR, you can try to use the workaround presented.
The issue should be corrected in IDS 11.50 (BTS 1.10).
Regards.
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.
http://br.new.mail.yahoo.com/addresses