Skip to content

Master

Jump to bottom
ivoa edited this page Mar 16, 2023 · 4 revisions

Whitespace

About the validation set

Key Value
Title Whitespace
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/0_whitespace.xml)
Publisher Heidelberg GAVO Data Center
Contact Jon Juaristi Campillo
Description ADQL whitespace and related trivial syntax test queries
Available tests 33

Summary

GLOBAL RESULT OK
Successful tests 33 (100%)
Total duration 0.15609485s
Average test duration 4.730146ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

1. SELECT

About the validation set

Key Value
Title 1. SELECT
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/1_select.xml)
Publisher CDS
Contact Gregory Mantelet
Description ADQL queries aiming to test the SELECT clause (column names, *, label/AS, DISTINCT, ...).
Available tests 16

Summary

GLOBAL RESULT OK
Successful tests 16 (100%)
Total duration 0.008216548s
Average test duration 0.513534ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

2. FROM

About the validation set

Key Value
Title 2. FROM
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/2_from.xml)
Publisher CDS
Contact Gregory Mantelet
Description ADQL queries aiming to test the FROM clause (single table, join, subquery).
Available tests 16

Summary

GLOBAL RESULT OK
Successful tests 16 (100%)
Total duration 0.005225724s
Average test duration 0.326607ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

3. WHERE

About the validation set

Key Value
Title 3. WHERE
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/3_where.xml)
Publisher CDS
Contact Gregory Mantelet
Description ADQL queries with simple native (i.e. mandatory) rows constraints.
Available tests 10

Summary

GLOBAL RESULT OK
Successful tests 10 (100%)
Total duration 0.003988368s
Average test duration 0.398836ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

4. Math functions

About the validation set

Key Value
Title 4. Math functions
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/4_math_functions.xml)
Publisher CDS
Contact Gregory Mantelet
Description ADQL queries using the mandatory mathematical and trigonometrical functions (cf 2.3 in ADQL-2.1).
Available tests 2

Summary

GLOBAL RESULT OK
Successful tests 2 (100%)
Total duration 0.003702657s
Average test duration 1.851328ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

5. Aggregate functions

About the validation set

Key Value
Title 5. Aggregate functions
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/5_aggregation.xml)
Publisher CDS
Contact Gregory Mantelet
Description ADQL queries with aggregate functions.
Available tests 3

Summary

GLOBAL RESULT OK
Successful tests 3 (100%)
Total duration 0.003724158s
Average test duration 1.241386ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

6. ORDER BY

About the validation set

Key Value
Title 6. ORDER BY
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/6_order_by.xml)
Publisher CDS
Contact Gregory Mantelet
Description ADQL queries aiming to test the ORDER BY clause.
Available tests 3

Summary

GLOBAL RESULT OK
Successful tests 3 (100%)
Total duration 0.001629369s
Average test duration 0.543123ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

Optional 1 - Geometries

About the validation set

Key Value
Title Optional 1 - Geometries
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/O1_geometrical_functions.xml)
Publisher Heidelberg GAVO Data Center
Contact Markus Demleitner
Description ADQL geometry test queries (cf 4.2 in ADQL-2.1): AREA, BOX, CENTROID, CIRCLE, CONTAINS, COORD1, COORD2, COORDSYS, DISTANCE, INTERSECTS, POINT, POLYGON, REGION.
Available tests 33

Summary

GLOBAL RESULT OK
Successful tests 33 (100%)
Total duration 0.021930132s
Average test duration 0.664549ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

Optional 2 - User Defined Functions

About the validation set

Key Value
Title Optional 2 - User Defined Functions
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/O2_user_defined_functions.xml)
Publisher CDS
Contact Gregory Mantelet
Description Optional User Defined Functions (UDF) (cf 4.3 in ADQL-2.1).
Available tests 2

Summary

GLOBAL RESULT OK
Successful tests 2 (100%)
Total duration 0.002778119s
Average test duration 1.389059ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

Optional 3. String functions and operators

About the validation set

Key Value
Title Optional 3. String functions and operators
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/O3_string_functions_and_operators.xml)
Publisher CDS
Contact Gregory Mantelet
Description Optional string functions (cf 4.4 in ADQL-2.1): LOWER, UPPER, ILIKE.
Available tests 3

Summary

GLOBAL RESULT OK
Successful tests 3 (100%)
Total duration 8.97438E-4s
Average test duration 0.299146ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

Optional 4 - Common Table Expressions

About the validation set

Key Value
Title Optional 4 - Common Table Expressions
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/O4_common_table_expression.xml)
Publisher CDS
Contact Gregory Mantelet
Description Optional Common Table Expressions (CTE) (cf 4.5 in ADQL-2.1): WITH.
Available tests 3

Summary

GLOBAL RESULT OK
Successful tests 3 (100%)
Total duration 0.001905081s
Average test duration 0.635027ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

Optional 5 - Set operators

About the validation set

Key Value
Title Optional 5 - Set operators
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/O5_set_operators.xml)
Publisher CDS
Contact Gregory Mantelet
Description Optional Set operators (cf 4.6 in ADQL-2.1): UNION, EXCEPT, INTERSECT.
Available tests 10

Summary

GLOBAL RESULT OK
Successful tests 10 (100%)
Total duration 0.006140061s
Average test duration 0.614006ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

Optional 6 - Type operations

About the validation set

Key Value
Title Optional 6 - Type operations
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/O6_type_operations.xml)
Publisher CDS
Contact Gregory Mantelet
Description Optional type operations (cf 4.7 in ADQL-2.1): CAST.
Available tests 7

Summary

GLOBAL RESULT OK
Successful tests 7 (100%)
Total duration 0.008168848s
Average test duration 1.166978ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

Optional 7 - Conditional functions.

About the validation set

Key Value
Title Optional 7 - Conditional functions.
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/O7_conditional_functions.xml)
Publisher CDS
Contact Gregory Mantelet
Description Optional conditional functions (cf 4.8 in ADQL-2.1): COALESCE.
Available tests 4

Summary

GLOBAL RESULT OK
Successful tests 4 (100%)
Total duration 0.002971427s
Average test duration 0.742856ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

Optional 8 - Unit operations.

About the validation set

Key Value
Title Optional 8 - Unit operations.
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/O8_unit_operations.xml)
Publisher CDS
Contact Gregory Mantelet
Description Optional unit operations (cf 4.9 in ADQL-2.1): IN_UNIT. Most of the errors can only be generated with a working ADQL service since unit has to be provided and then checked against the desired output unit.
Available tests 2

Summary

GLOBAL RESULT OK
Successful tests 2 (100%)
Total duration 0.001923982s
Average test duration 0.961991ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

Optional 9 - Cardinality

About the validation set

Key Value
Title Optional 9 - Cardinality
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/O9_cardinality.xml)
Publisher CDS
Contact Gregory Mantelet
Description Optional cardinality operators (cf 4.10 in ADQL-2.1): OFFSET.
Available tests 3

Summary

GLOBAL RESULT OK
Successful tests 3 (100%)
Total duration 8.88137E-4s
Average test duration 0.296045ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM

Extra 1 - ESO's Obscore queries sample

About the validation set

Key Value
Title Extra 1 - ESO's Obscore queries sample
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/X1_obscore_eso.xml)
Publisher ESO
Contact Alberto Micol
Description ADQL-2.1 queries on ivoa.ObsCore at ESO's TAP service.
Available tests 44

Summary

GLOBAL RESULT OK
Successful tests 44 (100%)
Total duration 0.08974402s
Average test duration 2.039636ms
Execution date (UTC) Mar 16, 2023 12:06:03 PM
Clone this wiki locally