Hi all,
I've got strange thing with my UDF.
My UDF receives 2 text columns as parameters - fields of type text
(protein or nucleo sequences). It makes by pair comparison and the result
is char* - set of output sequences (aligned).
Input table is seqTbl:
id | seq_type | seq
For example, I run my UDF with nucleo chains: SELECT pairalign (q1.seq,
q2.seq) from seqTbl as q1, seqTbl as q2 where q1.seq_type = nucl and
q2.seq_type = nucl.
It works ok.
After I run it with protein sequences: SELECT pairalign (q1.seq, q2.seq)
from seqTbl as q1, seqTbl as q2 where q1.seq_type = prot and q2.seq_type
= prot. The result is ok, also.
But when I run the first SELECT again, the results are different
(incorrect).
They are incorrect even if I exit mysql and then run it again.
I have to drop my UDF, exit mysql, run it again and create function again
to get the same, correct results for my first SELECT.
What's going on?
Looking forward for your answers...
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
