No hits using this fragment

Hi.


JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bi


PL/SQL Release 10.1.0.5.0 - Production


CORE 10.1.0.5.0 Production


TNS for Linux: Version 10.1.0.5.0 - Production


NLSRTL Version 10.1.0.5.0 - Production


NLSRTL Version 10.1.0.5.0 - Production


JChem version in the database: 3.2.6


JChem version in the Tomcat server: 3.2.6


java.vm.version: 1.5.0_12-b04


java.vm.vendor: Sun Microsystems Inc.


Apache Tomcat/5.5.15





JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Major JDBC version in Tomcat: 1


Minor JDBC version in Tomcat: 0





I'm using the attached molecule to find both its duplicate and sss but it fails to find any.





Exact query


SELECT compound_id


FROM bcpvs.jcsepmol_moltable


WHERE jc_compareb


(cd_structure,


(SELECT bmolfile


FROM hive.tempmolfile


WHERE pkey = 70989184),


't:e HCountMatching:G doubleBondStereo:M stereoSearch:n exactIsotopeMatchingOption:i'


) = 1





SSS simple jc_containbs query.





What am I missing ?


Regards,


Mikael

More info.





If I replace the S with A , it hits all those that does not have S in that pos.





Regards,


Mikael

Hi Mikael,





We could reproduce the error and will get back to you soon.





Tamas

I have some good and bad news: this bug has been already fixed, but - due to it's dependencies - not in the 3.2.* versions, only in the developer one. Our next major release (JChem 5.0) will contain the fix.





Tamas

Hi.


When is that version going to be released ?


/Mikael

We plan the release during autumn. Please subscribe for the following forum topic to become aware of the exact date:


http://www.chemaxon.com/forum/ftopic287.html





Tamas

Hi,





JChem 5.0 is now out, and contains the fix for this problem.





Regards,


Szabolcs