Skip to content

Master

Jump to bottom
ivoa edited this page Jan 28, 2022 · 4 revisions

ADQL Validation report

About the validation set

Key Value
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/ivoa/simple.xml)
Publisher CDS
Contact Gregory Mantelet
Description The simplest ADQL queries ever.
Available tests 2

Summary

GLOBAL RESULT OK
Successful tests 2 (100%)
Total duration 0.008514892s
Average test duration 4.257446ms
Execution date (UTC) Jan 28, 2022 12:35:58 AM

ADQL Validation report

About the validation set

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

Summary

GLOBAL RESULT 6 FAILED
Successful tests 29 (82%)
Total duration 0.09623539s
Average test duration 2.749582ms
Execution date (UTC) Jan 28, 2022 12:35:58 AM

Validation tests

Listing

# UUID Status
18 7e1c042a-4d02-11e6-a088-7368e607ac72 FAILED
19 8f1cd39e-4d02-11e6-a088-7368e607ac72 FAILED
22 d4c3a72c-4458-11e6-96e2-28b2bdcff70b FAILED
23 dbef92f4-4458-11e6-96e2-28b2bdcff70b FAILED
30 1f5d27dc-450c-11e6-8564-332de33a5c03 FAILED
34 a66c56e6-f18d-11e8-96df-28d244962af0 FAILED

18

  • UUID: 7e1c042a-4d02-11e6-a088-7368e607ac72

  • Description:

    with set limit

  • Query:

    select top 3 * from x 
		union (

		select top 40 a from y 
			except select * from z

		)

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.261997ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

19

  • UUID: 8f1cd39e-4d02-11e6-a088-7368e607ac72

  • Description:

    deep set limit

  • Query:

    select * from (
		select TOP 30 * from x

		) as q 
		union

		select TOP 4 * from u

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.394095ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "," ";" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

22

  • UUID: d4c3a72c-4458-11e6-96e2-28b2bdcff70b

  • Description:

    Various join forms

  • Query:

    select x from t1 INNER JOIN (t2
		JOIN

		t3)

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 64.538186ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered ")". Was expecting one of: "." "AS" "ON" "USING" """ <REGULAR_IDENTIFIER_CANDIDATE>

23

  • UUID: dbef92f4-4458-11e6-96e2-28b2bdcff70b

  • Description:

    Various join forms

  • Query:

    select x from (
		t1 JOIN t4

		) FULL OUTER JOIN (
		t2 JOIN t3

		)

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.321495ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered ")". Was expecting one of: "." "AS" "ON" "USING" """ <REGULAR_IDENTIFIER_CANDIDATE>

30

  • UUID: 1f5d27dc-450c-11e6-8564-332de33a5c03

  • Description:

    subqueries join

  • Query:

    select * from ( select * from urks.a, b, ( select * from c, monk.d ) as q ) as r join ( select * from x, y ) as p

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.904688ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "". Was expecting one of: "ON" "USING"

34

  • UUID: a66c56e6-f18d-11e8-96df-28d244962af0

  • Description:

    Order by internal whitespace and stuck sort direction

  • Query:

    select * from bar order   by foo asc, 2desc

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.722891ms

    • Status: FAILED

    • Error:

      Parsing error: Invalid ADQL regular identifier: "2desc"! (HINT: If it aims to be a column/table name/alias, you should write it between double quotes.)

ADQL Validation report

About the validation set

Key Value
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/gavo/subqueries.xml)
Publisher Heidelberg GAVO Data Center
Contact Markus Demleitner
Description ADQL queries including subqueries
Available tests 5

Summary

GLOBAL RESULT 2 FAILED
Successful tests 3 (60%)
Total duration 0.002052174s
Average test duration 0.410434ms
Execution date (UTC) Jan 28, 2022 12:35:58 AM

Validation tests

Listing

# UUID Status
4 e257048e-450b-11e6-a621-b59840aabaf1 FAILED
5 1f5d27dc-450c-11e6-8564-332de33a5c03 FAILED

4

  • UUID: e257048e-450b-11e6-a621-b59840aabaf1

  • Description:

    nested subquery

  • Query:

    select * from (select * from a,b, (select * from c,d) as q) as r join (select * from x,y) as p

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.498994ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "". Was expecting one of: "ON" "USING"

5

  • UUID: 1f5d27dc-450c-11e6-8564-332de33a5c03

  • Description:

    subqueries join

  • Query:

    select * from (select * from urks.a,b, (select * from c,monk.d) as q) as r join (select * from x,y) as p

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.538493ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "". Was expecting one of: "ON" "USING"

ADQL Validation report

About the validation set

Key Value
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/gavo/warts.xml)
Publisher Heidelberg GAVO Data Center
Contact Markus Demleitner
Description Warts: Expressions Markus would rather have fail
Available tests 3

Summary

GLOBAL RESULT 3 FAILED
Successful tests 0 (0%)
Total duration 0.004026349s
Average test duration 1.342116ms
Execution date (UTC) Jan 28, 2022 12:35:58 AM

Validation tests

Listing

# UUID Status
1 118c7d86-4509-11e6-b60c-9d2c33f9b7a2 FAILED
2 1aa0786e-4509-11e6-b60c-9d2c33f9b7a2 FAILED
3 d0725dde-450d-11e6-b20b-6d529bdffd4c FAILED

1

  • UUID: 118c7d86-4509-11e6-b60c-9d2c33f9b7a2

  • Description:

    WART: Integer literal accepted as centroid argument

  • Query:

    select x from y where CENTROID(3)=x

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.278397ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "3". Was expecting one of: "BOX" "CENTROID" "CIRCLE" "POINT" "POLYGON" "REGION" "CAST" """ <REGULAR_IDENTIFIER_CANDIDATE> <REGULAR_IDENTIFIER_CANDIDATE>

2

  • UUID: 1aa0786e-4509-11e6-b60c-9d2c33f9b7a2

  • Description:

    WART: aggregate function accepted as centroid argument

  • Query:

    select x from y where CENTROID(COUNT(*))=x

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.235697ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "COUNT". Was expecting one of: "BOX" "CENTROID" "CIRCLE" "POINT" "POLYGON" "REGION" "CAST" """ <REGULAR_IDENTIFIER_CANDIDATE> <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "COUNT" is a reserved ADQL word in v2.1. To use it as a column/table/schema name/alias, write it between double quotes.)

3

  • UUID: d0725dde-450d-11e6-b20b-6d529bdffd4c

  • Description:

    WART: string literals accepted as coordinate value.

  • Query:

    SELECT * FROM y WHERE 1=CONTAINS(POINT('ICRS',x,'sy') ,CIRCLE('ICRS',x,y,z))

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 3.512255ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "'sy'". Was expecting one of: "(" "+" "-" "AVG" "MAX" "MIN" "SUM" "COUNT" <SCIENTIFIC_NUMBER> <UNSIGNED_FLOAT> <UNSIGNED_INTEGER> """ <REGULAR_IDENTIFIER_CANDIDATE> "+" "-" <REGULAR_IDENTIFIER_CANDIDATE> <SCIENTIFIC_NUMBER> <UNSIGNED_FLOAT> <UNSIGNED_INTEGER> <REGULAR_IDENTIFIER_CANDIDATE> """ "COUNT" "AVG" "MAX" "MIN" "SUM" "(" <REGULAR_IDENTIFIER_CANDIDATE>

ADQL Validation report

About the validation set

Key Value
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/gavo/geometry.xml)
Publisher Heidelberg GAVO Data Center
Contact Markus Demleitner
Description ADQL geometry test queries
Available tests 33

Summary

GLOBAL RESULT 3 FAILED
Successful tests 30 (90%)
Total duration 0.020329641s
Average test duration 0.616049ms
Execution date (UTC) Jan 28, 2022 12:35:58 AM

Validation tests

Listing

# UUID Status
1 ccd99070-4508-11e6-b60c-9d2c33f9b7a2 FAILED
12 898cf934-450c-11e6-8564-332de33a5c03 FAILED
21 b8bca746-4cfe-11e6-b1bc-3d3af74034fa FAILED

1

  • UUID: ccd99070-4508-11e6-b60c-9d2c33f9b7a2

  • Description:

    Simple geometry predicates

  • Query:

    select x from y where Point(NULL, 2, 3)=x

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.349896ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "NULL". Was expecting one of: "(" "+" "-" "AVG" "MAX" "MIN" "SUM" "COUNT" "'" <SCIENTIFIC_NUMBER> <UNSIGNED_FLOAT> <UNSIGNED_INTEGER> """ <REGULAR_IDENTIFIER_CANDIDATE> <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "NULL" is a reserved ADQL word in v2.1. To use it as a column/table/schema name/alias, write it between double quotes.)

12

  • UUID: 898cf934-450c-11e6-8564-332de33a5c03

  • Description:

    bad coordinate system accepted at the grammar level

  • Query:

    select point('QUARK', 1, 2) from spatial

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 1.023887ms

    • Status: FAILED

    • Error:

      Parsing error: 1 unsupported expressions!

      • Incorrect syntax: "QUARK" was unexpected! Expected syntax: "[(ECLIPTIC|FK4|FK5|J2000|GALACTIC|ICRS|UNKNOWNFRAME)] [(BARYCENTER|GEOCENTER|HELIOCENTER|LSR|TOPOCENTER|RELOCATABLE|UNKNOWNREFPOS)] [(CARTESIAN2|CARTESIAN3|SPHERICAL2)]" ; an empty string is also allowed and will be interpreted as the coordinate system locally used.

21

  • UUID: b8bca746-4cfe-11e6-b1bc-3d3af74034fa

  • Description:

    metadata inference samples

  • Query:

    select point(NULL, ra1, 2) from spatial

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.198598ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "NULL". Was expecting one of: "(" "+" "-" "AVG" "MAX" "MIN" "SUM" "COUNT" "'" <SCIENTIFIC_NUMBER> <UNSIGNED_FLOAT> <UNSIGNED_INTEGER> """ <REGULAR_IDENTIFIER_CANDIDATE> <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "NULL" is a reserved ADQL word in v2.1. To use it as a column/table/schema name/alias, write it between double quotes.)

ADQL Validation report

About the validation set

Key Value
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/gavo/additionaltests.xml)
Publisher Heidelberg GAVO Data Center
Contact Jon Juaristi Campillo
Description Additional simple cases for things for the ADQL parser. Some are syntactically correct but might be semantically incorrect.
Available tests 6

Summary

GLOBAL RESULT 1 FAILED
Successful tests 5 (83%)
Total duration 0.026626464s
Average test duration 4.437744ms
Execution date (UTC) Jan 28, 2022 12:35:59 AM

Validation tests

Listing

# UUID Status
6 8b9aa804-59b3-11ec-beef-28d2445a8967 FAILED

6

  • UUID: 8b9aa804-59b3-11ec-beef-28d2445a8967

  • Description:

    Numeric operands and strings mix.

  • Query:

    SELECT '30'*1323
			from Y

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.119398ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "*". Was expecting one of: "," "FROM" "AS" "'" """ <REGULAR_IDENTIFIER_CANDIDATE> "'" "'"

ADQL Validation report

About the validation set

Key Value
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/gavo/regressionlike.xml)
Publisher Heidelberg GAVO Data Center
Contact Markus Demleitner
Description Regression test-like queries (in DaCHS, these are used
to make assertions on how these things morph)
Available tests 14

Summary

GLOBAL RESULT 2 FAILED
Successful tests 12 (85%)
Total duration 0.005927825s
Average test duration 0.423416ms
Execution date (UTC) Jan 28, 2022 12:35:59 AM

Validation tests

Listing

# UUID Status
13 56f8b6f0-59b2-11ec-9317-28d2445a8967 FAILED
14 704b5b76-59b2-11ec-ac92-28d2445a8967 FAILED

13

  • UUID: 56f8b6f0-59b2-11ec-9317-28d2445a8967

  • Description:

    COALESCE in select list

  • Query:

    SELECT COALESCE(a, b, c,d) FROM x

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.151498ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "COALESCE". Was expecting one of: "(" "+" "-" "*" "TOP" "AVG" "MAX" "MIN" "SUM" "COUNT" "BOX" "CENTROID" "CIRCLE" "POINT" "POLYGON" "REGION" "CONTAINS" "INTERSECTS" "AREA" "COORD1" "COORD2" "COORDSYS" "DISTANCE" "CAST" "LOWER" "UPPER" "ABS" "CEILING" "DEGREES" "EXP" "FLOOR" "LOG" "LOG10" "MOD" "PI" "POWER" "RADIANS" "RAND" "ROUND" "SQRT" "TRUNCATE" "ACOS" "ASIN" "ATAN" "ATAN2" "COS" "COT" "SIN" "TAN" "IN_UNIT" "'" <SCIENTIFIC_NUMBER> <UNSIGNED_FLOAT> <UNSIGNED_INTEGER> """ <REGULAR_IDENTIFIER_CANDIDATE> <REGULAR_IDENTIFIER_CANDIDATE> """ (HINT: "COALESCE" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

14

  • UUID: 704b5b76-59b2-11ec-ac92-28d2445a8967

  • Description:

    COALESCE in condition

  • Query:

    SELECT count(*) FROM x
WHERE COALESCE(a, b, c) = 0

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.178498ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "COALESCE". Was expecting one of: "(" "+" "-" "NOT" "EXISTS" "AVG" "MAX" "MIN" "SUM" "COUNT" "BOX" "CENTROID" "CIRCLE" "POINT" "POLYGON" "REGION" "CONTAINS" "INTERSECTS" "AREA" "COORD1" "COORD2" "COORDSYS" "DISTANCE" "CAST" "LOWER" "UPPER" "ABS" "CEILING" "DEGREES" "EXP" "FLOOR" "LOG" "LOG10" "MOD" "PI" "POWER" "RADIANS" "RAND" "ROUND" "SQRT" "TRUNCATE" "ACOS" "ASIN" "ATAN" "ATAN2" "COS" "COT" "SIN" "TAN" "IN_UNIT" "'" <SCIENTIFIC_NUMBER> <UNSIGNED_FLOAT> <UNSIGNED_INTEGER> """ <REGULAR_IDENTIFIER_CANDIDATE> "(" (HINT: "COALESCE" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

ADQL Validation report

About the validation set

Key Value
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/gavo/setexpressions.xml)
Publisher Heidelberg GAVO Data Center
Contact Markus Demleitner
Description MISSING: Global description of these queries
Available tests 14

Summary

GLOBAL RESULT 14 FAILED
Successful tests 0 (0%)
Total duration 0.002306172s
Average test duration 0.164726ms
Execution date (UTC) Jan 28, 2022 12:35:59 AM

Validation tests

Listing

# UUID Status
1 16cdfdc2-450b-11e6-8afd-a735f38de45d FAILED
2 1cd5382a-450b-11e6-8afd-a735f38de45d FAILED
3 21149188-450b-11e6-8afd-a735f38de45d FAILED
4 25282b72-450b-11e6-8afd-a735f38de45d FAILED
5 32eebe4c-450b-11e6-8afd-a735f38de45d FAILED
6 3aa8630e-450b-11e6-8afd-a735f38de45d FAILED
7 3e9fec2a-450b-11e6-8afd-a735f38de45d FAILED
8 c5158c64-450c-11e6-8c47-9df4f9c4341c FAILED
9 d8333422-450c-11e6-8c47-9df4f9c4341c FAILED
10 04059d6c-4cfe-11e6-b43c-5d3a7f1259a0 FAILED
11 32ce371c-4cfe-11e6-b43c-5d3a7f1259a0 FAILED
12 5c93a1ae-4cfe-11e6-b43c-5d3a7f1259a0 FAILED
13 7e1c042a-4d02-11e6-a088-7368e607ac72 FAILED
14 8f1cd39e-4d02-11e6-a088-7368e607ac72 FAILED

1

  • UUID: 16cdfdc2-450b-11e6-8afd-a735f38de45d

  • Description:

    Valid set expressions

  • Query:

    select x from t1 union select x from t2

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.210898ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

2

  • UUID: 1cd5382a-450b-11e6-8afd-a735f38de45d

  • Description:

    Valid set expressions

  • Query:

    select x from t1 intersect select x from t2

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.151798ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "intersect". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "intersect" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

3

  • UUID: 21149188-450b-11e6-8afd-a735f38de45d

  • Description:

    Valid set expressions

  • Query:

    select x from t1 except select x from t2

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.147998ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "except". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "except" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

4

  • UUID: 25282b72-450b-11e6-8afd-a735f38de45d

  • Description:

    Valid set expressions

  • Query:

    select x from t1 where x
>
2 union select x from t2

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.248397ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: ";" "AND" "OR" "GROUP" "HAVING" "ORDER" "OFFSET" (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

5

  • UUID: 32eebe4c-450b-11e6-8afd-a735f38de45d

  • Description:

    Valid set expressions

  • Query:

    select * from t1 union select x from t2 intersect select x from t3  except select x from t4

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.129598ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

6

  • UUID: 3aa8630e-450b-11e6-8afd-a735f38de45d

  • Description:

    Valid set expressions

  • Query:

    select * from (select * from t1 except select * from t2) as q union select * from  t3

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.143398ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "except". Was expecting one of: ")" "." "," "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "except" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

7

  • UUID: 3e9fec2a-450b-11e6-8afd-a735f38de45d

  • Description:

    Valid set expressions

  • Query:

    select * from t1 union select foo from (select * from t2 except select * from t1) as q

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.131498ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

8

  • UUID: c5158c64-450c-11e6-8c47-9df4f9c4341c

  • Description:

    individual set limits

  • Query:

    select top 3 * from t1 union select top 4 * from t2 except select * from t3

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.134999ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

9

  • UUID: d8333422-450c-11e6-8c47-9df4f9c4341c

  • Description:

    individual set limits

  • Query:

    select top 7 * from t1 union (select top 4 * from t2 except select * from t3) except (select top 30 x from t4 except select top 3 y from t5)

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.126398ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

10

  • UUID: 04059d6c-4cfe-11e6-b43c-5d3a7f1259a0

  • Description:

    metadata inference

  • Query:

    select dist, height from spatial union select dist, height from spatial

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.186798ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

11

  • UUID: 32ce371c-4cfe-11e6-b43c-5d3a7f1259a0

  • Description:

    metadata inference

  • Query:

    select dist, height from spatial
	union select dist, ra1 as height from spatial2

	intersect select mass as dist, mag as height from misc
	except select "left-right" as dist, "plAin" as height from quoted

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.197698ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

12

  • UUID: 5c93a1ae-4cfe-11e6-b43c-5d3a7f1259a0

  • Description:

    metadata inference

  • Query:

    select dist, height from spatial
  union select ra1 as dist, dec as height from (

    select * from spatial
    except select mag as ra1, mass as dec, speed as dist from misc) as q

where dist
>
2

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.179398ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

13

  • UUID: 7e1c042a-4d02-11e6-a088-7368e607ac72

  • Description:

    with set limit

  • Query:

    select top 3 * from x union (select top 40 a from y except select * from z)

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.162798ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "." "," ";" "AS" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

14

  • UUID: 8f1cd39e-4d02-11e6-a088-7368e607ac72

  • Description:

    deep set limit

  • Query:

    select * from (select TOP 30 * from x) as q union
		select TOP 4 * from u

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.154498ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "union". Was expecting one of: "," ";" "WHERE" "GROUP" "HAVING" "ORDER" "OFFSET" (HINT: "union" is not supported in ADQL v2.1, but is however a reserved word. To use it as a column/table/schema name/alias, write it between double quotes.)

ADQL Validation report

About the validation set

Key Value
Origin File (/home/runner/work/lyonetia/lyonetia/src/adql/gavo/simpleunit.xml)
Publisher Heidelberg GAVO Data Center
Contact Markus Demleitner
Description Plain SQL queries from DaCHS' unittest suite
Available tests 173

Summary

GLOBAL RESULT 11 FAILED
Successful tests 162 (93%)
Total duration 0.06617106s
Average test duration 0.382491ms
Execution date (UTC) Jan 28, 2022 12:35:59 AM

Validation tests

Listing

# UUID Status
11 5e700476-4458-11e6-96e2-28b2bdcff70b FAILED
17 ab9be5d0-4458-11e6-96e2-28b2bdcff70b FAILED
19 b8823240-4458-11e6-96e2-28b2bdcff70b FAILED
20 bdcc3002-4458-11e6-96e2-28b2bdcff70b FAILED
21 c24cec5c-4458-11e6-96e2-28b2bdcff70b FAILED
24 d4c3a72c-4458-11e6-96e2-28b2bdcff70b FAILED
25 dbef92f4-4458-11e6-96e2-28b2bdcff70b FAILED
63 3a38115a-4509-11e6-8c55-592ac18c5eb7 FAILED
96 6ec4c4d8-450c-11e6-8564-332de33a5c03 FAILED
98 9db41c44-450c-11e6-8564-332de33a5c03 FAILED
161 50cf9e14-4cfd-11e6-9064-032db3af9290 FAILED

11

  • UUID: 5e700476-4458-11e6-96e2-28b2bdcff70b

  • Description:

    Correlation specification without AS or whitespace.

  • Query:

    SELECT 89x FROM z

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.094999ms

    • Status: FAILED

    • Error:

      Parsing error: Invalid ADQL regular identifier: "89x"! (HINT: If it aims to be a column/table name/alias, you should write it between double quotes.)

17

  • UUID: ab9be5d0-4458-11e6-96e2-28b2bdcff70b

  • Description:

    Anomalous join (this is allowed by the grammar but senseless; we should fix this in a grammar update (which is harmless because such queries have always been rejected

    by the database engines.

  • Query:

    select x from t1 JOIN t2

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.166297ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "". Was expecting one of: "." "AS" "ON" "USING" """ <REGULAR_IDENTIFIER_CANDIDATE>

19

  • UUID: b8823240-4458-11e6-96e2-28b2bdcff70b

  • Description:

    Various join forms

  • Query:

    select x from t1 LEFT OUTER JOIN t2

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.192098ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "". Was expecting one of: "." "AS" "ON" "USING" """ <REGULAR_IDENTIFIER_CANDIDATE>

20

  • UUID: bdcc3002-4458-11e6-96e2-28b2bdcff70b

  • Description:

    Various join forms

  • Query:

    select x from t1 RIGHT OUTER JOIN t2

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.179997ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "". Was expecting one of: "." "AS" "ON" "USING" """ <REGULAR_IDENTIFIER_CANDIDATE>

21

  • UUID: c24cec5c-4458-11e6-96e2-28b2bdcff70b

  • Description:

    Various join forms

  • Query:

    select x from t1 FULL OUTER JOIN t2

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.170198ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "". Was expecting one of: "." "AS" "ON" "USING" """ <REGULAR_IDENTIFIER_CANDIDATE>

24

  • UUID: d4c3a72c-4458-11e6-96e2-28b2bdcff70b

  • Description:

    Various join forms

  • Query:

    select x from t1 INNER JOIN (t2 JOIN t3)

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.176498ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered ")". Was expecting one of: "." "AS" "ON" "USING" """ <REGULAR_IDENTIFIER_CANDIDATE>

25

  • UUID: dbef92f4-4458-11e6-96e2-28b2bdcff70b

  • Description:

    Various join forms

  • Query:

    select x from (t1 JOIN t4) FULL OUTER JOIN (t2 JOIN t3)

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.132898ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered ")". Was expecting one of: "." "AS" "ON" "USING" """ <REGULAR_IDENTIFIER_CANDIDATE>

63

  • UUID: 3a38115a-4509-11e6-8c55-592ac18c5eb7

  • Description:

    predicates with bad function calls

  • Query:

    select x from y where TAN2(x)
<
3

  • ADQL version: v2.1

  • Expected: failure

  • Test:

    • Duration: 0.762891ms

    • Status: FAILED

    • Error:

      Unexpected test result.

96

  • UUID: 6ec4c4d8-450c-11e6-8564-332de33a5c03

  • Description:

    mixed comparison predicate

  • Query:

    select x from z where 5+9
>
'gaga'||'bla'

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.548693ms

    • Status: FAILED

    • Error:

      Parsing error: [java.lang.UnsupportedOperationException] Impossible to update the right operand of the comparison (5+9 NULL NULL) with "'gaga' || 'bla'" because its type is not compatible with the type of the left operand!

98

  • UUID: 9db41c44-450c-11e6-8564-332de33a5c03

  • Description:

    delimited table names

  • Query:

    select "abc-g".* from "abc-g" JOIN "select"

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.147298ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "". Was expecting one of: "." "AS" "ON" "USING" """ <REGULAR_IDENTIFIER_CANDIDATE>

161

  • UUID: 50cf9e14-4cfd-11e6-9064-032db3af9290

  • Description:

    metadata inference samples with joins

  • Query:

    SELECT * FROM spatial JOIN spatial2 WHERE dist
<
2

  • ADQL version: v2.1

  • Expected: success

  • Test:

    • Duration: 0.105499ms

    • Status: FAILED

    • Error:

      Parsing error: Encountered "WHERE". Was expecting one of: "." "AS" "ON" "USING" """ <REGULAR_IDENTIFIER_CANDIDATE> (HINT: "WHERE" is a reserved ADQL word in v2.1. To use it as a column/table/schema name/alias, write it between double quotes.)

Clone this wiki locally