ADQL using reserved words in tables

[Carlos Rodrigo]

Hi

This could be a very naive and stupid explanation but, just in case, I comment it

in your previous email you wrote:

SELECT TOP 10 * FROM “public”.hipparcos_newreduction

mark wrote:

select top 10 * from "public".hipparcos_newreduction

It seems that the double quote symbol is not the same one, ” vs "

When I wrote the query in topcat using the ” quotation I get an error. But it works well with the ".

Is there a chance that you were using a computer where the double quote was written with the ”
symbol instead of " ?

I often get silly problems with things like that.

Carlos

On 14/11/19 13:38, ada nebot wrote:”
> Hi, 
> 
> I’m using the latest version of TOPCAT: V4.6-3
> Selected the service: https://gea.esac.esa.int/tap-server/tap
> 
> I saw indeed the little warning hinting to use double quotes. 
> It was helpful, since that’s how I learnt at first the word was reserved, and how those should be 
> treated. But then I wasn’t able to solve the problem with double quotes. 
> 
> Now *something* (?) might have changed between the time I wrote the first email and now, 
> and the exact same ADQL line is working again on that server. 
> I can’t send you the error message since I can’t reproduce it and I didn’t take a screen shot. 
> 
> But I see Jon has pointed out some error too, so I guess it was the same error message. 
> 
> Cheers,
> Ada
> 
>> On 14 Nov 2019, at 12:14, Mark Taylor <M.B.Taylor at bristol.ac.uk <mailto:M.B.Taylor at bristol.ac.uk>>
>> wrote:
>>
>> Ada,
>>
>> you don't say what service you're using, but I can only see that
>> table in the ESA Gaia service.
>>
>> If I run
>>
>>   select top 10 * from "public".hipparcos_newreduction
>>
>> it works fine for me.  In fact even if I write
>>
>>   select top 10 * from public.hipparcos_newreduction
>>
>> the query works, though it signals a syntax error in the topcat ADQL
>> entry panel.  In the latter case, you can use the "Sticking plaster"
>> button at the far right of the lower toolbar to put the quotes in
>> automatically (that's a fairly recent introduction, so you need a
>> fairly recent topcat).
>>
>> Is that the service you're using?  Is the query really failing,
>> and if so, what's the error message?
>>
>> Mark
>>
>> On Thu, 14 Nov 2019, ada nebot wrote:
>>
>>> Hi,
>>>
>>> While performing a tutorial in a VO School we have seen that access through TAP using ADQL
>>> on tables/catalogues containing the reserved word public on them was not possible.
>>> We tried as stated in the documentation using double quotes around the word and lots of different
>>> combinations.  
>>> But that did not solve the issue. Has anyone a clue on how to do this?
>>>
>>> Thanks,
>>> Ada
>>>
>>> Here are the queries we tried:
>>>
>>> SELECT TOP 10 * FROM public.hipparcos_newreduction
>>>
>>> SELECT TOP 10 * FROM “public”.hipparcos_newreduction
>>>
>>> SELECT TOP 10 * FROM “public.hipparcos_newreduction”
>>>
>>> SELECT TOP 10 * FROM  'public’.hipparcos_newreduction
>>> …
>>> SELECT TOP 10 * FROM  ''public''.hipparcos_newreduction
>>> and even something like
>>>
>>> SELECT TOP 10 * FROM  \’public\’.hipparcos_newreduction
>>> …
>>>
>>>
>>>
>>
>> --
>> Mark Taylor   Astronomical Programmer   Physics, Bristol University, UK
>> m.b.taylor at bris.ac.uk <mailto:m.b.taylor at bris.ac.uk> +44-117-9288776  http://www.star.bris.ac.uk/~mbt/
>