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

[Theresa Dower]

Hello!

Not to bog down the whole list bug hunting, but for what it’s worth we’re using Gregory’s library (with a new “SQLServer” class on top) and queries returning res_subject columns currently work. If it’s a bug in the library itself (possible!) it’s database dependent.

I had already been considering setting aside some space in the Interop’s registry sessions for those of us working on RegTAP or clients to go over our found issues, especially as (noted below) changes can unfortunately still have side effects for other architecture. I am also planning on having some hack time with the folks at ROE and JHU using SQL Server for TAP. Would it be helpful to have a short forum and formally schedule a side workshop?

--Theresa Dower

From: registry-bounces at ivoa.net [mailto:registry-bounces at ivoa.net] On Behalf Of Menelaus Perdikeas
Sent: Thursday, February 25, 2016 8:03 AM
To: Markus Demleitner
Cc: registry at ivoa.net
Subject: Re: Problems with RegTAP, ADQL, natural joins, and MS SQL Server

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/3e5a7d5d/attachment-0001.html>