search

gmantele / vollt

Java libraries implementing the IVOA protocol: ADQL, UWS and TAP
http://cdsportal.u-strasbg.fr/taptuto/
29 stars 28 forks source link

ORDER BY does not accept table_name.column_name #113

Open almicol opened 5 years ago

almicol commented 5 years ago

A query like:

SELECT this.*, RA2000, DEC2000 from VVV_MPHOT_Ks_V2 as this, VVV_CAT_V2 as source_catalog
where this.SOURCEID = source_catalog.SOURCEID
ORDER BY this.SOURCEID

fails because the ORDER BY contains a dot; the error message is:

Incorrect ADQL query: Encountered ".". Was expecting one of: "," ";" "ASC" "DESC" "!

The way out would be to assign an alias to the "this.SOURCEID" column, but that would require painfully expanding this.* and list all the columns of the table "this", which the user clearly does not want to do.

Could TAPLIB support the syntax table_name.column_name in the ORDER BY?

gmantele commented 5 years ago

I agree, it is not normal. In practice, there is no technical difficulty to do that, but unfortunately it is not following the ADQL-2.0 standard.

Anyway don't worry. This is already fixed in ADQL-2.1 which I will start implementing in ADQL-Lib next week.