-
Notifications
You must be signed in to change notification settings - Fork 10
Master
ivoa edited this page Oct 19, 2023
·
4 revisions
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 33 (100%) |
| Total duration | 0.13420106s |
| Average test duration | 4.066698ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 16 (100%) |
| Total duration | 0.005528589s |
| Average test duration | 0.345536ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 16 (100%) |
| Total duration | 0.004596174s |
| Average test duration | 0.28726ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 10 (100%) |
| Total duration | 0.00307165s |
| Average test duration | 0.307165ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 2 (100%) |
| Total duration | 0.003452461s |
| Average test duration | 1.72623ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 3 (100%) |
| Total duration | 0.002659748s |
| Average test duration | 0.886582ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 3 (100%) |
| Total duration | 0.001348024s |
| Average test duration | 0.449341ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 33 (100%) |
| Total duration | 0.021986896s |
| Average test duration | 0.666269ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 2 (100%) |
| Total duration | 0.002089737s |
| Average test duration | 1.044868ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 3 (100%) |
| Total duration | 7.02213E-4s |
| Average test duration | 0.234071ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 3 (100%) |
| Total duration | 0.001581929s |
| Average test duration | 0.527309ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 10 (100%) |
| Total duration | 0.004971789s |
| Average test duration | 0.497178ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 7 (100%) |
| Total duration | 0.003207957s |
| Average test duration | 0.458279ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 4 (100%) |
| Total duration | 0.001530628s |
| Average test duration | 0.382657ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 2 (100%) |
| Total duration | 0.001625329s |
| Average test duration | 0.812664ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 3 (100%) |
| Total duration | 6.38911E-4s |
| Average test duration | 0.21297ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |
| 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 |
| GLOBAL RESULT | OK |
|---|---|
| Successful tests | 44 (100%) |
| Total duration | 0.052066337s |
| Average test duration | 1.183325ms |
| Execution date (UTC) | Oct 19, 2023 8:20:55 AM |