[Phenoscape-commit] SF.net SVN: phenoscape:[564] trunk/src/Database/sql/tests/ SpecimenInfoFromTaxa.sql

[<car...@us...>]

Revision: 564
          http://phenoscape.svn.sourceforge.net/phenoscape/?rev=564&view=rev
Author:   cartik73
Date:     2009-03-26 21:57:00 +0000 (Thu, 26 Mar 2009)

Log Message:
-----------
Made query more specific

Modified Paths:
--------------
    trunk/src/Database/sql/tests/SpecimenInfoFromTaxa.sql

Modified: trunk/src/Database/sql/tests/SpecimenInfoFromTaxa.sql
===================================================================
--- trunk/src/Database/sql/tests/SpecimenInfoFromTaxa.sql	2009-03-26 21:16:16 UTC (rev 563)
+++ trunk/src/Database/sql/tests/SpecimenInfoFromTaxa.sql	2009-03-26 21:57:00 UTC (rev 564)
@@ -20,5 +20,5 @@
 AND
 otu_link.predicate_id = (SELECT node_id FROM node WHERE uid = 'PHENOSCAPE:has_taxon') AND
 specimen_link.predicate_id = (SELECT node_id FROM node WHERE uid = 'PHENOSCAPE:has_specimen') AND 
-taxon_node.node_id IN (SELECT node_id FROM node WHERE uid LIKE 'TTO:%') 
+taxon_node.node_id = (SELECT node_id FROM node WHERE uid = 'TTO:0') 
 ORDER BY taxonId;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.