jc_compare brings wrong results

Hello,

 

While testing the systeme we found that jc_compare don't don't give right results with some requests.

The request is well written cause it works most of the time.

for the bad request screenshot it'll be like: select cd_id from sub_structure where jc_compare(cd_structure, 'C1=CC=CC=C1', 't:s')=1;

CD_ID       

----------- 

0 rows selected

for the good one: select cd_id from sub_structure where jc_compare(cd_structure, 'C1=CC2=C(C=C1)C=CC=C2', 't:s')=1;

output:

CD_ID       

----------- 

223081      

223089      

223091      

223093      

223095      

223099      

6 rows selected

This is an example:

I also did try to use molconvert or different formats but didn't work for me 

select cd_id from sub_structure where jc_compare(cd_structure, JC_MOLCONVERT('the smile code here', 'mol'), 't:s')=1;