Difference: RegTAPNext (1 vs. 3)

Revision 32019-02-06 - MarkusDemleitner

 
META TOPICPARENT name="IvoaResReg"
This page collects specification issues as well as proposals for extensions for VOResource.

A working draft for TAPRegExt 1.1 is available on volute: https://volute.g-vo.org/svn/trunk/projects/registry/TAPRegExt

Changed:
<
<

Proposed Errata

>
>

Known Issues

 
Deleted:
<
<

Query in 10.7 "Records from Registry"

(This erratum is obviated by the soon-to-be version 1.1 of the standard text)

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

Deleted:
<
<
<--  
-->


<--  
-->

Revision 22016-06-08 - MarkusDemleitner

 
META TOPICPARENT name="IvoaResReg"
Changed:
<
<
This page collects specification issues as well as proposals for extensions for VOResource. No new version of the document is scheduled right now.
>
>
This page collects specification issues as well as proposals for extensions for VOResource.
 
Added:
>
>
A working draft for TAPRegExt 1.1 is available on volute: https://volute.g-vo.org/svn/trunk/projects/registry/TAPRegExt
 

Proposed Errata

Query in 10.7 "Records from Registry"

Added:
>
>
(This erratum is obviated by the soon-to-be version 1.1 of the standard text)
 

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

Rationale

Changed:
<
<
As values in res_detail are no longer case-normalized (as they had been when
>
>
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.
Deleted:
<
<
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

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

Suggested Extensions

<--  
-->


<--  
-->

Revision 12015-03-23 - MarkusDemleitner

 
META TOPICPARENT name="IvoaResReg"
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

<--  
-->


<--  
-->
 
This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright © 2008-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback