[Debian-astro-maintainers] Bug#985396: Parsing non-trivial ADQL is broken

[Markus Demleitner]

Package: gavodachs2-server
Version: 2.3+dfsg-1
Severety: important

ADQL more complex than the most trivial queries is totally misparsed.  See, for
instance:

	curl -FLANG=ADQL \
		-FQUERY="SELECT TOP 1 * FROM tap_schema.tables natural join tap_schema.columns" \
		http://localhost:8080/tap/sync -FFORMAT=votable/td

This produces an error message like:

	syntax error at or near "."
	LINE 1: ...97152823d0" CURSOR WITHOUT HOLD FOR SELECT natural.schema_na...

(rather than a proper response as when the query is not mangled to
"SELECT natural.schema...").

The reason for this is that pyparsing 2.4, as in sid and bullseye, has a
few API changes that break DaCHS' parsers for ADQL and STC; the
package tests have stupidly been run in a buster system (I can say
that because it was me who did that), so this went unnoticed.

As running ADQL queries through TAP probably is what most deployers of
this package are after, that's a fairly bad blow.