Validation of TAP_SCHEMA.columns

[Marco Molinaro]

Hi James, all,
TAP-1.1 will feature an _arraysize_ or _datasize_ column name alongside the
1.0 _size_ name for that column that is known to be a clash with ADQL
reserved words.
Double quoting "size" in query statements should be the temporary solution
for it.

See http://wiki.ivoa.net/twiki/bin/view/IVOA/TAP-1_0-Next "Erratum 4" for a
more complete (I hope) view of this issue.

Cheers,
    Marco

2015-11-23 22:25 GMT+01:00 Tom McGlynn (NASA/GSFC Code 660.1) <
tom.mcglynn at nasa.gov>:

> Just to be clear on the attributions: That's TAP Lint which is actually
> giving the error.  The HEASARC just runs TAP lint  on all of the TAP
> services and records the results.
>
> This is a well known problem.  I think the usual solution is to use double
> quotes whenever you give the refer to this column. I.e., the column name
> should be given as
>    "size"
> rather than
>    size
>
>
>     Tom McGlynn
>
>
> James.Dempsey at csiro.au wrote:
>
>>
>> Hi,
>>
>> In registering our new TAP service I’ve come across a clash in standards
>> with the validation of the TAP_SCHEMA.columns table.
>>
>> The TAP 1.0 standard defines the columns table in section 2.6.3. It
>> includes a size column, however the report by the HEASARC validator lists
>> this as a breach of the ADQL standard.
>>
>> E-TME-CRSV-1
>>
>>
>>
>> Column name is ADQL reserved word 'size' in table TAP_SCHEMA.col...
>>
>> Is there a generally accepted resolution to this issue?
>>
>> Cheers,
>>
>> *James Dempsey*
>> Java Technical Lead*|*Applications
>> Information Management & Technology (IM&T)
>>
>> CSIRO
>>
>> Ejames.dempsey at csiro.au T +61 2 6214 2912
>> PO BOX 225, Dickson  ACT 2602
>>
>> www.csiro.au
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ivoa.net/pipermail/dal/attachments/20151124/9ed5af5b/attachment.html>