almicol

pyvo user agent in case of authenticated queries

2

The user agent reported by pyvo v1.1 when performing an anonymous TAP query is: > python-pyvo/1.1 while instead when I perform an authenticated query the user agent is set to:...

subqueries not permitted after an operator like: =, !=, <, <= , >, >=

5

The following ADQL query: `SELECT top 20 t_min, obs_publisher_did, access_url FROM ivoa.ObsCore WHERE proposal_id like '072.C-0488%' AND t_min >= (SELECT t_min FROM ivoa.ObsCore WHERE obs_publisher_did = 'ivo://eso.org/ID?ADP.2014-09-26T16:51:34.173' ) ORDER BY...

ADQL Parser failing on s_region declared as per TAP1.1 (via xtype)

1

According to TAP1.1, I set the ivoa.ObsCore s_region field in TAP_SCHEMA.columns as follows: - datatype=”char” - arraysize=”*” - xtype=”adql:REGION” When querying with a constraint like: INTERSECTS(s_region,...)=1 , the ADQL Parser...

executionDuration not respected for certain output formats

9

Hi Grégory, Depending on the output format selected, a job could still run after having reached the executionDuration limit. This can cause stress to the database server, hence we are...

ORDER BY does not accept table_name.column_name

1

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...

Wrong ADQL to SQL translation: alias not unique

1

The following query: SELECT top 10 a.dec2000, b.dec2000 FROM ph3_mcatalog_fits_V2 a, ph3_mcatalog_fits_V2 b WHERE a.dec2000 between b.dec2000 -0.1 and b.dec2000 + 0.1 and b.ra2000 > a.ra2000 and b.ra2000 < a.ra2000+0.1...

UWS: delay destruction of a job returns an error if new destruction datetime is in the past

1

LOW PRIORITY I have a UWS job in PENDING status; If I change the destruction date to a future date, the system works as expected. If I change the destruction...

Could UNION be supported?

1

Apparently the UNION operator is not supported by your grammar. Would it be possible to add it? Thanks, Alberto

CASE statement in ADQLParser & ADQL Reserved Words

6

If I issue a query containing a CASE statement I get an error. Example: SELECT top 10 CASE WHEN calib_level = 2 THEN 'default' ELSE 'higher_level' END as level FROM...

is_clockwise() returning False if points on a great circle, whatever orientation chosen

3

Hi Bernie, I noticed that the is_clockwise() function will return False (hence CCW) for both these two polygons: A: (0, 0) (90, 0) (180, 0) (270, 0) (360=0, 0) and...