[Bug] Table selector fails on Heasarc

[lmichel]

Describe the bug
service : //heasarc.gsfc.nasa.gov/xamin/vo/tap

the table selector does not work likely due to some bad encoded char in the query (;
 likely)

Th issue might go away if the \n is preceded by a space.

[galyfray]

almost everything doesn't work with this service it doesn't handle even simple joins ...

[lmichel]

When you run the table selector on that service with e.g.EIN as string pattern, you execute the following query string

SELECT TOP 500 TAP_SCHEMA.tables.table_name AS noField, TAP_SCHEMA.tables.schema_name AS schemaName, 
TAP_SCHEMA.tables.description AS tableDesc, TAP_SCHEMA.schemas.description AS schemDesc, 
TAP_SCHEMA.tables.table_name AS tableName 
FROM TAP_SCHEMA.tables 
WHERE ( ( UPPER(TAP_SCHEMA.tables.table_name) LIKE '%EIN%' ) )

The is a missing join between TAP_SCHEMA.tables and TAP_SCHEMA.schemas

[galyfray]

yes that's somehow half expected. As said earlier this services doesn't event support simple joins thus the API register no joins at all. The search bar can't work properly this way and thus should be disabled in such cases

[lmichel]

OK, but it runs wrong queries!
in this case the search tool should be replaced with an alert like: Sorry GUY

[lmichel]

still not working , error 400 in the console but nothing on the screen