ADQL using reserved words in tables

[ada nebot]

Hi, 

I’m using the latest version of TOPCAT: V4.6-3
Selected the service: https://gea.esac.esa.int/tap-server/tap <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> 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 +44-117-9288776  http://www.star.bris.ac.uk/~mbt/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ivoa.net/pipermail/dal/attachments/20191114/ae7e2c7a/attachment.html>