User 894750ccb4
23-03-2015 08:50:39
I have severe problems with jc_compare in 15.2. Running a query versus a table having the query molecule in the table I only get hits with t:s and t:ff. Not with t:f or t:d which is pretty weird.
SELECT MOLFILE, COMPOUND_ID
FROM COMPOUND c
WHERE (jc_compare (CD_STRUCTURE,
(SELECT molfile
FROM COMPOUND
WHERE compound_id = 'C30354'),
't:ff') = 1)
I have dropped and rebuilt the index. The problems started after an upgrade from an older cartridge version. Note: the same behaviour even if I reoplace the molfile in the query with CD_STRUCTURE!