[JUDDI-3] Broken FindTModelByCategoryQuery

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Assignee: Andrew Scott Cutright
• Reporter: Anoubhama Manavalan
• Created: 17/Jan/04 22:55
• Updated: 19/Feb/04 19:33
• Resolved: 19/Feb/04 19:33

Description

this UDDI query:

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<find_tModel generic="2.0"
xmlns="urn:uddi-org:api_v2">
<categoryBag>
<keyedReference keyValue="categorization"
tModelKey="uuid:c1acf26d-9672-4404-9d70-39b756e62ab4"/>
</categoryBag>
</find_tModel>
</soapenv:Body>
</soapenv:Envelope>

generates this SQL:

SELECT M.TMODEL_KEY,M.LAST_UPDATE FROM TMODEL
M,TMODEL_CATEGORY C WHERE
M.TMODEL_KEY = C.TMODEL_KEY AND ((C.KEY_NAME = '' AND
C.KEY_VALUE =
'categorization')) ORDER BY M.LAST_UPDATE DESC

which returns an empty result set, since all the
categorization tmodels
have names.