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.14102873s
Average test duration 4.273598ms
Execution date (UTC) Mar 16, 2023 12:08:54 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.006462771s
Average test duration 0.403923ms
Execution date (UTC) Mar 16, 2023 12:08:54 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.004956476s
Average test duration 0.309779ms
Execution date (UTC) Mar 16, 2023 12:08:54 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.004298581s
Average test duration 0.429858ms
Execution date (UTC) Mar 16, 2023 12:08:54 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.005233675s
Average test duration 2.616837ms
Execution date (UTC) Mar 16, 2023 12:08:54 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.00438048s
Average test duration 1.46016ms
Execution date (UTC) Mar 16, 2023 12:08:54 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.00203309s
Average test duration 0.677696ms
Execution date (UTC) Mar 16, 2023 12:08:54 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.024603184s
Average test duration 0.745551ms
Execution date (UTC) Mar 16, 2023 12:08:54 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.002924086s
Average test duration 1.462043ms
Execution date (UTC) Mar 16, 2023 12:08:54 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 0.001037795s
Average test duration 0.345931ms
Execution date (UTC) Mar 16, 2023 12:08:54 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.005630973s
Average test duration 1.876991ms
Execution date (UTC) Mar 16, 2023 12:08:54 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.009001357s
Average test duration 0.900135ms
Execution date (UTC) Mar 16, 2023 12:08:54 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.008401761s
Average test duration 1.200251ms
Execution date (UTC) Mar 16, 2023 12:08:55 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.001525393s
Average test duration 0.381348ms
Execution date (UTC) Mar 16, 2023 12:08:55 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 9.44096E-4s
Average test duration 0.472048ms
Execution date (UTC) Mar 16, 2023 12:08:55 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 9.08296E-4s
Average test duration 0.302765ms
Execution date (UTC) Mar 16, 2023 12:08:55 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.080638014s
Average test duration 1.832682ms
Execution date (UTC) Mar 16, 2023 12:08:55 PM
Clone this wiki locally