search

gmantele / vollt

Java libraries implementing the IVOA protocol: ADQL, UWS and TAP
http://cdsportal.u-strasbg.fr/taptuto/
29 stars 28 forks source link

" Invalid ADQL regular identifier" when != operator used #121

Closed gmantele closed 3 years ago

gmantele commented 4 years ago

The legitimate query: SELECT mycol FROM mytab WHERE mycol!='toto'

returns the error: Invalid ADQL regular identifier: : "mycol!"! If it aims to be a column/table name/alias, you should write it between double quotes.

Issue initially raised by @almicol in issue 38 of https://github.com/ivoa-std/ADQL

gmantele commented 4 years ago

Adding a space between mycol and the ! (or writting <> instead of !=) seems to solve the problem.

But the way you wrote it should perfectly work. I'll start working on this issue and I'll keep you up-to-date ;-)