(r1) RegTAP-1_0-Erratum-1 < IVOA

IVOA Web>IvoaResReg>RegTAP-1_0-Errata>RegTAP-1_0-Erratum-1 (revision 1) (raw view)~~EditAttach~~

---+ RegTAP 1.0 Erratum 1: Case insensitivity in an example query against res_details

---++ Rationale

The example query in 10.7 "Records from Registry" was written against an early draft of the RegTAP standard, when values in rr.res_detail were case-normalized. They no longer are in RegTAP 1.0 REC.

Therefore, the query as given in the REC-1.0 will not yield results for mixed-case authorities. It may be considered fortunate that the authorities in the examples are all mixed case, as users at least notice that the example query does not work as expected. Still, the document should give the correct query pattern.

---++ Erratum  Content

In section 10.7, &ldquo;Records from Registry&rdquo;, replace the current query,

<verbatim>
SELECT ivoid FROM rr.resource
RIGHT OUTER JOIN (
  SELECT 'ivo://' || detail_value || '%' AS pat FROM rr.res_detail
  WHERE detail_xpath='/managedAuthority' 
    AND ivoid='ivo://cds.vizier/registry') 
  AS authpatterns
ON (resource.ivoid LIKE authpatterns.pat)
</verbatim>

with

<verbatim>
SELECT ivoid FROM rr.resource
RIGHT OUTER JOIN (
  SELECT 'ivo://' || detail_value || '%' AS pat
  FROM rr.res_detail
  WHERE detail_xpath='/managedAuthority' 
    AND ivoid='ivo://cds.vizier/registry') 
  AS authpatterns
ON (1=ivo_nocasematch(resource.ivoid, authpatterns.pat))
</verbatim>

(i.e., employ case-insensitive matching in the join condition).
---+++ Impact assessment

As no normative text is changed, implementations are not concerned. Persons trying the example queries will be spared debugging.

Topic revision: r1 - 2019-02-06 - MarkusDemleitner

IVOA

Log in or Register

IVOA.net
Wiki Home
WebChanges
WebTopicList
WebStatistics

Twiki Meta & Help
IVOA
Know
Main
Sandbox
TWiki

TWiki intro
TWiki tutorial
User registration
Notify me

Working Groups

Interest Groups

Committees

Stds&Procs

www.ivoa.net
Documents
Events
Members
XML Schema