Problems with RegTAP, ADQL, natural joins, and MS SQL Server

[Menelaus Perdikeas]

Hi Markus, 

> Oh? What would that be? 

We've found that we can do queries using TopCAT (RegTAP option) matching against all of the exposed fields ( Short Name , Title , Subjects , ID , Publisher , Description ) or subsets of them thereof with the exception of the " Subjects " fields. 
When the " Subjects " field is checked the parsing fails. This can be either: (a) a bug in our configuration / integration of Gregory's ADQL library or (b) a bug in the ADQL library itself. 

I didn't have the time to get to the bottom of this and was hoping to resolve this during this Spring's InterOp. 

> Will you be in Edinburgh to 
> the Tech Forum? If so, that could be a good place to sit together 
> with Mark and optimise the query a bit. 

No, I was hoping to resolve the problem without asking Mark to accommodate us (since I guess every change in the queries emitted by TopCAT can disrupt other services as a side effect). 

Cheers, 
Menelaus. 



This message and any attachments are intended for the use of the addressee or addressees only.
The unauthorised disclosure, use, dissemination or copying (either in whole or in part) of its
content is not permitted.
If you received this message in error, please notify the sender and delete it from your system.
Emails can be altered and their integrity cannot be guaranteed by the sender.

Please consider the environment before printing this email.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ivoa.net/pipermail/registry/attachments/20160225/e1eef631/attachment.html>