Error thrown by query specified using inactive concept IDs

[GoogleCodeExporter]

What steps will reproduce the problem?

1. Load the attached Query1
2. Generate 100 patients with option ADD_NEW_ALWAYS from it
3. Run Query2

What is the expected output? 

A list of either 100 patients, or of no patients.

What do you see instead?

An error

Original issue reported on code.google.com by jeremy.r...@googlemail.com on 7 Jul 2011 at 5:55

Attachments:

• Query1.xml
• Query2.xml
• srth.log

[GoogleCodeExporter]

Bug verified... not quite related to data generation, but to dynamic traversal 
of historical relationships that Snofyre does when it encounters inactive 
concepts...

[ WARN] 07 Jul 2011 18:52:14 
(uk.nhs.cfh.dsp.snomed.dao.impl.SnomedConceptDatabaseDAO:653) - 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
'RELATIONHIPTYPE' in 'where clause'

Fixed issue in syntax above...

Extended Snofyre's dynamic inactive replacement to handle MOVED TO and MAY BE A 
statuses... so please verify attached jar works by dropping it and overwriting 
the existing jar in Snofyre/bin/lib folder...

Please file a separate issue if the results are not what you expect to find... 
:)

Original comment by jay.k...@biomedicalontologies.com on 8 Jul 2011 at 12:28

• Changed state: Fixed

Attachments:

• uk.nhs.cfh.dsp.snomed.dao-0.8.jar