TWiki> IVOA Web>IvoaResReg>RegTAPNext (revision 1)EditAttach
This page collects specification issues as well as proposals for extensions for VOResource. No new version of the document is scheduled right now.

Proposed Errata

Query in 10.7 "Records from Registry"

Suggested Text

The exampe in section 10.7, "Records from Registry" should read

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))

Rationale

As values in res_detail are no longer case-normalized (as they had been when the example query was written), the query as given in the REC-1.0 will not yield results for mixed-case authorities (and as it happens, the authorities in the examples are all mixed case). The proposed new query works regardless of authority case.

Impact assessment

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

Suggested Extensions


Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions...
Topic revision: r1 - 2015-03-23 - MarkusDemleitner
 
This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback